Copy Information if condition is met

Options

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

  • ewitt19205
    ewitt19205 ✭✭
    edited 09/15/23 Answer ✓
    Options

    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
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!