Business Days

Options

Carla_Ahzul

Carla_Ahzul ✭

02/27/18 edited 12/09/19 in Formulas and Functions

Someone knows how to include weekends in a single row on one sheet and that all other rows include only work days?

Thanks!

Tags:

0 ·

Comments

Mike Wilday ✭✭✭✭✭✭

02/27/18
Options
What kind of sheet / template are you working with? Are you trying to use dependencies?

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

Reference sheet CountIf Contains
Hello, I am trying to build a reference sheet that gives a summary of quarterly results. I need to count the row if the value contains either Exception or Samples. I tried many different versions only getting many different error messages. This is my last attempt getting a Invalid Operation. =COUNTIF({2023 Q4 Monitoring},…
Calculating Formula help
My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students
IF OR Statement
Hi There! Looking for help to on an IF OR statement. Want to take two columns that will be either Yes or No, and populate another column with a date from two columns if it is Yes. Process, either the Facilitator or the Architect will be requesting a Complete By Date. Whichever requests, the other has to say yes or no. For…