Is there a way to format a date field in a form (for a sheet) to be set up for the date it's submitted? Like a TODAY formula or something? Thanks!!
You use the inbuilt system one:
This will auto-populate itself with the date (and time) of submission of the row (whether by form or sheet), nothing extra required.
Do you need the date for any logic on the form? If not, you can just add a "Created Date" column to the sheet without needing it to be visible on the form or requiring any entry.
Thanks for the speedy reply! When I create that column on the sheet...how does it populate with the date it was submitted? Is there something I put on the form or is it a formula? @Nick Korna
Oh my goodness I forgot about that field, thank you so much! :) @Nick Korna
No problem at all! 🙂
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.