Formula to reference one column based on entries from another column.

Linda F
Linda F ✭✭✭✭✭
edited 05/22/20 in Formulas and Functions

I need help on a formula for Project Assignment when a dollar amount is what determines who gets a Project assignment.

For example,

A Facilities coordinator will get a project if it falls between $5k - $24,999

Project Manager A will get a project if it falls between $25k and $99,999

Project Manager B will get a project if it falls between $100k and over

My attempt at creating the formula is below

=IF([Estimated Budget]@row = "Estimated Budget is between 5000 and 24999", "blue", IF(Estimated Budget@row = "Estimated Budget is between 25000 and 100000", "green", IF(Estimated Budget@row = "Estimated Budget is greater than 100000", "Pink")))


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!