TimeStamp Formula Value
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
0
Best Answer
-
Mike Wilday ✭✭✭✭✭
You can now set a timestamp date based on another cell change using an automation workflow!
0
Answers
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.
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
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?
thinkspi.com
Trying to populate the entries.
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
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.
You can now set a timestamp date based on another cell change using an automation workflow!
Hi @Mike Wilday ,
I am looking to do something similar but the Record a Date action does not add a timestamp. Only the date.
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:
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!
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.