Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Dear Community,
Is it possible to set a formula so that the Start Date always equals the End Date and that the Duration is always '0'? We are tracking key milestones and are only provided the End Date. I'd like to reduce the manual entry to automatically make the Start Date match the End Date and ensure that the Duration is set to 0 so that they show up as milestones on our Gantt chart.
Thanks for any advice
Ilene
Hi Ilene,
It sound like you're working with a project sheet (that has dependencies enabled). If so, it's important to know that formulas are not supported in project columns like the Start and Finish date.
Also, milestones only work when dependencies are enabled. If needed, more information on Project Settings can be found in our help article: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors
I encourage you to submit a Product Enhancement Request to let our Product team know that you'd like to have the ability to do this in Smartsheet.
Hi
thank you for your response...I thought it would be a Catch 22 :-)
I will submit a request
thanks!
Hi all! I'm working on a column formula that will check whether the Column2ref cell in the current row is blank. If it is blank, the formula finds the maximum value in the ID column where the Trainer Name matches the Trainer Name cell value in the current row and the ID cell value is less than the ID cell value in the…
How do I see who submitted a form for a specific sheet?
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
