In this updated version of SS I don't see the option for "Today" on the calendar. Has this feature been moved or disabled?
You cannot add formulas to forms.
The workaround is to simply add the Created (Date) Auto column and use this as it will populate the date/time of when the form was submitted.
You can rename this as you please. If you don't want the time, create a new column with formula =DATEONLY(Created@row)
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
DAN, this makes no sense as this was an option before. Features need to be added to smartsheet not taken away.
The suggestion of "Created (Date) Auto column" is great and seems to work BUT the suggestion to remove the time using =DATEONLY(Created@row) is not working for me...gives me "INVALID COLUMN VALUE" any suggestions here ?
Answering here as well.
Make sure that the column is a Date type column.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
@MONIQUE WALL Good catch! I hope Smartsheet team addresses the issue.
I agree that removing this functionality is frustrating. It worked exactly the way I needed. Having to add an additional column just to have this functionality clutters up the sheet. I want fewer columns that do what they need to do not multiple work around columns that have to be used together to achieve the desired end result.
Update: Never mind! :) I figure it out!
I created a new column, type = date, and entered that formula in the first empty cell (then copied it down 10+ rows.). I get "#UNPARSEABLE." When I submit a new form entry, nothing happens in the cell.
Do I just enter this formula in every cell in the column? Can you please explain where you enter the formula?
Here is a suggested workaround, especially if you want the 'Todays Date' cell to still be editable (i.e., backdating or catching up on admin):
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
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…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.