Calculating if one date is 14 days greater than another date


I need to calculate a flag if the construction end date (in a cell) is greater than 14 days from the construction start date (in a cell). If the result is greater than 14 days the row will be flagged. I don't even know how to start. Any help would be appreciated.

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hi @Sharon Castiglia ,

    Create your flag column. In it place a column formula:

    =IF([construction end date]@row-[construction start date]@row>14, 1, 0)

    Modify the column names to match your sheet.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!