how do I change the default output to blank if neither criteria is true

Options


=IF([Date of Last Invoice]@row < DATE(YEAR(TODAY()) - 2, MONTH(TODAY()), DAY(TODAY())), "Inactive", "Active")

I need to add that if the column is blank to leave it blank instead of defaulting to "Inactive"

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!