-
Formula to check a box based on two conditions
I have a sheet with a client name on the sheet 1. I want to check a box on sheet 1 based on the values on the CRM sheet. If the CRM sheet has the client name on sheet 1 and the offer status column is "Accepted" on the CRM sheet, I want to check a box on sheet 1 next to the clients name. They may be listed in the CRM sheet…
-
COUNTIFS formula returns zero, confirmed should have positive value
Hello - I created this formula and it does not error out but it does not correctly count the field what did I do wrong? =COUNTIFS({Polaris minus CSC Creator1}, =Creator@row, {Polaris minus CSC Substatus}, "Open-Update Needed" + COUNTIFS({Polaris minus CSC Creator1}, =Creator@row, {Polaris minus CSC Substatus},…
-
Using COUNTIFS to count number of occurrences within two different sheets = UNPARSEABLE
Hello - This is my first time using this community. I am trying count across two sheets to count the number of times a name is present in a column. They could be contained in both or just one sheet. My formula is continually wrong and from experience I know that it is likely something little that I am missing. Here is the…
-
Using COUNTIFS to count number of occurrences within two different sheets = UNPARSEABLE
Hello - This is my first time using this community. I am trying count across two sheets to count the number of times a name is present in a column. They could be contained in both or just one sheet. My formula is continually wrong and from experience I know that it is likely something little that I am missing. Here is the…
-
Count Active assignments by individual
=COUNTIFS([Assigned To]:[Assigned To], ("Name"))AND [Request Status];[Request Status], is one of "In Progress", "Submitted", "Completed") My countifs statement works by name but I want to further refine this by [Request Status];[Request Status], is one of "In Progress", "Submitted", "Completed")
-
Need someone's logical brain on a formula
Hi all, I need help fixing this formula: =COUNTIFS({TGN Bluesheet Tracking List Range 4}, =DATE(2023, 6, 20), {TGN Content Range 2}, =AND("Facebook" "Instagram" "Threads" "X" "YouTube")). I'm trying to pull the number of a specific dropdown list from a specific date. Any ideas on the best formula?
-
How do I Chart Monthly Summaries from a Metric Sheet into a Dashboard
Hello Community, I am having a grand 'ol time trying to display onto a dashboard, Monthly Summaries of certain metrics from our packaging lines. Was looking for both most recent month look back and last 3 months as well. I have a host of monthly data sets on a Metric Sheet both as Summaries and Averages and I didn't want…
-
Help with Health Symbol
I have a formula to populate the health status but would like it to return "Green", regardless of whether there's information in the End Date. It seems to me like this should do it. But as you can see in the below screen shot, when the status is "Complete", the Health field is blank. Here's the text of the formula in case…
-
JOIN with 2 columns that are NOT next to each other, and "force" order
I am (trying to) using the JOIN function. It works but NOT the way I want it to. First, the columns I wanted to join were not next to each other. I am attempting to join 2 columns in a specific order and NOT the column in between. What am I doing wrong? They need to be in this order as the essential piece of data is the…
-
INDEX/MATCH and INDEX/COLLECT Issues
Hi, I am essentially trying to combine the two below formulas into one. I keep seeing that I should be able to use a COLLECT formula instead of MATCH to have two criteria, but whatever I do it isn't working. The formulas: =IF(WFX@row <> INDEX(WFX:WFX, MATCH(Quarter@row, Quarter:Quarter, 0)), "Yes", "Applied") =IF(WFX@row =…
