Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula that only counts business days

Ian Staley

Ian Staley ✭✭

07/21/16 edited 12/09/19 in Archived 2016 Posts

Hello,

I'm trying to write a formula for a date that will say something like "due in 18 business days".

So basically " =[column name] + 18" but exclude weedend days. Is that possible?

Thanks so much!

Tags:

Formulas

0 ·

Comments

Brett Evans ✭✭✭✭✭✭

07/21/16 edited 07/21/16

This.
="Due in " + NETWORKDAYS(TODAY(), [ColumnWithDate]1) + " business days."

0 · Share on Facebook Share on Twitter
Ian Staley ✭✭

07/22/16 edited 07/22/16

Thank you very much!!!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Automation error.
I have some trouble with an Automation. It has been running great for a few weeks. A couple of days ago, I received a notice When I change the ‘Modified Date’ column in the destination sheet, Smartsheet adds a new column in the destination sheet called ‘Modified Date’ and my dates column doesn’t fill in. Here are some…
New Sheets no longer living under "Sheets" Area
In the past, I could create new sheets or move copies of sheets from other workspaces into my Sheets area (the area above where the Workspaces are located). Now when I create sheets, they go to an "Untitled Workspace" and I cannot move it into my own personal Sheets area. Is the Sheets area being phased out?
Dashboard - Chart Help, multiple responses in one column
hello, I am trying to create a graph with the data below, however I cant figure out how to capture the work type count when there is multiple options in that column. The formula i am using is in the screenshots attached (count by processor) - hopefully that gives you enough to help me out!