Copy Information if condition is met

ewitt19205

Formula:

=IF([Issue Type]@row= 'Coordinator Request',[Coordinator Request Types]@row, IF([Issue Type]@row= 'Standard Request', [Ops Requests]@row, IF([Issue Type]@row= 'Enhancement Request', [Ops Requests]@row, IF([Issue Type]@row= ‘Change Request', [Ops Requests]@row, Summary@row ))))

Goal: If specifc issue type copy certain field. If not one if these issue types, copy the summary field

I have the jist of the formula, but thinking I am missing a few syntax items. Would someone please help? Thanks!

Find more posts tagged with

Accepted answers

ewitt19205

That helped. Looks like I have a circular reference

Field formula is in= 'Summary', So, if none of these conditions are met, copy itself. Not sure if this is possible.

=IF([Issue Type]@row= "Coordinator Request",[Coordinator Request Types]@row, IF([Issue Type]@row= "Standard Request", [Ops Requests]@row, IF([Issue Type]@row= "Enhancement Request", [Ops Requests]@row, IF([Issue Type]@row= "Change Request", [Ops Requests]@row, Summary@row ))))

Paul Newcome

No. That isn't possible. You will need to put the formula into another column that isn't being reference by the formula itself.

All comments

Paul Newcome

Try quotes instead of apostrophes.

ewitt19205

Thanks for helping me troubleshoot. I tried quotes and the formula still not coming through.

=IF([Issue Type]@row= “Coordinator Request”,[Coordinator Request Types]@row, IF([Issue Type]@row= “Standard Request”, [Ops Requests]@row, IF([Issue Type]@row= “Enhancement Request”, [Ops Requests]@row, IF([Issue Type]@row= “Change Request”, [Ops Requests]@row, Summary@row ))))

Paul Newcome

That is because of the type of "quotes" you are using. See how mine are straight up and down, but yours are slanted?

Those slanted ones are called "smart quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula. You will need to retype them here in the Community, in Smartsheet, or in a text editor such as Notepad (not Word).

ewitt19205

That helped. Looks like I have a circular reference

Field formula is in= 'Summary', So, if none of these conditions are met, copy itself. Not sure if this is possible.

Paul Newcome

No. That isn't possible. You will need to put the formula into another column that isn't being reference by the formula itself.

ewitt19205

Thanks. That worked.

Paul Newcome

Happy to help. 👍️

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.