Forms duration stamp
Is there a way to add a START and END timestamp to the Form/Sheet that will enable me to determine the duration it has taken for each respondent to complete the form?
Best Answers
-
Unfortunately, as far as I know, it's not possible at the moment to get the time the form was opened, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could maybe continue to use the Microsoft Forms, Google Forms or similar.
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This is a new task which I would like to timestamp so will do without it for now but it would be a very useful "nice to have". Many thanks Andree
Answers
-
Hi @Marijan
Do you want to measure the time from when you share the form until submitted or something else?
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello again Andree!
I want to measure the duration it takes respondents to complete the Form process as I want to know which respondants just process the answers and not read the text above. Therefore a START date/time column and an END data/time column, then I could calculate the time in DURATION=END-START. Here is an example I use in Excel which is extracted from a Microsoft Form:
-
Unfortunately, as far as I know, it's not possible at the moment to get the time the form was opened, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could maybe continue to use the Microsoft Forms, Google Forms or similar.
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This is a new task which I would like to timestamp so will do without it for now but it would be a very useful "nice to have". Many thanks Andree
-
Yes, i agree. It would be useful.
I'll get back to you if I think of some way to solve it.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives