Formula for calculating today minus the case created date



I'm a new user here. What is the equivalent formula from google spreadsheet to smart sheet if for example, C2 is the cell with Case Created Date?


I'm trying to show the actual case age without including the weekends and holidays.

Thank you in advance for the one who will answer.

Best Answers

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 12/12/22 Answer ✓

    Hi @Czarmaine Quemuel,

    Try this:


    This will exclude weekends as well as any holidays you have defined in your Project Settings. Remember you can access your Project Settings by right-clicking a column header, and selecting "Edit Project Settings". Dependencies must be enabled there first, and then you can select which days of the week are in-scope as well as exclude holidays (dates) by listing them, comma-separated, in the space provided.

    Hope this helps!



  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    Answer ✓

    Hi @Czarmaine Quemuel,

    Is your C2 date in the future?? If so, that's what is causing it.

    If not, here are a couple things to try:




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!