-
Automate Date Fields
I have reoccurring tasks that have start dates and end dates. What I would like to do is after the status changes to completed, then automatically change the date fields to the next occurrence. For example: I have a task that has a start date of 7/1/25 and an end date of 7/10/25, and that task reoccurs quarterly. Is there…
-
Having difficulty with live 'Week Commencing' calculations and lookups
I've posted a related question here before, and although I got a response, it didn't achieve what I was looking for - therefore, I've changed my approach. Essentially, what I’m trying to produce is a live view of all new starts, transfers and leavers to be viewed by various stakeholders once they are officially confirmed.…
-
How to make the actual date earlier than the target date
I have sheets built for a team of engineers and they have a list of milestones with target dates and actual dates. Occasionally they will complete milestones earlier than the target date. My sheet will not let me set the actual date earlier than the target date. It will allow the actual date to be the same as or later than…
-
Date incrementing column formula works fine except in two cases.
Hi there, I am using a formula to establish future dates (Scheduled Pull-Out Date) based on a starting date (Packaging Date) and adding a number of months according to the 'Time Point' column. The formula seems to work fine until I noticed that two entries (in purple) are not following the rule; they are supposed to add 9…
-
Have Smartsheet Forms Changed?
Hey, I have noticed that our forms have changed this morning and now have the more rounded feel that comes with Table View. In addition one of my forms now shows the date in the US region format of MM/DD/YYYY rather than the UK region format of DD/MM/YYYY and I cannot see a way to change this back. Has anyone else seen…
-
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…