nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

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.

Welcome!

Forcing duration and start date to a specific value on Gantt

ilene_healy68056

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

Find more posts tagged with

Formulas

Gantt View

Comments

Alejandra

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.

ilene_healy68056

thank you for your response...I thought it would be a Catch 22 :-)

I will submit a request

thanks!

Ilene

Sign in to join the conversation!

Quick Links

Trending discussions

Need to parse text and Remove Data
I am trying to find a way to look at text fields and automatically remove date and time stamps plus employee names. Any recommendations on identifying and removing text strings that meet the below formats: YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] We have a…
Stacked IF AND Statement Returning "Invalid Data Type" Error
Hi All, I'm working on a formula that is evaluating three columns of data: 1) EOY Target Weighted MWh 2) Forecast Weighted MWh 3) Increase/Decrease (to determine if the goal for the year is to increase or decrease the MWh) Here is my current formula: =IF([Forecast Weighted MWh]@row = [EOY Target Weighted MWh]@row, "On…
Predecessor question
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much