Is there a workday.intl equivalent in SmartSheet?

Options
Dave_S
Dave_S ✭
in Formulas and Functions

I am looking to pull in a google sheet used to manage project schedule that uses a 6 day work week to calculate schedules.

For example one cells formula is:

=IFERROR(if(E69="Mail Date", F69,if(G69="First", workday.intl(AN69,-4,11,Holidays_USPS), if(G69="Standard",workday.intl(AN69,-6,11,Holidays_USPS),"NA"))),"NA")

Is there a way to do similar calculation in SmartSheet?

I haven't found a way to define weekends like in the workday.intl.

Let me know.

Dave

· Share on FacebookShare on Twitter

Answers

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭
    Options

    @Dave_S Have you activated the Gantt view in the sheet and set the working days in project settings?

    image.png

    dm

    · Share on FacebookShare on Twitter
  • Dave_S
    Dave_S ✭
    Options

    Thanks - no I have not. But unfortunately the working days is not consistent across all activities at the project level. The working days/holidays vary for the project task by owner group.

    The holidays I am able to vary by using references to a different range to define different.

    Dave

    · Share on FacebookShare 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!