-
Chart Dashboard Widget using Sheet Summary data fields
It would be great to be able to use the chart widget with data held at Sheet Summary level. Appreciate that there are 2 ways around this : Create a report and chart against that Add "helper columns" to the sheet itself However, I'd prefer to reduce the number of new reports I'm creating, and keep sheet complexity lower…
-
Merged: Cell Linking And Referencing Sheet Summary Fields From Other Sheet
This discussion has been merged.
-
Control Center: Summary Data on a Different Sheet
In a Control Center blueprint, is it possible to send summary data to only one metadata sheet, then reference that data in column formulas (i.e. JOIN) from the project sheet? The need to have the summary data at the top of my template sheet is really screwing up my workflow. I have sheets that I want users to access via…
-
Allow sheet Summary Reports as a source for Dynamic Views
It would be helpful to be able to share summary field information from multiple projects using Dynamic View and a Summary Report. Summary Reports are an excellent way to share summary field data for multiple projects. Sharing this data using Dynamic View allows the owner/admin to show key fields in a grid, then make…
-
How do I create a pie chart from the data on my sheet? Assuming I need a formula?
I have a column with rows of dollar amounts called Grant Amount and a column with a drop down menu of three options called Scope of Work. My goal is to create a pie chart on my dashboard showing what percentage of the total amount of dollars from the Grant Amount column is going toward the options chosen in the Scope of…
-
Dashboard Update Automatically Daily
Hello, I'm having issues with a dashboard I have set up, not updating information from a sheet until that sheet is opened/refreshed. I currently have a sheet with rows of names and corresponding dates; basically, shift schedules by day. I then pull whatever names correspond to today's date into a sheet summary and have a…
-
Symbols in Sheet Summary Pane
Hello All, Thank you in advance for your help. I have a Red, Yellow, and Green symbols column in my grid view. In the sheet summary pane I want to have a summary column that provides the minimum value of the symbols column. When I use this formula in the sheet summary, =MIN([Project Health]:[Project Health]) I just get the…
-
Smartsheet Color Matrix Names and Hex Codes + Programmatic Conditional Formatting
Howdy Smartsheet Community :) During a recent exercise to make Conditional Formatting programmatic, I indexed the color names and hex codes of the 8 x 5 Smartsheet color matrix. Wanted to share the results with everyone here, in case you have a need to extend these colors through non-Smartsheet collateral:…
-
ISBLANK AND formula issue
Hi Community: If a task has gone unassigned for >=5 days after initial entry has occurred AND the task has not been assigned to someone, I need to flag the concern and workflow route to a specific individual. Column A: Intention for IF this column is BLANK (fyi Properties of this column is dropdown list) AND Column B has…
-
"#invalid column value" Error in Sheet Summary
Hello all, I would like to retrieve the date of "LR1" with the following Index Match function (see field 18). Once I hit enter I receive the error message "#invalid column value". Is something wrong with my formular?: =INDEX(Finish:Finish, MATCH([Field 16]#, [Task Name]:[Task Name], 0)) Many thanks in advance for any help…