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

Options

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!

• ✭✭✭✭✭✭
Options

Try this:

=IF(Date@row <> "", "Green", "Red")

• ✭✭✭✭✭✭
Options

Try this:

=IF(Date@row <> "", "Green", "Red")

• Options

Thank you so much, Paul!!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

• Options

Hi all!

I'm curious how to invert and add onto this formula to set a status symbol via:

If the [Date Verified]@row is blank AND if the [Assessment Status]@row = "Completed Assessment" then [column where formula exists]@row, "Red" / otherwise marked green (when the assessment status = completed assessment & date exists). I've tried a variety of combinations and the closest I get is when a cell should be red, it is blank while all others accurately display a green status. Any advice is greatly appreciated! Thank you!

• ✭✭✭✭✭✭
Options

@laurensevere You would use a standard IF/AND like so:

=IF(AND([Date Verified]@row = "", [Assessment Status]@row = "Completed Assessment"), "Red", "Green")

If you need it to be the opposite where it is green when the status is completed and the date is not blank and red for all others, you would still use an IF/AND combo.

=IF(AND([Date Verified]@row <> "", [Assessment Status]@row = "Completed Assessment"), "Green", "Red")

• Options

Thank you @Paul Newcome !

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!