How to add multiple IF statements to WORKDAY function?

EddyMatt

Hello trying to add multiple cities to a workday function. This is to subtract our ship day from the expected arrive by date. Currently, this is what I have

=WORKDAY(F3,IF(OR(K3="CITY1",K3="CITY2),"-2","-10"),Sheet1!B$2:B$49)

I want to add 2 more cities. The function can either be from another column/sheet that has the cities to pull from or multiple IF statements.

Thanks

Genevieve P.

Hi @EddyMatt

Smartsheet formulas are structured differently than formulas in Excel. Would you be able to post a screen capture of your Smartsheet sheet current set-up?

We can likely use Smartsheet's WORKDAY function or NETWORKDAYS, looking at your dates, but it would be helpful to see the sheet you're working with. It will also make a difference if you're writing a cross-sheet formula or not.

Thanks!

Genevieve