Assigning a value to another Column from a formula...
I hope you are all well and safe.
I have a sheet that has the following columns: 1st Level Approver, 2nd Level Approval Required, 2nd Level Approver, 1st Approval, 2nd Approval columns and Helper.
1st Approval and 2nd Approval are Single Select drop downs with the options "Approved" and "Declined"
I need these to be selectable in update requests by the 1st and 2nd Level Approvers.
I want to add a formula to the Helper column =IF([1st Level Approver]@row = [2nd Level Approver]@row, 1st Level Approval]@row = "Approved")
I keep getting a #INVALID COLUMN VALUE error in the formula. I have recreated it on another sheet with simpler columns types and get the same thing.
My question is: Can we assign a separate column a value from a formula within another column?
(I also thought it would be nice to be able to have multiple True and false outcomes. ie. IF this then 1 and 2 and 3 else A and B and C)
Thanks for any advice.
Mgr. Deployment Operation
Help Article Resources
Check out the Formula Handbook template!