Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Default date to today with webforms
Hi
Anyone know if you can default a date field to today's date to avoid having to fill it in everytime?
Regards
Andy
Comments
-
Jaye Casciano ✭✭✭✭✭✭Hi Andy, to clarify - do you mean "today" as in the day the form is being filled out/submitted, or the specific date you are viewing the sheet?
-
Travis EmployeeHi Andy, while you can set a default date, it wont dynamically update each day. Are you looking for a timestamp of when the web form was submitted? Try using the Created (Date) System column which will automatically show a timestamp from when a row is created.
-
Hi Everyone, yes its a date stamp for when the form is submitted. Thanks Travis I will give your suggestion a go.
-
Looked all over for this and it seems this is not a current feature for web forms. Really would help to have this.
-
Hi Roger
Having used the create date i.e not having a date field on the web form it handles what I need. It only falls down when you need to create an entry that was in the past.
Andy
-
J. Craig Williams ✭✭✭✭✭✭Andy,
I think you could modify the methodology I described here:
https://community.smartsheet.com/discussion/formula-selecting-checkbox-will-populate-completion-date
for getting today's date with a checkbox.
You'd want to add your date field with a label like "only enter the date if not today"
Hope this helps.
Craig
-
Thanks Craig, in my scenario this could work.
I'm logging time spent on a support call using the web form. Initially I was trying to get the date field to auto populate with the current date but this didn't work. I then opted to use the create date in the Smartsheet and not have to bother with one in the web form. This is fine but I can't edit a row and change the create date if needed (which by the way I haven't needed to do). Your suggestion could work but I'm wondering if I really need to bother changing what I have :-).
Thanks anyway.
Andy
-
J. Craig Williams ✭✭✭✭✭✭
Andy,
不确定没坏的东西
Craig
-
It would be great if smart sheet have feature to set the "Today()" as default value for date column
-
J. Craig Williams ✭✭✭✭✭✭
See my post today:
http://ronin-global.com/2018/07/20/defaulting-to-a-date-in-a-smartsheet-webform/
Craig
-
I can't think of any situation where you would want the default date on a form to be the date that you created or last edited the form.
- I need the default date to be the day the form is being filled out
- I need the date field on the form to be hidden
- I need to be able to edit the date on the sheet
This seems to dictate that we either use Mr. Williams' work around or Smartsheet changes the function of the Today button when setting a default date.
Categories
You have a multi select dropdown where you specify which area where improved within each improvement idea.<\/p>
If that is correct, your first formula should work, although it would be better practice to use the HAS function for this setup, see below: <\/p>
=COUNTIF({Areas Improved}, HAS(@cell,\"Customer Experience\"))<\/p>
<\/p>
Check your cross sheet reference {Areas Improved} <\/strong>to make sure it is setup correctly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107790,"type":"question","name":"Adding an AND into a formula","excerpt":"Good morning, Community! Current formula (which is working): =IF(CONTAINS(\"APP\", [Employment Type]@row), JOIN([Dropdown Selection]@row:[Employee Status]@row, \"; \")) However, I need to include if the Employee Status equals Active within the above and not sure on the syntax?","snippet":"Good morning, Community! Current formula (which is working): =IF(CONTAINS(\"APP\", [Employment Type]@row), JOIN([Dropdown Selection]@row:[Employee Status]@row, \"; \")) However, I…","categoryID":322,"dateInserted":"2023-07-19T13:21:49+00:00","dateUpdated":null,"dateLastComment":"2023-07-19T14:13:56+00:00","insertUserID":163131,"insertUser":{"userID":163131,"name":"cghallo_UCDenver","title":"Smartsheet Consultant","url":"https:\/\/community.smartsheet.com\/profile\/cghallo_UCDenver","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-19T14:16:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-19T14:22:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":25,"score":null,"hot":3379551345,"url":"https:\/\/community.smartsheet.com\/discussion\/107790\/adding-an-and-into-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107790\/adding-an-and-into-a-formula","format":"Rich","lastPost":{"discussionID":107790,"commentID":385923,"name":"Re: Adding an AND into a formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385923#Comment_385923","dateInserted":"2023-07-19T14:13:56+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-19T14:22:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/R71AMNDX813P\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-19T13:49:51+00:00","dateAnswered":"2023-07-19T13:46:29+00:00","acceptedAnswers":[{"commentID":385910,"body":"
