IF, OR, Populate Statement

Hello everyone, not sure if this one is possible, but I'll give it a go. I want to create one formula that basically functions as below:

IF([3MO Left Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Left Date]@row),IF([3MO Right Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Right Date]@row)

Any help would be greatly appreciated!

Find more posts tagged with

Accepted answers

All comments

Mike Wilday

Would there only be one or the other option? You would never have both dates selected right? A left and a right?

=IF([3MO Left Target Amputation]@row="Yes", [3MO Maj Amputation Left Date]@row, IF([3MO Right Target Amputation]@row="Yes", [3MO Maj Amputation Right Date]@row))

You pretty much wrote it out correctly, except you closed the first if statement with an ending parenthesis but it should have been nested. And just referencing the column you want to populate the date from, will populate that column's information.

Did it work?

Kayla Whaley

Correct, there would never be BOTH dates, just one or the other. I tried entering the formula as I have above and I receive the UNPARSEABLE error. Am I missing something between the left and right parts?

Mike Wilday

Check the column header names. Are they exactly right? can you share a screenshot of the headers with any sensitive data blurred out?

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.