cross sheet data - input

Jason P
Jason P ✭✭✭✭✭

Am reading so many topics I'm now lost so reaching out.

Our 'Sales Order Activate' sheet is fed by a form, if the [Permit] checkbox is ticked I want our new Permit sheet to recognise that tick and populate a cell in the Permit sheet with the sales order number

=IF(INDEX({Sales Order Activation Range 7}, 1) = true, INDEX({Sales Order Activation Range 4}, 1), " ")

In this formula I believe 1 is the row, I would like to use @row but on doing that formula was unpassable?


Thanks in advance

Cheers.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!