I need help to calculate the overall Priority by using IF condition.

Options
Shaikk
Shaikk ✭✭
edited 09/07/22 in Formulas and Functions

Hi,

I need to fill the Overall Priority column.

I use IF statements to get the result, but not sure what's missing. Please help me with Formula.

I have got the Priority columns data by forms, need to summerize of all priority columns in one column(Yellow Highlighted).

for intance,

Test Project should show "Low"(1)

Test Project1 should show "High"(3)

Test Project2 should show "Medium"(2)

Thanks in advace!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!