Writing a formula with two different IF conditions based on 2 possible actions


I don't know if IF formulas or INDEX/MATCH are appropriate here - I've tried both and am not able to get a functioning formula.

I would like the formula in the column "Winning Agency" to look at the BookingOutcome column, which has two options: "Booked with first agency." or "Booked with second agency." and then return the applicable agency.

Using the example below, since the booking outcome is "Booked with first agency," I would like ABC Agency to show in the Winning Agency column. Conversely, if the booking outcome had been "Booked with second agency" then I'd want XYZ Agency to be returned in the Winning Agency column.

What's the best way to accomplish this?

Thanks in advance!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!