Referencing a specific cell from another sheet

Adam1234

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

You would use an INDEX/MATCH like so:

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

Paul Newcome

You would use an INDEX/MATCH like so:

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