Copy Information if condition is met
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!
Best Answers
-
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 ))))
-
No. That isn't possible. You will need to put the formula into another column that isn't being reference by the formula itself.
Answers
-
Try quotes instead of apostrophes.
-
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 ))))
-
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).
-
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 ))))
-
No. That isn't possible. You will need to put the formula into another column that isn't being reference by the formula itself.
-
Thanks. That worked.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!