Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Reports - Using formulas against reported data to pull into SIGHTS?
Hello,
Was unable to find this topic and for some reason thought report 'formulas' was on the 2017 roadmap for March but on couldn't find the community or annoucement so here I am.
I have a report pulling from several project plans. Within the report I'd like to summarize the reported data using formulas. example: Reporting on live projects, count the # of projects in the report (Sights widget pull this total) or simply of the live projects how many are; Red, Yellow or Green.
At this time I have to create another manual sheet, have the PM keep it up to date weekly on their assigned projects and then from there pull the formula totals across to the Sights widget.
Hoping to remove most if not all the manual input other than the PM managing the project sheets and pulling all data across to reports / sights.......
So the ques: When will adding a top row with formulas within REPORTS be available?
JH
Comments
-
have the exact same need.... looking forward to hearing back on this one.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives