-
RAG indicator options
Hi there community I have a portfolio of several hundred projects being monitored and reported via dashboards and reports in Smartsheet. We are currently using RAG indicators against schedule as follows: Red - Incomplete at reporting date or due date passed Amber - at risk Green - schedule within tolerances (+/- 10%…
-
Reporting like pivot or sumif. How to roll up values by name or category?
Is there a way to combine cell entries and give the total assigned to that category? Ex. Project Lead Cost savings John $100 Mary $500 Bob $400 John $200 Mary $75 Bob $60 REPORT = John Total = $300 Mary Total = $575 Bob Total = $460
-
is it possible to include a critical path in the report ?
is it possible to include a critical path in the report or in dashboard ? Unless there's some other way to get it out of the sheet into another sheet ?
-
I need a checkbox formula where criteria is one of many dropdowns selected for a given cell
I'm trying to write a formula that would check a checkbox if a dropdown selection is chosen for a specific cell, where other dropdown selections are also chosen. E.g. Dropdown selections a,b,c,d are all selected as all apply, and I want a checkbox in a separate column to populate if selection 'a' is amongst those chosen.…
-
Sheet summary - count of Status from multiple source sheets
Hello, I have 7 source sheets that I would like to use for a sheet summary report. Only one of the sheets is returning values to the report. All the sheets have the same 'Status' column, with the same values in the dropdown. Question is: why is only one sheet returning values?
-
Sheet summary can be added to a report
I have created a report from 3 different smartsheets to merge it in a single sheet report. This report shows in a single view all our Purchase Orders from 3 different line of business Now I'm creating a dashboard to show quarterly trends (i.e. # requisitions submitted, # of requisitions completed and total requisitions…
-
Separate Sheet/Report Formatting?
Greetings Smartsheet community... I apologize if someone has asked this before... I'd like to clear the formatting from the Sheet data when viewing it via a Report... but then add my own formatting to that specific Report so that everything is consistent when displaying the Report as a Dashboard Widget. Is there a way to…
-
Did the 'View cell history' get removed from collaborators?
I seen a community session where some license users said the 'view cell history' function was being taken away back in 2019 but then the last message noted said the decision was reverted and the function was going to continue to work on all permission levels. A vendor just emailed me asking me to provide them the cell…
-
Published Report Links
Is there a way to see any/all reports for which I've created a public link? I am curious if there's a way to review this from time to time, so I might unpublish certain reports when a project is complete and the shared access is no longer required.
-
Why can't I pick the data I need for a chart from a report
I have a chart that is pulling the information from a report that has additional columns which are used to make sure only the correct rows information is pulled from the base sheet. However, as I'm trying to do this the Chart will only select the whole report and not give me the option to select the chart data in the…