30/60/90
Is there a formula quick guide on how to create a 30/60/90 day outlook in a dashboard of upcoming projects finishing and starting? I am banging my head trying to figure it out.
Thanks in advance.
Answers
-
Exactly how would you want it displayed? Just some basic numbers in a Metrics Widget, or were you wanting to chart these out?
-
We wanted to turn it into a pie chart
-
Ok. You would want to set up a table so that you had 30 Day, 60 Day, and 90 Day in their own rows. You would then use a COUNTIFS formula for each to get the counts of how many projects fall into the appropriate categories. Then you can reference this table in your Chart widget.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!