Help with populating one column based on value of range of columns
I have a number of columns with either "High", "Medium" or "Low" as the value and am wanting to return either "Yes", "No" or "Maybe" in another column based a result in any of those columns.
So if any of columns A - E contains "High" then column F should show "Yes"
Thanks in advance for any help!
Best Answer
-
Hi @Kristen Beer
Hope you are fine, please try the following formula and convert it to column format formula:
=IFERROR(IF(COUNTIF(A@row:E@row, "High") > 0, "Yes", "No"), "")
the following screenshot shows the result:
bassam.khalil2009@gmail.com
βοΈ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Kristen Beer
Hope you are fine, please try the following formula and convert it to column format formula:
=IFERROR(IF(COUNTIF(A@row:E@row, "High") > 0, "Yes", "No"), "")
the following screenshot shows the result:
bassam.khalil2009@gmail.com
βοΈ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
That worked perfectly - thank you very much!
-
Excellent, I will be happy to help you any time. I will appreciate your vote on this post.
bassam.khalil2009@gmail.com
βοΈ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!