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

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hey @Delilah

    Did you try @Andrée Starå's formula?

    I did notice there was a potential typo with the "End Date" column reference, so just make sure you replace the column names with your column names:

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!