Referencing a specific cell from another sheet

Question

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!

Paul Newcome · Accepted Answer

You would use an INDEX/MATCH like so:

=INDEX({Date Column}, MATCH("Red", {Color Column}, 0))