-
Tracking Which Reviewers Have Not Submitted Forms Across Multiple Sheets
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
-
Merged: Include Group, and Summaries in reports exported and sent as attachment
This discussion has been merged.
-
Stacked bar chart total values displayed above bars
I have several stacked bar charts due to lack of area graphs. These charts show data over time grouped by a category. The problem is that the user ends up 'approximating' the total of each stacked bar without having an actual total value displayed. Could you please add the ability to add a 'sum total amount' above each…
-
Sum values based on corresponding value in second column
Hello, I am working on a project aiming to calculate the remaining product cost for a list of contracts. I have two columns with data which both have multiple values separated by delimiters and need to add the values in column 1 (quantity shipped) if they match with a specific value from column 2 (dosage). Example Data:…
-
Dynamically choose column to sum/countif from a wider range?
I am working on some budget tracking. I have a source sheet with each expense account and how much is budgeted for each month (Jan-Dec) and it goes back years. I want to display the info on a graph that show Jan-Dec and the sum of all expense account budgeted amounts in each cell. Right now in my metric sheet I have the…
-
Report: Right-Click Header, "Group by this Column" and "Summarize this Column"
In Reports, It would be GREAT to be able to right click on a column header and add that column as a group or a summary. The options would be: 1. Group by this Column 2. Summarize this Column And then when you go to the GROUP or SUMMARIES menu, you can then select how you want it summarized or grouped.