Sign in to join the conversation:
Is there a formula or a work around to produce the duration of a project when given the start date of the project and the end date of a project? In Excel (=DATEDIF(D9, E9, "d") is a simple formula but in Smartsheet what am I'm missing?
If you enable Dependencies under the project settings it will auto add a duration column. Assuming you indent all your tasks to your first row, it'll capture your total project duration.
In addition to that, you can also use the networkdays, or netdays formula to calculate the number of working days or calendar days between the first and last date in the project...
How do I set up the automation to move a row once the created date reaches 5 days?
Hi all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
