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

Linda F

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")))

Werner Gerstacker

Try this:

=IF([Estimated Budget]@row >100000, "Pink", IF([Estimated Budget]@row >24999, "Green", IF([Estimated Budget]@row > 4999, "Blue", "Nobody, really?")))

Linda F

It worked, thank you so much !

Werner Gerstacker

Try this:

=IF([Estimated Budget]@row >100000, "Pink", IF([Estimated Budget]@row >24999, "Green", IF([Estimated Budget]@row > 4999, "Blue", "Nobody, really?")))

Linda F

It worked, thank you so much !

Werner Gerstacker

Glad I could help!