output data from another reference sheet

Options

I need help in generating a formula for this scenario, please.

Our purchase requisitions have to be approved by multiple persons and since we have over 662 department codes it will be awesome if Smartsheet can match the approvers with the department codes and the approval sequence.

I need help in generating a formula for this scenario, please.

when the Department code in the Requisition Sheet changes to Dept Code xxxx , then find and reference sheet Approval Tracks to output the approver name for approver sequence 1 to the Approver 1 column.

Requisition Sheet:

Approval tracks sheet


Best Answer

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!