-
Why Aren't Date Fields Allowing Non-Date Entries to a Form?
I'm having some issues with submitted non-date formatted information in a date field via a form. I have the column settings set up to allow for non-date entries, but the form now has an error message that pops up when I enter text like "TBD" into the field. I've been using this form for several months and this hasn't been…
-
Double Access Graph and using dates
it would be great if double access graphs would be available in Smartsheet like excel Also, can something be done with the dates, so you don't need to do a formula on your dates to be able to put them in order in graph. it's really annoying to have a 1 in front of your months to be able to get them to display…
-
Year in Timeline View shows as 2026 when clicking 'Go to Today'
Hi Everyone! Not sure if I'm missing something embarrassingly obvious, but for some reason my Timeline view shows FY 2026 when I click on 'Go to Today'? As far as I can tell, it's an issue specifically in relation to this particular sheet, as I've tested it on empty sheets and it reverts to 2025. However, I can't pinpoint…
-
How can I add a new task that's start date is in the past?
Hey community I need to add a task into a project plan that has it's start date in the past. Seems like the system does not allow that?
-
Manually Adjust dates with Predecessors
I am new to smartsheets (as is my team), and so far we have been found smartsheets as an acceptable software solution. However, I recently discovered that I am unable to manually adjust dates if there is a predecessor. this functionality is a requirement. an non-negotiable (for me) requirement. Here is an example: I have…
-
Calculating a percentage based on YTD wins
Hi everyone - I'm trying to add a percentage of wins to a dashboard. Initially I thought the easiest solution would be to add a formula to the sheet summary page and i used this but have been getting back #invalid Data Type error. =COUNTIFS([Status/Conclusion]:[Status/Conclusion], "Won", YEAR([Date Requested]:[Date…
-
Date Formula Not Working?
I am trying to auto-populate some dates in my "Due Date" column. When a date is entered in row 5, I need row 6 to be "date" - 5 days. The formula I tried was: =[Due Date]5 - 5 But when I click enter, it just adds a " ' " to the beginning and displays the formula. Am I missing something? *Note, this is when using a date…
-
Change date color beyond certain time period
Hello! This seems like it should be easy but I'm having trouble figuring it out. I would like to have the cells in a date column turn different colors after a number of days has passed. For example, if the date is over 30 days, I would like the conditional formatting to change to yellow. If it is over 60 days, I would like…
-
Leading Zero in DD-Mon-YYYY
Can there be an option to enable the front Zero for the date format 27-Apr-2018? Right now it will show only a single digit for days 1-9, and the Zero is needed to make the numbers unambiguous. (I didn't make this rule, just have to follow it.)
-
How to create a time stamped column with the date
How do I create a time stamp column to auto populate the date and time of when a cell changed from blank to a value? The workflow to fill in a date does not provide the time and I cannot figure out a formula that would capture both date and time?