-
nested countif with date criteria
I'm trying to do a countif statement that checks if a request is approved or denied, and the return to work date is great than today's date. I've tried multiple ways and can't figure it out. Any ideas?
-
count if statements not working
I'm trying to get my countif statements to work. I need to count multiple dept IDs in one column, and pulling information from multiple sheets into one dashboard. In one column, the countif statement IS working and returning a calculated number. It looks like this: =COUNTIF({Age 65 and over Range 1}, ="362") + COUNTIF({Age…
-
Determining Final Approval Status
I have an approval flow that can go to one of three contacts (sometimes two). I want to add a Final Status column to make it easier to count in a summary sheet and eventual put it on a dashboard. I'm trying to create a formula with the following logic: If any of the three columns contains "Denied", the Final Status is…
-
How to create 2-way sharing across sheets?
Hi, I am trying to make certain cells accessible for 2 way sharing. Is there a function like cell-linking that is available 2-ways? There is some financial data but mostly personnel/task and resources. Thank you, Esperanza
-
Formula error on Duplicate date check
Have found this formula in previous discussions but is unparseable. I have gone through it a couple of times and think it is down to wrongly set parentheses, or? Slutdato=enddate, Startdato=start date. Looking to flag (double booking) if startdates or enddates overlap. =IF(ISBLANK(Startdato@row; “”);…
-
formula for daily count
I'm looking to count how many times "blank" occurs in the status column per date. Entries are made daily and some days have multiple entries. I would like to set up a way to get a count of number of entries per day.
-
formula question
Hi, Please can you assist with a formula for the attached image. So if the induction column has "Yes" and Presentation column has "Yes" then the complete column should state "Yes". I'd like this formula to be inserted in the complete column.
-
Datamesh - way to transfer only parent row to sheet?
Hi all, I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet. The Pivot Table is set up where each row I need copied into the existing spreadsheet has a Parent Row (a number) and a Child…
-
Help with Index/Match formula
I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to check the box.
-
Nested if for FLAG column
I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the date is in the past and (3)if another referenced value [Shipping Status] does not have…