Hi, Vanessa.

If i understood correctly ( not an expert on Excel functionalities),

this seems to be a function/formula that you added in order to get it render as a checkmark in the cell?

Something like this is not exactly possible with our tables.

We do have certain calculation functions possible, such as SUM/AVG/MIN/MAX , 

if you wish you can check out this Documentation section with examples.

You can also create a formula/calculated column.

 (it can basically combine multiple columns for basic math operations)

And here is our Documentation with an example how you can present percentages, currency and other;

but as we pointed out in our Docs,

formulas in wpDataTables are not the same as formulas in Excel, so you won't be able to achieve it in this way.

There are ways to get a checkmark in our tables, though.

If you use a String Column, you can use Custom HTML to either load an image URL of a checkmark,

or try with custom HTML and CSS to construct the checkmark.

-

You can also make a solution with our Conditional Formatting.

 If you wish to make a condition that checks for any cell that has value as "1" or "2" or any other value,

you can then set it to change the content of this cell to a check symbol if the condition is matched.

First add a Conditional Rule to a String column.

( You can see more details about how our Conditional Formatting works here)

Then you can add the content that will transform the cell if the condition is met.

-

Perhaps the easiest way is to get an image of a symbol you need, upload it to the Media Library ( or you can use an image URL from anywhere, basically),

and you can add custom HTML with the image tag to show the image in the cell.

For example, if you wish to copy this same image of a 'green checker symbol' as on this example "Amazon products table", you can use this HTML:

<img src="https://wpdatatables.com/wp-content/uploads/2021/07/icon-yes.png" class="aligncenter size-thumbnail lazyloaded" width="20" height="20">

And the green checker symbol should look like this in the table cell(s) :

I made a small example on a table.  if i want to do this on the ID column for my table here :

I will add this Condition to the Column ID :

-

And the cell that had value 1 turns out like this :

Let me know if can work for your use-case.

 Thanks

Hi, Vanessa.

You're welcome, i'm happy to help.

Let me know how it goes.

Thanks.

Hi, Vanessa.

My apologies for a late reply.

I am delighted to hear that this has been resolved. Thank you for letting us know. Anything else that we could assist with, please don't hesitate to create new tickets.

Have a great day!