IFS formula and adding number of days

EvaL

How to convert this Excel formula into Smartsheet

=IFS(ISBLANK(C3),"",E3="Product1",C3+30,E3="Product2",C3+15, E3="Product3",C3+30,E3="Product4",C3+30)

I would appreciate your help.

Thank you:)

Find more posts tagged with

Conditional Formatting

Accepted answers

All comments

Paul Newcome

Try something more like this:

=IF(C3 = "", "", IF(OR(E3 = "Product1", E3 = "Product3", E3 = "Product4"), C3 + 30, IF(C3 = "Product2", C3 + 15))

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.