Multi-year projects
Discussion List
- This discussion has been merged.
- I've seen some past posts where users tried to create their own columns for this, but they seemed to have errors in the way the calculations were done. What is the latest solution from smartsheet (or …
- Hello! I'm looking to pull the Fiscal Year in a cell based on the launch date in a different cell. Our FY starts on 04/01 of the current and ends on 03/31 of the following year. I need the formula to …
- Hi! We have a long list of about 100 projects in a sheet - about 80 of them will be "restarting" or "renewing" this year. Instead of making the requesters fill out the intake form again, I'm hoping to…
- I have multiple tasks with various durations. At some point, most task's duration overlaps with another. I need to project out on any given day what my total labor needs would be for that day. I have …
- I have multiple schedules for different projects with the same base information: Task Name (Primary) Start Work Date End Work Date Duration (Dependencies are enabled) Manpower Needed Many tasks have d…
- What formula to use, to calculate records from today till 6 months down the line? And this rule should be valid at all times. In other words, how to calculate sum of values eg: count of total number o…
- Hello Community, I am trying to track projects over multiple years, but each project varies in length. My concerns are hitting the max number of columns and not having to do a bunch of manual set up a…
