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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!