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...
*IDs have been omited for privacy but there are values in the column I need to bring in the Week # values from the Master Tracker - 2026 sheet into the Week-Over-Week Modified sheet. The group and APC ID need to match. There is a potential of duplicate APC values which is why I need the group to be a criteria as well. I…
I have one sheet that is tracking PTO where a user has entered the days off. The form allows them to enter a start and end date for their PTO and enters a single record into the sheet. I have a second sheet that I am looking to pull that data into, but there is only one record per person (column in this sheet where the…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
