I need help to calculate the overall Priority by using IF condition.
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!
Answers
-
What would be the outcome for each of the variations? What logic are you wanting to use?
-
Hi Paul,
Thanks for your reply.
It would be great if we can use IF condition and outcome would be numbers(High -3, Medium-2, Low-1) as given in question.
-
I understand that, but we need the actual logic. Not just the outcome. Why exactly is Test Project "Low" but the next one is "High" and the one after is "Medium"? How exactly are you determining the outcome?
-
Please check the formula. I'm getting error
=IF(COUNTIF([Impact]@row:[Impact_15]@row, "High") > COUNTIF([Impact]@row:[Impact_15]@row, "Medium","Low"), 3, IF(COUNTIF([Impact]@row:[Impact_15]@row, "Medium") > COUNTIF([Impact]@row:[Impact_15]@row, "Low","High"), 2, IF(COUNTIF([Impact]@row:[Impact_15]@row, "Low") > COUNTIF([Impact]@row:[Impact_15]@row, "High","Medium"), 1)))
I feel it's incomplete, not sure what's missing.
Thanks
-
What is the intended logic?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!