- Automation on Sheet Summary Fields
Workflow/automation based on sheet summary fields. One scenario - count of all cells, send a warning if the sheet is close to max. (Do not want helper column as that increases the count.)
- Why are my Blueprint Summaries blank?
你好,我们最近开始使用聪明sheet CC. We had 5 blueprint summaries created and they're all working fine. I wanted to add a new column to one of my blueprint summaries, but when I went through the Blueprint Builder, the blueprint summary section now has blanks for sheet selections when just yesterday the 5…
- SCC Fails to update links error
One issue we are having is automation from SCC at job creation to send specific information from a project to Intake sheet. Here is what logic we applied and the error we get, can you look and maybe advise a solution for us? On Intake Sheet, we have the fields “PS Start Date” and “PS End Date” that are set push from…
- Index Match Formula help. Index Match of Health status of an activity into Sheet Summary
I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index Match formula to search for Task A in Task Name column and spit out Health symbol. =INDEX(Health:Health, MATCH("Task A",…
- COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
- Formula Help Please - Sheet Summary
Hi everyone - I have a GIANT sheet I'm working with that contains our project portfolio. I need to add summary fields to capture Project Status (from a dop down field in a column) across 10 different Sponsor Divisions (also in a drop down field within a column). I can't seem to crack this one. Can someone help? I'm sure…
- Display 2 dates in one sheet summary field
can I display both a start date column and end date column value in ONE sheet summary field IE start date column in sheet 11/7 end date column in sheet11/14 Sheet Summary field 11/7-11/14 Help please :)
- Showing Sheet Summary Data in Another Sheet?
I am building SheetB to compare my budget by categories (data entered manually for now) against my actual expenses (entered in SheetA - totals for each category are part of my Sheet Summary data). Is there a way to reference those Sheet Summary totals in SheetB? Ideally, I will then be able to use SheetB to create charts…
- CountIf Date formula compare different date columns
I have 3 date columns: Start Date, Draft Due Date, Final Due Date The date columns are all initially auto-set to the same date; professionals are to subsequently update the Draft and Final due dates to a later date. I would like to count the ones that never get updated, i.e. Draft Due Date = Start Date. By the filters…
- Access a Sheet Summary field from a different sheet?
I have 2 sheets and want to be able to pull the value from a sheet summary field on Sheet A into a cell in the grid of Sheet B. Is there a way to directly reference this? I know how to cell link from a grid cell of Sheet A into Sheet B but not summary field. I guess I could set up a helper column in Sheet A to pull in the…
