Text in one column show date in another.

Florence Nickerson
Florence Nickerson ✭✭✭
edited 12/09/19 in Smartsheet Basics

I am moving a complex (static) spreadsheet to Smartsheet!  One of the key drivers ensures that we show the date and the fact that it is NPI.

In the Excel spreadsheet we have numerous columns (about 11 years but moving forward it will not be that big) showing Month/Year

  • When you enter NPI in one of the columns, then the date will show in the DATE column.  Example:
  • If you entered NPI in the Feb -19 column on line 3 then you would see 2/1/2019 in the DATE Column on line 3.

 In Excel this is the formula I use.

=IF(ISERROR(MATCH($N$3,$R588:$FE588,0))=TRUE,$E588,(HLOOKUP(MATCH($N$3,$R588:$FE588,0),$R$1:$FE$4,$N$5,FALSE)))

I am trying to figure out the formula in Smartsheet with ZERO success.

Any help would be appreciated.

Florence Nickerson

Tags:

Comments