Help in setting customer importance based on their average sales price

Options

Can anyone help me develop a formula please?

I would like to set a level of importance for customers. I would like to see if their sales price is more than the total average or less.

If its more, I would like to set an importance text field to "RED".

Is it something like : =IF(AVG([Sales Price]:[Sales Price]),>[Sales Price], "RED",)) ??

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!