-
Reference Sheet CountIfs Formula
Hi I need help in doing a count ifs in another sheet. My countifs formula currently works in the summary section of the sheet but when doing a sheet reference it doesn't. The working countifs formula is: =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", Status:Status, "Open", Project:Project, "Data Analytics &…
-
Count the number of submissions received each month year over year
I am looking for help creating a formula to count the number of form submissions in each month year over year. Ultimately, I would like to compare if the number of submissions differs in corresponding months year over year. I have Created (Date) column types which I think will help. I've tried using the MONTH() formula and…
-
We have date range column and want to count monthly totals
We have project where we are migrating customers weekly - want to capture the total number of completed migrations by month. I have completed date and a check box when the customer is migrated. How do I do that range for the month?
-
COUNTIFS
I want the formula to count how many risks there are that are open. =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open"))) I can't seem to get it to work. Can anyone help? Thanks
-
How can I apply a formula to a whole column
We have a webform populating a sheet. (See screenshot) We have formulas set up on the additional 3 columns but they don't populate when the webform is submitted. At the moment, we have to drag the formulas manually. Is there a way I can apply the formula to the whole column?
-
Lookup() returning #NO MATCH when it is definitely there
I have created a new sheet to store the priority values of my ticketing system so if I change the values I don't need to change all the formulas on my main sheet. It's used to determine when to set the due date. It works fine for Low and normal, when I change the values it changes the due date correctly, but when I select…
-
Automate Status Based on Due Date and Complete Date
I have a status column that uses the Red, Yellow, Green, and Blue symbols. I would like it to automatically update based on the dates in the Due Date and Compete Date columns. The parameters are as follows: If there is a Complete Date = Green If there is no Complete Date, AND Due Date is over 7 days away = Blue If there is…
-
IF / AND Function for Checkbox
Hello, I am struggling to get a formula to work. I have a sheet tracking vehicle hours. (hours updated automatically through API feed) and would like to have a check box selected if the vehicle hours fall within a range. (the range is between 4900 & 5000. (each row is one vehicle) My formula is =IF(AND([Meter…
-
With checkbox column, how do I automatically check the children when the parent is checked?
I have an automation that sends completed projects to a new list when the completed column is checked. I want to make sure the children rows move with the parent row without having to check each individual child. How can I create a formula that automatically checks the column of the children rows when the parent row is…
-
Do shared users need access to other sheets from which cells are linked?
We have a sheet which pulls most of its data via cell link. We do not want to provide access to the reference sheet to the shared users. Will they still be able to see the data in the sheet we do share with them, or is it like a report where they would need access to the reference sheet? Thank you!