Multiply Different Cells by Different Cells depending on Drop Down Selection


Sorry i dont know how best to phrase this so i will give an example best i can. In attached picture the Columns "Phase of Work" and " Rate" are drop downs. Ive changed the names of actual columns to be non industry specific.

Based on the selection of phase in the drop down at Column A i want it to multiply the rate times the number of units in the corresponding Column C-F and total in the "Amount Paid" Column.

So if the drop down "Phase of Work" has selected Phase 1 I need "Rate" * "Phase 1 Units". If the "Phase of Work" has selected Phase 2 i need "Rate" * "Phase 2 Units" and so forth.

See Below

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!