How can I edit this formula to have a blank End Date field also input Active into the column?

=IF([End Date]@row < TODAY(), "Inactive", "Active")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!