Enhancement Request: TODAY() as default value in forms

Matheus Vieira

Hi team,

I find that it would be very useful to the user just to implement a way to set up the date of "today" into data fields of Smartsheet Forms and new entries in Dynamic view.

In essence it would take today's date as default value.

Upvote if you find this useful so it could be implemented

Laura McDonald

It would be helpful to have the ability for a Date field to pre-populate in a form, but still allow the user to change the date if needed. In my specific use case, 90% of the time the date would be today's date, but if the user has to submit data for a previous date because it was missed, they still need the ability to change the date, so a column formula that always fills today's date doesn't work for this scenario.

srasbornik

Users who fill out the form shouldn't have to manually select today's date, and if this feature was implemented, then we could hide the field and automatically track the date the form was opened without the user having to fill that out. Last modified date changes too much to be reliable.

Andrée Starå

Hi@srasbornik

I hope you're well and safe!

You can add the System Column, Created Date, and use that instead.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

srasbornik

Hi @srasbornik<\/a> <\/p>

I hope you're well and safe!<\/p>

You can add the System Column, Created Date, and use that instead.<\/p>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"srasbornik\",\"userID\":161322}}},{\"insert\":\" \\nI hope you're well and safe!\\nYou can add the System Column, Created Date, and use that instead.\\nWould that work\\\/help? \\nI hope that helps!\\nBe safe, and have a fantastic week!\\nBest,\\n\"},{\"attributes\":{\"bold\":true,\"link\":\"mailto:andree@workbold.com\"},\"insert\":\"Andrée Starå\"},{\"insert\":\" | Workflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/workbold.com\\\/\"},\"insert\":\"WORK BOLD\"},{\"insert\":\"\\n✅\"},{\"attributes\":{\"italic\":true},\"insert\":\"Did my post(s) help or answer your question or solve your problem? Please support the Community by \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"marking it Insightful\\\/Vote Up, Awesome, or\\\/and as the accepted answer\"},{\"attributes\":{\"italic\":true},\"insert\":\". It will make it easier for others to find a solution or help to answer!\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2023-05-18T17:38:57+00:00","insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/376573#Comment_376573","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/376573#Comment_376573

Hi Andreé! Created date seemed to not always match the date of request, because it isn't editable - it would indicate that any row that had to be manually created was the created date, when ideally it should be the date a form request was submitted. For newer requests, it would work, but it creates confusion when it's not 100% accurate to what we're expecting it to be. If the Created Date field was editable, it would then be a sufficient solution.

Andrée Starå

@srasbornik

You could add a so-called helper column and reference the created date, so if needed, you could edit it or use a workflow combined with the Record a Date Action to record the date directly after it's been submitted.

Would that work/help?

srasbornik

@srasbornik<\/a> <\/p>

You could add a so-called helper column and reference the created date, so if needed, you could edit it or use a workflow combined with the Record a Date Action to record the date directly after it's been submitted.<\/p>

Would that work\/help?<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"srasbornik\",\"userID\":161322}}},{\"insert\":\" \\nYou could add a so-called helper column and reference the created date, so if needed, you could edit it or use a workflow combined with the Record a Date Action to record the date directly after it's been submitted.\\nWould that work\\\/help?\\n\\n\"}]","format":"rich","dateInserted":"2023-05-18T17:55:10+00:00","insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/376585#Comment_376585","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/376585#Comment_376585

这是一个工作的解决方案!我把它实现as an automation, such that whenever a created date is recorded, upon trigger it will update the record a date feature. This will allow for us to edit the request date if required. Thank you!

Andrée Starå

@srasbornik

Excellent!

You're more than welcome!

✅Remember!了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!