How can I specify a range in one column and return a value in another column?
Best Answer
-
You need another IF statement in there, and I'm assuming if the value IS 10 you want it to be green as well...?
Try this:
=IF([Estimated Days to Completion]@row < 10, "Red", IF([Estimated Days to Completion]@row >= 10, "Green", ""))
What if the cell is blank? Do you need to address that as well? Using the above, it will give you a red dot. If you want it to be blank (no dot) then use this:
=IF(ISBLANK([Estimated Days to Completion]@row), "", IF([Estimated Days to Completion]@row < 10, "Red", IF([Estimated Days to Completion]@row >= 10, "Green", "")))
Answers
-
Hi Michael,
Use this in your other column:
=IF([Estimated Days to Completion]@row < 10, "Red", [Estimated Days to Completion]@row > 10, "Green")
but do make sure that this column is of "Symbol" type and select the correct option having Red, Yellow, Green.
Hope it helps!
Thanks,
Jayesh
-
You need another IF statement in there, and I'm assuming if the value IS 10 you want it to be green as well...?
Try this:
=IF([Estimated Days to Completion]@row < 10, "Red", IF([Estimated Days to Completion]@row >= 10, "Green", ""))
What if the cell is blank? Do you need to address that as well? Using the above, it will give you a red dot. If you want it to be blank (no dot) then use this:
=IF(ISBLANK([Estimated Days to Completion]@row), "", IF([Estimated Days to Completion]@row < 10, "Red", IF([Estimated Days to Completion]@row >= 10, "Green", "")))
-
Cool! Thanks. It worked. What if I wanted to throw an AND statement in there somewhere?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives