Formula assistance

I have 3 columns (Health, Status, Due Date) and im struggling to get my formula right to activate the health symbol in my health column. Please assist. The status column is straight forward (In progress, Not Started and Complete).

Please can someone assist?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!