If/Then date question


Hi All,

I'm trying to use the formula below to populate a cell with "late" if the Date Opened +30 days is greater than the Original Due Date. Is this possible? I'm very new to the formula side of SS so any help would be appreciated! Thanks!

=IF([Date Opened]1 + 30, >[Original Due Date]@row, "late", "")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!