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 specifi…
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…
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…
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 si…
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 …
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",…
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…
I am trying to produce a report of specific Summary data fields, across multiple sheets, and aggregate a list of that particular field. Any ideas on how to do this? In a nutshell, I'm trying to produc…
Hello, I have a formula in my sheet summary that was working until recently. For some reason the formula is no longer able to count the months or years in the sheet. I also receive the error when I re…
I am attempting to create 2 separate dashboards, for 2 different regions, from a single Smartsheet, using Sheet Summary. I can not seem to figure out how to name the summary fields the same or convers…