How to add multiple IF statements to WORKDAY function?
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
Answers
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!