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

Find more posts tagged with

Sheets

Calendar View

Workflows in Smartsheet

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.