-
Multiple checkboxes in one cell - Formula for True (Part 2)
This is a follow question - reposting for visibility. While my original question was answered, I'm now having trouble with the formula. This formula seems to be working, however I am expecting it to return symbols. Instead, it is only returning the "text". Anyone have an idea why...? The column type is set to Symbols and…
-
Countif with OR statement
Hi, Looking for some assistance on a cross sheet formula I made the filter using below screen criteria in the metric sheet, but unable to make it in Countif using OR into Intake Sheet to show the numbers in Widget. I tried with below formula: =COUNTIFS({RiskCategory}, "", {RiskDescription}, "", {RiskMitigationPlan}, "") ,…
-
SUMIFS Reference Formula with two date columns and one condition. Formula is computing 0
Hi can anyone see if they can think of what might be causing this formula to compute 0 and not Summing the {Check In Log Range 1} {Check In Log Range 1} = Dollar Volume {Check In Log Range 2} = Employee Condition {Check In Log Range 3} = Start Date {Check In Log Range 4} = End Date =SUMIFS({Check In Log Range 1}, {Check In…
-
Autopopulate multiple columns based on the selection of one drop down?
I'm creating a Form for my end users and would like to pull back information on specific stores. I have 246 stores with addresses. I have these columns that will need to populate data based on the option selected in the Store # (Drop Down): Like I said above, I have 246 different stores that will each have their Store…
-
How to calculate the # of times a persons name is listed in multiple columns
Using "Nikki Pooler" as an example - her name is listed in "Responsible, Accountable, Production Operations" The formula that works but ONLY pulls in the "Responsible" and " Accountable" columns is: =COUNTIF(Responsible:Accountable, HAS(@cell, "Nikki Pooler")) How do I expand this to include the column "Production…
-
Count unique contributors in 2 columns
Hi, I am trying to count the number of unique contributors to a project. Our structure requires us to use 2 contact list columns, with only one entry per row (no multiple contacts in a cell) The 2 columns are Assigned To, and Collaborator. They are several columns apart. In some instances the lead on one aspect (Assigned…
-
COUNTIF to reference another sheet.
I am trying to use the COUNTIF formula to count the number of times a certain text appears in a column. I can easily do this, if I am working on that sheet, but if I want to reference another sheet it wont work. North Coast FY24 (2023-2024)= the name of the spreadsheet Clean Water for Reefs= the text I am trying to get a…
-
If/Then to have date field modify status field.
Looking to input a formula so that changing the "start date" of a row will change the "status" in the column next to it. Tried the following: =IF(AND([Start Date]@row < [Est. End]@row, [Est. End]@row < [Actual End]@row, [Actual End]@row = ""), "IN PROGRESS", IF(AND([Start Date]@row < [Est. End]@row, [Est. End]@row <…
-
I can't seem to make my IF/AND formula work
I want to show a figure of 48000 in a cell when the Total Biogas Actual m3 cell on the row is greater than 0 and the LG cell on the row states Local Generation: =IF(AND([Total Biogas Actual m3]1= >0, [LG]1= Local Generation), "48000", "0") I've tried several different ways but all I get is #UNPARSEABLE or…
-
How to change my formula to flag yellow on due dates instead of red.
I believe this is an easy fix, I am just not able to figure it out! I am trying to change my formula so that the status icon does not change to red only once it is in progress for tasks due today. I would rather it show as yellow if something is due today, then red if it passes its due date. Here is my current formula:…