-
Merged: Global Update Find/Replace & Sheet Summary
This discussion has been merged.
-
Sumif Formula Question
I have a sheet containing a Time Block column as well as a Type column. Both are dropdown columns one with time in hours (.24, .5, .75, 1, 2 and so on), the other has types of activities (Dev Meeting, General Admin, and so on). I am trying to build a formula that adds the time for each activity by the month. I can't get…
-
Sheet Summary fields not showing all data on Report
Please see the image. For some reason some sheet summary fields are not displaying on the report and others are. All are visible when I view the fields from the report. I've tried moving the sheet to a different workspace and folder, changed the values in the fields, etc., nothing works. Why are the green showing just fine…
-
Why isn't my COUNTIF formula updating?
I am using the COUNTIF formula to keep track of quarterly reporting status for clients. For example, I need to track how many clients have a "failure to report" status. The row that I am pulling the data from is a dropdown selection - which I have never had issues with before now. When I plug in the formula, it registers…
-
Use of sheet summary fields (or formulas) in automation
It would be great to be able to include calculated values and/or sheet summary fields within automation. In general, the point is including global conditions in the automation criteria. An example is an employee calendar with daily alerts as to who is out of the office. When people are out for a range crossing a…
-
Custom Columns in 'Sheet Summary' Report
This report is amazing and could be super useful if we have the ability to customize the column names according to our team's/organization's needs. The columns in the 'Sheet Summary' report get auto-generated and are not based on the source sheet(s). We need to be able to customize these as my team uses different legends…
-
Find the most recently passed Thursday based on Today's date
I want to count the number of project manager status update sheets that are not updated to the most recently passed Thursday. All the project managers are supposed to update their status update sheets every Thursday. On the following Sunday/Monday, I will check and see which status update sheets are not updated to the most…
-
How to use COUNTIF in a Sheet Summary Report
Hello - I am trying to add several COUNTIF formulas for different lines in my Sheet Summary Report. I would like the formula to reference how many times the status Action, Risk, etc. are in the column. I only get INVALID REF or UNPARSEABLE. I have tried the below among others, thank you! =COUNTIF({Log Entry Type},…
-
How do I calculate the sum of a length of time column in the Sheet Summary
I want to be able to calculate the total length of time of all the video files in a sheet for the Sheet Summary. (to then be able to report across multiple sheets, populate in a dashboard etc). These are not formulas and there is also no start or end time as this is the length of a video, not work time. Also, as these are…
-
IF Formula with Multiple Choice
Hello! I want to build an IF formula into columns when the multiple boxes has selected the right department. IF the Authorizer is marketing and finance, the emails would automatically populate in marketing and finance column. Not sure if this can be done. Would appreciate your help greatly!! Thank you very much.
