I have a formula base column that I'm trying to get the sum in Sheet Summary and I'm getting the #invalid operation error. I have some criteria for the sum I'm looking for and I did the exact formula …
Hello world! I am trying to create a overview sheet that will be fetching values from two different lists. The two data sheets have a identifier number for each row in them, but placed in differant co…
Hi, I am looking to create a sheet summary formula that will count all entries on a sheet that came from the previous week. I figure that it will have to be a countif formula and will incorporate week…
Hey I'm trying to do this in a Sheet Summary: If [Date] is today, then show me the value in the same row in column G. This works for an individual row (1) =IF([Date]1 = TODAY(), [G]1, 0) But I can't g…
I am a new customer with the Pro plan but I am unable to change the Project Name on the Dashboard. It reads "Project Name in Summary Sheet", so I go to the Summary Sheet and it is grayed out with no o…
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" t…
I have a summary report that collates updates on all my team's projects. Earlier this week a colleague accidentally deleted one of the project sheets. The sheet has now been restored and the owner has…
I want to use the sheet summary to report how long a project has been put on hold. So I have the date that the project got put on hold, which is Aug 9, 2023. I want to automate the calaculation of how…