Return a date

Options
rweismiller
rweismiller ✭✭
edited 10/03/22 in Formulas and Functions

I am sure this is simple, but I am relatively new to SS.

I have 2 sheets,

Sheet 1 is called FMS

Columns are

PN Sup FFM MTA Priority Promise


Sheet 2 is called SS DATA

Columns are

PN DESC Need On SS ETA


In sheet 2, I want to return a date only from sheet 1 that is in the promise column, when PN matches. And if there is no match, I want it to be blank and not return #NO MATCH

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!