Form default to today's date
I want a form to default to today's date (date submitted). A previous post (2017) showed how to do this by selecting the 'Today' button on the bottom of the calendar in the field settings of the form. However my calendar does not have a today button.
Answers
-
You could add it automatically after the form is submitted.
Would that work?
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.
-
-
If you want to note the date of the submitted form, I'd rather suggest you to use an automated cell "date created".
Having an hidden field in the form that as this formula within it: =TODAY(), will change date each time you open the sheet, so I believe it won't help.
-
I saw that David answered already!
Let me know if I can help with anything else!
Best,
Andrée
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.
-
Like Phil, I also came across the 2017 help forum post showing "Today" as an optional default. That feature was removed. I understand that I can create a column formula in the sheet that the form populates, but I want the form submitter to be able to change the date if it is NOT today/same day as form submission.
Could that feature be re-instated?
-
I too need to default today's date into a date field on a form so I can see how many days it has been since a new ticket is added and has not been addressed.
If anyone has figured this out, it would be great to know. Not sure why Smartsheet removed this feature from the forms.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- I thought combining the four different sheets into one report would eliminate the need to share all four separately. However, I was just informed that they're unable to see the context of the report, …
- Hello, I created a smartsheet with a form, and when I saved this smartsheet as a new file so I could keep the template, I can't get the form to show on the left hand side of the screen for easy access…
- I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is…
