Template/formula
Hi. I'm new to Smartsheet. Wondering if there was a template/formula that could assist with this problem? Say I have 10 building sites/projects and they are all staggered one week apart for commencement/completion over a 3 month period. I have a pipeline of projects that I can't start/bring online, until the next project is finished and so on. I use precedents, but it's the limit of 10 going at any time that makes this difficult to forecast/view/manage... Any suggestions on how I can set this up? TIA!😊
Answers
-
Hi @TJ44
I would suggest checking out the PMO template set. It's quite advanced if you're new, but there's an explanation on the side that may be helpful.
In the Project Intake sheet you would have a rollup of each Building Site / Project, but the Project Plan sheet would be the detailed steps per-project. Then the Dashboard rollup can give you an overview.
If you build out your own version from scratch, I'm sure we can help you set up formula to display on a Dashboard... for example the COUNT of how many projects are "In Progress" versus "Not Started" etc.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!