-
Checkbox cross referencing person on another sheet
I am looking for a formula to cross check another sheet to check a box on my cumulative sheet. Example, someone completes a required training on EM# 1 sheet then on the EM# 2 sheet I want that persons name to be checked from a list of other individuals. This is the formula I used, =IF({Emergency Preparedness Employee…
-
Is there a way to have a date change in autofill within a formula?
I am looking to shift the way my data is displayed so I can place it in a dashboard. To do this, I'd like to shift the information within to do a specific date and return that. My formula works fine, but I have to change the date for every single line. Wondering if there's a shortcut or something that I could do to avoid…
-
Summary Formula to Show New Value Each Day
I have a sheet that tracks new employees by type. Within my sheet, I have a date column and employee type columns (example: Intern). I'd like to create a Summary formula within the sheet that will return the number of interns each day. Or a formula that will return the last entry in that column. How can I do that?
-
Formula with using three separate columns
I am trying to write a formula that counts the number of PINS Case_FRB based on Force Level_FRB and within a specific date range. I'm using the formula below, but it is not working. =COUNTIFS([Date Presented to FRB]1:[Date Presented to FRB]205, AND(@cell >= DATE(2021, 2, 1), @cell <= DATE(2021, 5, 5)), [Force…
-
Counting Children on Multiple Criteria
Hi all I am using the following formula in a parent row which has 10 child rows: =IF(COUNTIF(CHILDREN(), "Complete") < 10, "Not Done", "Done") It shows Done as soon as all the children rows have the word Complete in them. Now I want this formula to favor 2 conditions for "value_if_true" part of the "IF" function: if all…
-
Cross Reference Countif Formula is giving Unparsable Error.
I am hoping someone can help with Countifs formula referencing another sheet. The current formula that I have works great on the master sheet. =COUNTIFS([Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1), [Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31)) However, when I modify on another sheet to read as what is…
-
IF with multiple choices dropdown list cell
Hello everyone! English is a second language for me so please forgive my spelling mistakes in advance. I have a form with a multiple choice dropdown that populates one of my columns in my sheet. I want to do an IF to give a rating based on the answers. Here's what I got: =IF([Question]@row = "answer1" and "answer2"); 0;…
-
Workflow automation for when a cell in a column does not change status
Trying to see if there is a work around for setting up a workflow automation to trigger when a status column does NOT changes status from planning to in progress after 14 days. I only see triggers for when a column or row has changed, but nothing for when a column doesn't change. Any suggestions?
-
Adding a number of months to a date using formulas
I have a calibration sheet that lists the number of months required between calibration dates and a column that states when the last calibration was carried out. I would like to use these 2 columns to calculate the date when the equipment next requires calibration. Can anyone help? Thanks, Colin
-
Issues with evaluating Dates
I need to evaluate a date in a 'target closure' column, and report the fiscal quarter. I have created a separate sheet to help me automate it. The Fiscal Calendar sheet has 3 simple column with Quarter Number, Quarter Start Date and Quarter End Date (screenshot below) (The start and End Date column are Date Columns) in my…
