TimeStamp Formula Value

mona.duncan75836

Hi,

I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry.

So for example, if I place an entry on the form, I need for my master sheet to match up my name and the time/stamp data and put it on my master sheet.

Any suggestions, would be greatly appreciated.

Thanks in advance.

Mona

Mike Wilday

You can now set a timestamp date based on another cell change using an automation workflow!

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action?_ga=2.79950226.443393604.1609776795-1074882870.1602114816

Mike Wilday

Hi there, the form entries will automatically add a date/timestamp if, in you add a system column type to your sheet. And then on your form options (the final option while editing the form, includes a require smartsheet registration to only allow registered smartsheet users. This will require them to login into smartsheet but will also capture their user information. 

This thread talks a little about capturing smartsheet user information https://community.smartsheet.com/discussion/capture-email-address-form-submission

See screenshot for how to set up a system column for creation date. 

 

mona.duncan75836

Hi,

Thank you for this, but I want to link the information onto another sheet.

Having problems with coming up with a formula that will allow the information to be pasted onto the master sheet. 

I will check out the other thread and see if I can get some ideas there.

Thanks again.

Mona

Paul Newcome

Are you planning on using certain criteria to pull the info (most recent submission kind of thing) or are you just trying to populate another sheet with all entries?

mona.duncan75836

Trying to populate the entries.

Andrée Starå

Hi Mona,

How did it go? Did you get something set up?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

You can now set a timestamp date based on another cell change using an automation workflow!

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action?_ga=2.79950226.443393604.1609776795-1074882870.1602114816

Todd Smelser

Hi @Mike Wilday ,

I am looking to do something similar but the Record a Date action does not add a timestamp. Only the date.

Andrée Starå

Hi @Todd Smelser

I hope you're well and safe!

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!