SS FORMULA HELP

ssuser01

Hello Everyone!

In need of help with a check box formula. What I am trying to do is as follows:

If the row has a check box in the field, then add an icon in this box in another field And if the box is not checked then add this icon.

What I have for my formula right now is: =IF(AND([Field Name@row = 1), UNICHAR(9989), IF(AND([Field Name@row = 0), UNICHAR(9940)

Jesse G.

Hi,
I made a formula which in my simulation with ur columns works perfectly:

=IF([Q1 Review/Update Completed]@row = 1, UNICHAR(9989), IF([Q1 Review/Update Completed]@row = 0, UNICHAR(9940), "Error"))

I don't know if the titles are exactly correct, but the formula itself works for me. Can you give this a try?

Kind regards,

Jesse - The Smartsheet Enthousiast.

Jesse G.

Hi,
I made a formula which in my simulation with ur columns works perfectly:

=IF([Q1 Review/Update Completed]@row = 1, UNICHAR(9989), IF([Q1 Review/Update Completed]@row = 0, UNICHAR(9940), "Error"))

I don't know if the titles are exactly correct, but the formula itself works for me. Can you give this a try?

Kind regards,

Jesse - The Smartsheet Enthousiast.

ssuser01

@Jesse G. how come you added the comment error?

Jesse G.

That was just for myself to see if it worked or not. You can delete it or change it in something else. I forgot to delete it before sending.

Jesse G.

I hope the issue is fixed?

ssuser01

@Jesse G. It did work! Thank you.