Formula for If Date is Blank or Not Blank, set Status symbol to Red/Green


Hi everyone!!

I am struggling with finding the correct formula to indicate status of task (shown by symbols) based on if a date is submitted into another cell.

In words, I'd like to have the formula be set to make the status symbol "Green" if Column "Date" is not blank. I would also like the formula to make the status symbol "Red" if Column "Date" is blank.

Can anyone assist me? Hopefully I'm explaining that well enough!

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!