Formula for calculating today minus the case created date

Options

Hi,

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?

=TODAY()-C2

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 ✓
    Options

    Hi @Czarmaine Quemuel,

    Try this:

    =NETWORKDAYS(C2, TODAY())

    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!

    BRgds,

    -Ray

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

    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:

    =ABS(NETWORKDAYS(C2, TODAY()))

    =NETWORKDAYS(TODAY(), C2)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!