Formula using Symbols and Check Box

MatthewVC · 08/17/21

Hello everyone, I'm trying to set up an equations to do two things:

1) When the check box is click (Complete column)

The Status will change to a BLUE dot (Status column)

2) When the check box is not click (Complete column)

The Status will change to a GREEN dot (Status column)

Can this be done? Right now I'm changing the symbols manually

Andrée Starå · 08/17/21

@MatthewVC

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 08/17/21

Hi @MatthewVC

I hope you're well and safe!

Try something like this.

=IF(Complete@row = 1, "Blue", "Green")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

MatthewVC · 08/17/21

https://community.smartsheet.com/discussion/comment/301805#Comment_301805

@Andrée Starå ..Thank you hope you are good as well.

This is close! I want it to actually use the blue or green dot symbol rather than the word. Is this undoable?

Andrée Starå · 08/17/21

@MatthewVC

Happy to help!

Glad to hear it, and I am as well!

Yes, you only need to change the column type to a symbol option that includes the blue dot.

Make sense?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

MatthewVC · 08/17/21

@Andrée Starå This worked yes! Now let me add one more additional part.

I also use the Yellow and Red dots in the same column, but when I change to one of those colors, the formula stops working.

Can I use the formula to control the Blue/Green, but also manually use the Yellow and Red in the same Status column. I sure hope this makes sense.

Andrée Starå · 08/17/21

@MatthewVC

Unfortunately, It's not possible to have a formula and be able to change it manually. Still, with so-called helper columns, you could change the value in one column, and the one with the formula would be the master.

Make sense?

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

MatthewVC · 08/17/21

@Andrée Starå .. This makes sense yes. Thank you so much for your help!!!!!

Andrée Starå · 08/17/21

@MatthewVC

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Formula using Symbols and Check Box

Best Answer

Answers

Help Article Resources

Categories