Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Smartsheet Behaviours

✭✭✭
edited 08/02/23 in Formulas and Functions

I am trying to create a form that throws back a response when you tick a box like the example below. I have been told to use the logic but i cant seem to find a logic that will work, any suggestions?

Additionally, if they tick an answer and it is incorrect, I want to show the text in red and if correct the text is in green. Does anyone know if this can be done?

image.png


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions