-
Summary Fields for Dashboard based on dropdown values
Hi All, I have a rewuirement and, although I have a solution, it is very manual. I was wondering if there was a better andmore efficient way of doing what I needed. It is a question of reverse engineering in that my requirement starts with the end product a dashboard. On this dashboard I wish to show, in graph format, how…
-
How to create a sum column formula in Sheet Summary
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 for the [DDA Hours Used] column, so I'm not understanding why this one isn't working.
-
How can i make a row automatically get created and updated in one sheet as it is created elsewere
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 coloumns were only in one of the sheets is this identifier the Primary coloumn, so automating copy and paste row to other…
-
Count entries made the previous week
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 weeknumber but I am lost on how to count from the previous week and have it keep updating for the next week.
-
Can I add the totals of two or more Summary Fields to create a Grand Total Summary Field?
-
Summary formula
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 get it to work with @row to search all the way down the sheet to look for the current date, I've tried these: =IF([Date]@row…
-
Why can't I change the project name on the dashboard?
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 option to edit. Please don't tell me I need to pay more to change the Project Name.
-
Linking restored files back to existing reports
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 confirmed everything's working as it should. However I now can't link it back to my report…?! When I look at the sheets to…
-
Getting the difference between a past date and today's date
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 many days it has been at any given time. I've tried multiple formulas and none of them are working. Even typing in =TODAY()…
-
I'm having issues with COUNTIFS - can someone help?
This works =COUNTIF(Priority:Priority, "P1") This works =COUNTIFS(Priority:Priority, "P1") + COUNTIF(Priority:Priority, "P2") This works =COUNTIFS(Priority:Priority, "P1") + COUNTIF(Status:Status, "Done") but it adds them up I can't get the countifs to only show records that are P1 AND (Done OR Declined). I've looked…