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.
if and statement with concat cells
[R4R] - green or red
[Adjusted] - green or yellow
if green and green cell = [MS1]
if green and yellow cell = [MS2]
but the data in MS1 & MS2 are concat from multiple cells in the same row.
the formula says the argument is wrong.
Does anyone know if possible?
Best Answer
Answers
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!