workday calculation with if conditions

Hi,

I'm trying to add a workday function to my current calculation. I already use if condition in the cell. Here's what I have.

If location is Riverside, then add 3 days to ETA. If location is Memphis, then add 5 days to ETA.

IFERROR(IF(Location1 = "RIVERSIDE", ETA1 + 3, IF(Location1 = "MEMPHIS", ETA1 + 5)), 0)

However, I need the dates that come out to be weekday/working day and exclude weekends. Appreciate all the help.

Thanks!

Find more posts tagged with

Formulas

Hi Teddy -

You could insert a WORKDAY function into the formula -

=IFERROR(IF(LOCATION2 = "RIVERSIDE", WORKDAY(ETA2, 3), IF(LOCATION2 = "MEMPHIS", WORKDAY(ETA2, 5))), 0)

This will move the new date to the following Monday (or day after holiday if that is defined) if it falls on a weekend. See https://help.smartsheet.com/function/workday

I hope this helps?

Sean

Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…