I would like my cell to look at a cell@row to see if it = 1, or if another cell = minus 150. If either one of those is true, "1", if not " "
=IF([Minus 180]@row = "1", OR([Incremental Start]@row = "Minus 150", "1", " "))
=IF(OR([Minus 180]@row = "1", [Incremental Start]@row = "Minus 150"), 1, " ")
With Smartsheet, your combine the IF(OR(AND before you make their arguments and then you separate those statements with commas
Lisa Kennedy
Senior Consultant | Smartsheet Development
Prime Consulting Group
Email: info@primeconsulting.com
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.
