Text in one column show date in another.

01/31/19 Edited 12/09/19

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

Popular Tags:

Comments

  • Paul NewcomePaul 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å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

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.