-
Can an error message generated by a formula be used to trigger a workflow?
I've seen suggestions in other forum posts that this does not work, but nothing conclusive. I have an index/match formula to link data from sheet 1 to sheet 2. If the indexed row in sheet 1 is later deleted (the project is cancelled, for instance) there is no longer a match and I get a #NO MATCH error in sheet 2. I want to…
-
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…
-
CountIFS for Parent Row Only
Hello - I am displaying some information regarding things that are approved, in queue or denied. But I am needing to only count parent rows and not the children for them. So the data collected are just for the overall brand and not sub-brands. Is there a way for me to make this happen? Thank you - Mmurray
-
index match crossheet
i have sheet A that will look at sheets Q1,Q2,Q3,Q4 TO CONFIRM IF THERE IS A MATCH. and if not to return no match =IFERROR(IFERROR(IFERROR(IFERROR(INDEX({Q1 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q1 INV 2022 Range 1}, 0)), INDEX({Q2 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q2 INV 2022 Range 1}, 0))), INDEX({Q3 INV 2022…
-
Formula to count issues raised this quarter and in previous quarter
I am putting together a metric sheet that will count issues raised based on various dates. I already have it set up to count this month vs last month, but I need help doing the same for quarter. In my main data set I have added a helper column to return the quarter based on the date an issue was flagged. How can I use this…
-
Attendance Point Tracking - Referencing a previous entry
About a year ago, I threw together a janky system to keep track of employee attendance. The idea is that there are different point values assigned to each kind of attendance occurrence, which the points fall off after a year. However, we have added a twist that is throwing me for loop. We now have a policy where if they…
-
What formula can I use to return a value if the value is in between 2 dates?
Hi! I have two sheets. Sheet #1 is a support schedule with columns for every day of the schedule, each column is a dropdown menu column. I extracted the date in text form for each day as shown in the first screenshot. For each day we have different resources assigned in a different column. In sheet #2, I want to have my…
-
COUNTIF formula returning 10 extra blank lines
I wrote a formula to count the total number of unassigned purchase orders in my sheet, which looked to be working at first glance, but upon comparing it to the actual data in the sheet, realized that it is counting 10 ghost orders. This is my formula: =COUNTIF({Assigned}, ISBLANK(@cell)) The Assigned column is a contact…
-
Why is my SUMIFS formula saying incorrect argument?
I'm working on a metrics sheet to power a dashboard. I want to sum our effort values for each of our chemists and each of our project categories. My ranges are: {MasterLead} : Column listing chemist on project {MasterEffort} : Column of effort values for each project {MasterRDCat} : Column of project categories I am trying…
-
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…
