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

Jessewise

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!

Paul Newcome

Try this:

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

Paul Newcome

Try this:

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

Jessewise

Thank you so much, Paul!!

Paul Newcome

Happy to help. 👍️

laurensevere

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!

Paul Newcome

@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")

laurensevere

Thank you @Paul Newcome !