I've been supporting a project that's utilizing Smartsheet's offline form submission. We want to capture the date of each form submission. However, since this is a large and fast-paced project, and we're doing A LOT of data collection, I tried to minimize the friction a person experiences while collecting data. So I setup the 'Created Date' column assuming that would capture the timestamp the moment a person presses 'Submit.' I'm finding that this is not the case.
Is Smartsheet not programmed to do this? Is the 'Created Date' column filled with the timestamp of when the submission is sent over WiFi (once it's connected)? I have added a date column the Data Collector manually fills, but I'd very much like a feature hard-coded into Smartsheet that captures the date of the form submission automatically, even if offline, the moment the 'Submit' button is pressed.
Here is a screenshot of 2 rows: the first row is correct, because I'm assuming it was connected to WiFi and submitted the same day. The second row I know for a fact was collected on 8/26, yet the 'Created Date' column shows 8/27. Again, this is presumably the timestamp for when the form was submitted over WiFi.
The only way to reliably do this is to have the user enter the date directly into the form.
The Created Date column does not capture the submission of the form but rather the creation of the row.
Even if connected when you submit the form... If you click on Submit at 11:59:59pm, if there is any kind of lag whatsoever in between the clicking of the Submit button and when the row is created, you could potentially have a date of the next day and 12:00:00am.
The only way to reliably do this is to have the user enter the date directly into the form.
The Created Date column does not capture the submission of the form but rather the creation of the row.
Even if connected when you submit the form... If you click on Submit at 11:59:59pm, if there is any kind of lag whatsoever in between the clicking of the Submit button and when the row is created, you could potentially have a date of the next day and 12:00:00am.
I initiated a support request on this, and the Smartsheet support team clarified that it functions according to its intended design, where it checks the box when a new record is created using the 'New' button within the dynamic view.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":110369,"type":"question","name":"data shuttle filter lacks an option to filter rows dynamically on date fields","excerpt":"I need to apply a dynamic filter criterion to a date field, specifically filtering for rows where the transaction date is current day, within a data shuttle workflow. Unfortunately, I can only find static date choices, which is inconsistent from what's possible in Smartsheet reports (where I can use the \"is today\" filter).…","snippet":"I need to apply a dynamic filter criterion to a date field, specifically filtering for rows where the transaction date is current day, within a data shuttle workflow.…","categoryID":343,"dateInserted":"2023-09-16T17:39:28+00:00","dateUpdated":"2023-09-18T14:55:38+00:00","dateLastComment":"2023-09-20T16:19:49+00:00","insertUserID":166645,"insertUser":{"userID":166645,"name":"Naren","url":"https:\/\/community.smartsheet.com\/profile\/Naren","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-21T22:49:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":166028,"lastUserID":166645,"lastUser":{"userID":166645,"name":"Naren","url":"https:\/\/community.smartsheet.com\/profile\/Naren","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-21T22:49:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":34,"score":null,"hot":3390115157,"url":"https:\/\/community.smartsheet.com\/discussion\/110369\/data-shuttle-filter-lacks-an-option-to-filter-rows-dynamically-on-date-fields","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110369\/data-shuttle-filter-lacks-an-option-to-filter-rows-dynamically-on-date-fields","format":"Rich","tagIDs":[474],"lastPost":{"discussionID":110369,"commentID":396228,"name":"Re: data shuttle filter lacks an option to filter rows dynamically on date fields","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/396228#Comment_396228","dateInserted":"2023-09-20T16:19:49+00:00","insertUserID":166645,"insertUser":{"userID":166645,"name":"Naren","url":"https:\/\/community.smartsheet.com\/profile\/Naren","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-21T22:49:21+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-20T16:19:59+00:00","dateAnswered":"2023-09-20T05:46:50+00:00","acceptedAnswers":[{"commentID":396127,"body":"
Paul Newcome ✭✭✭✭✭✭
