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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!