QQ for else if formula is smartsheet

I am trying to get smartsheet to interpret my string value in # of days so I can use it in a formula. Any idea why I am getting an error with the following:

=if([Complexity for contract changes]@row(Small - 6 months),"180",or([Complexity for contract changes]@row(Medium - 12 months),"360",or([Complexity for contract changes]@row(Large - 18 months),"540")

Find more posts tagged with

Accepted answers

All comments

KPH

The syntax is not correct. The parts after each @row will be a problem and the OR needs to go at the start of the function after the IF if you really want to do an OR.

Take a look at this for how to use OR

https://help.smartsheet.com/function/or

I think you might actually just want to use nested IFs without OR. In which case, this should help

https://help.smartsheet.com/function/if

if you need help, please share a screenshot of the sheet and explain what you want the formula to do, specifically what are these parts for after each @row?

(Small - 6 months)

(Medium - 12 months)

(Large - 18 months)

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.