Text in one column show date in another.

Florence Nickerson

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

Paul Newcome

Are you trying to timestamp when an action happens? In Smartsheet, the only two timestamp options you have are when the row is created and when a row is updated. Time/date stamps for specific actions have to be manually entered.

Andrée Starå

Hi Florence,

Something could probably be set up with the help of a third-party tool like Zapier or similar.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting