Formula with star symbol

Marie Eastman

HI,

 

I was trying to use a formula with symbol.

 

Here is the formula I wrote. The formula is working but I would like it to be the symbol Starred/Not Starred and not the words. My column property is symbol.

 

=IF(Status1 = "Done", "Starred", "Not Starred")

 

What am I doing wrong?

 

thanks

Marie

Kennedy Stomps

Hi Marie-- Great question! When using the Starred/Not Starred symbol option, you'll want to use the values 1 (for starred) and 0 (for not starred), rather than the text values. So, your formula should look like: 

 

=IF(Status1 = "Done", 1, 0)

 

This is the same for the Flagged/Not Flagged symbol option and checkboxes as well. Hope that helps!

 

 

Marie Eastman

Thank you that worked perfectly!