Formula help

dave.mcpherson56751 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


I am working hard to get my head around formulas and have managed to get the correct return with the below formula, if greater than 14 days then return "Yes", if less than 14 days then return no. Where i am struggling is i also want to return "Yes" if the cell is blank.

current formula: =IF([Days since last clean]1 <= 14, "No", IF([Days since last clean]1 > 14, "Yes"))

Any help would be appreciated.

Thank you




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!