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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!