-
Cell range and Sheet Summary
I have an expense 'tracker'. Essentially it tracks if employees submitted their expenses (1) correct the first time; (2) expense was sent back for revision; (3) submitted late (4) did not submit My columns across top are months of the year. My rows are employee names. I have a sheet summary that totals (1), (2), (3) and…
-
Center and middle justify summary fields in a report
I have created a summary field in my Smartsheet that is a formula: Overdue Tasks =COUNTIFS(Status:Status, <>"Complete", Status:Status, <>"Canceled", Finish:Finish, <TODAY()) Works just great! Returns a number that I would expect. The challenge is that when I create a row summary report that references the field Overdue…
-
SumIf Date Range
Hi All! I'm trying to use the Summary in a sheet to tabulate an object count between a date range. I'm trying to get a Sum of cells in a column "Number of Objects", if the "Date Imported" is between a range, 09/01/21- 08/31/22. The formula I'm using is returning "0". The formula is : =SUMIF([Date Imported]:[Date Imported],…
-
Formula to return the average of points assigned to a specific person within a specific date range
Hi all, I have a fairly complex formula I'm tying to create, and can't manage to make it work. Let's say my data sheet has three columns, representing a point value given to an individual on a specific date: Person (Number/Text, each cell contains one name) Points (Number/Text, each cell contains one number) Date (Date,…
-
Sum dollars based on names in multiple columns
I have a shared tips sheet. A big tip is divided by the coaches that are coaching for the group. If John is coach 1, Dave is coach 2, and Skye is coach 3, then the $30 tip would be split $10 each. The next group may have Skye , Mike, and Nate and may have a $60 tip. Etc. I am trying to write a formula that says of Skye is…
-
Sheet Summary Formula versus Sheet/Report Filtering
Hi all, I've been scratching my head on this for a while and I can't resolve why the filtering I do on a sheet/report is not matching my formula on a sheet (upon which the report is based on). Here it goes: I have an intake sheet for my projects that when a PM creates a project via Control Centre, it spits out the expected…
-
Ability to “freeze” the Gantt Chart Bar
When a sheet is showing the Gantt Chart and you open the Sheet Summary, the left side of the Gantt Chart is pushed left to make room for the Sheet Summary. When you close the Sheet Summary the left side is not returned to where it was. EVERY TIME we access the Sheet Summary we need to drag the Gantt Chart back to where it…
-
How do I display counts of all of the dropdown options used on one sheet and possibly multiple?
Long story short, I'm building a system to track pending legislation, and for each bill that posts, team members are assigned it to one (or more) categories in a CATEGORY dropdown column. I'm working on a dashboard of high-level views, and I'm trying to figure out the most efficient way to roll-up and display how many (and…
-
Sheet Summary box COUNTIFS + AND/OR
I am trying to do something similar on the summary of a sheet.... I want to count if proposed start date column is less than or equal to today, as well as if the PC 2 column = one of "S1", "S2", "S3","S4","S5","S6","S7","S8","S9". I attempted by just trying "S1","S2","S3".... =COUNTIFS([Proposed Start Date]:[Proposed Start…
-
Will We Ever Be Able to Use Summary Fields in Automations
So I have done quite a bit of research on this and have found the same answer every time stating that we can't directly reference summary fields in automations. I don't want to have to create a helper column for this as that defeats the purpose of the summary field. Has anyone heard if Smartsheet will add the functionality…
