How do I change this formula to calculate only network days?

Deanna Copello

Deanna Copello ✭✭✭

12/02/22 edited 12/02/22 in Formulas and Functions

My formula: =[Order Submitted]@row + 4

I need the +4 to only be network days.

thanks!

0 ·

Answers

Paul Newcome Community Champion

12/02/22

You would need the WORKDAY function.
=WORKDAY([Order Submitted]@row, 4)

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

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Data Mesh
I have created a Data Mesh function from a report to a sheet. If I run the configuration with Copy and Add Data, everything moves over perfectly. However, if I run the configuration with Create Cell Links, the information does not transfer. To add, if I run the first configuration and then run the cell link function, it…
managing a dropdown field from a single source used by multiple sheets
we are tracking courses taken by folks throughout our org. each student (apx. 58) has their own sheet (student record), tracking the courses they have taken and the date completed. this is how the owner of the process currently wants this managed. the course catalog is relatively static and we would like it maintained in a…
Check Box for Current Milestone
I am looking for help in writing a formula (or using automations) so that the most recent milestone where the status is "INV PKT SENT & PSR XL UPDT" will have the checkbox. As you can see, I can write a formula to check the box but then when the next milestone reaches that same status I now have multiple checkboxes in the…