Referencing a specific cell from another sheet
Hello Smartsheet Community,
I am trying to come up with an Index formula that would produce the value from another sheet, with a specific condition. To help better explain:
I want to grab a date from another Smartsheet column. However, since there are many dates included in this date column, I'd like this formula to pick out a specific date from the date column that meets the criteria from another column in the same sheet. For example, I want a date picked if the criteria column on the sheet is labeled Red.
Please let me know if this makes sense or if there needs to be more context.
Thank you!
Best Answer
-
You would use an INDEX/MATCH like so:
=INDEX({Date Column}, MATCH("Red", {Color Column}, 0))
Answers
-
You would use an INDEX/MATCH like so:
=INDEX({Date Column}, MATCH("Red", {Color Column}, 0))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!