I'd like to create a column that generates a number of working days between the finish date in a row

I'd like to create a column that generates a number of working days between the finish date in a row and today.

So, if today is Sept 15, and a task is supposed to finish on September 18, the cell in the column would display "3". What formula should I use?

Similarly, is there a variable in SmartSheet formulas to represent today's date? (like $today, etc.)

Find more posts tagged with

Accepted answers

Stefan

Hi @Chris McLaughlin,

actually you can write nearly the same formula from your example:

=Finish@row - TODAY()

delivers the number of days (including weekend etc.).

Does this help, or did I still misunderstand your question?

Greetings

Stefan

Hi @Chris McLaughlin,

glad I could help.

Regarding holidays, there is no magic needed. Just go to your project settings and edit the working days. There is a field where you can enter public holidays. These will be used if you also activate dependencies.

Hope this helps too

Stefan

All comments

Stefan

Hi @Chris McLaughlin,

you should use

https://help.smartsheet.com/function/networkdays

And yes, TODAY is also available:

https://help.smartsheet.com/function/today

Hope this helps

Stefan

Chris McLaughlin

Thanks for weighing in, but it doesn't quite get to what I'm asking.

I am aware of those two functions. What I'm looking for is a variable, so I could write a formula like =Finish-$TODAY and the answer would be "3". I'm hoping I don't need a column in my spreadsheet that contains today's date!

Thanks,

Chris

Stefan

Hi @Chris McLaughlin,

actually you can write nearly the same formula from your example:

=Finish@row - TODAY()

delivers the number of days (including weekend etc.).

Does this help, or did I still misunderstand your question?

Greetings

Stefan

Chris McLaughlin

Cool! I ended up using "=NETWORKDAYS(TODAY(), Finish1)" so it would only tell me working days.

It would be even better if it automatically (automagically?) did not include holidays on the sheet, but I'll take what I can get! :)

Thank you,

Chris

Stefan

Hi @Chris McLaughlin,

glad I could help.

Hope this helps too

Stefan

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.