-
sum if and match range of cells in
Hello, I am trying to sum rows in a column if a text in 1 column matches text in a range in another column. And have that number show up in a Summary field. If we look at the sheet, I want to sum values in the "# of Views" column if the data in "Workspace Title" match a range of cells in the Workspace column. So the…
-
Hello! I am looking for help with a formula. I am trying to do at risk/overdue/not started. Do I mak
Hello! I am looking for help with a formula. I am trying to do at risk/overdue/not started. Do I make separate columns for all three and what would the formula be? I am making a dashboard and want the at risk and overdue to go by the Deadline.
-
Automation stopped working
Hello, I have a sheet that holds the anniversaries and birthdates of each employee, and a few automations to send a reminder 1 week before and 1 day before. Since I made the sheet last July, it has worked fine, but now I'm seeing some issues come up. What I received this morning was a correct one, along with one that was 2…
-
Weeks of 2023 calculating incorrectly
Using the same formula I used for 2022. =IF(WEEKDAY(DATE(Year@row, 1, 1) + Week@row * 7) = 2, DATE(Year@row, 1, 1) + Week@row * 7, (DATE(Year@row, 1, 1) + Week@row * 7) - (WEEKDAY(DATE(Year@row, 1, 1) + Week@row * 7) - 2)) Results for 2022 come back correct for week 1 but for 2023 comes back with the date that should be…
-
IFERROR Not Working To Remove Invalid Value
Hello, Is anyone familiar with using IFERROR with an INDEX formula? I cannot get it to work with the below. The formula's working. I need it to remove the "Invalid Value" for cells with no value. Any help is appreciated! =INDEX(COLLECT({Paid/ Donated}, {Employee Name}, HAS(@cell, [Legal Name V02]@row)), 1)
-
Converting University semester weeks into calendar dates
Hello, Can you help me convert University Semester Week Numbers into calendar dates? Can I use a conversion sheet to do this? For example, Spring Semester begins January 17, 2023- week 1. Can week one be converted to January 17, 2023? Thanks!!
-
Calculated Days Delayed. weeks delayed
I have to count Days delayed; week delayed. from the dates below. I am not sure what formulas i should use. I was first going with FinishDate - Duration but that wouldn't work since the duration is calculated between Start and Finish.
-
COUNTIFS Formula
Hi I am using a COUNTIF formula to count the number of projects, from my central intake sheet, that belong to a particular portfolio, have one of two status and belong to a particular programme e.g. Bus. Ops. Portfolio, Premises Programme with a submission status of Prioritised or Approved - Awaiting Prioritisation. The…
-
Referencing Status Codes by Color for At Risk Formula
I would like to mark tasks with an "At Risk" check if we are within 3 days of the "End Date" and the "Status" is NOT green. The status column is currently as follows: =IF(AND([End Date]@row < TODAY(), Complete@row = 0), "Red", IF(Complete@row = 1, "Green", "Gray")) I've seen formulas to incorporate the "At Risk" check…
-
Need text response in cell if criteria are met or not.
Greetings- I have 6 columns with symbols. I have a working formula if all 6 columns have a green check the column before shows the words "All Approved" and the cell goes green. This works just fine. What I cant get to work is if one of the columns has a red X or more then one red X the first column reads "Denied" (and the…
