-
Formula for "Days since" event
Hi There, I'm looking for some help with a formula for a sheet summary field. I'd like the field to display the number of days since "today" that a checkbox was checked, based off the date entered in that checkbox's row. Example based off screenshot: "Today" is 12/4/2023. If the checkbox for Row 66 is checked the "Days…
-
Hi, i am trying to multiply number in column "Lineal Meters" by 3.2. What is the formula please?
-
Countif This Month, Next Month, Following Month
Heyo, I am trying to redo a formula to auto update with the information that I am currently pulling monthly for a dashboard. I am trying to sum the total fee installed if scheduled to complete this month, next month, and the following month. Here are the formulas I am using: This Month: =SUMIF({ECD}, IF(ISDATE(@cell),…
-
=IF(CONTAINS 2 Red Harvey balls they status changes to "red".
Hello! It's me again, Is it possible to have a formula that the Harvey Ball in "Overall Status" changes depending on the other 4 rows? IF I have 4 Green Harvey Balls the "Overall Status" is GREEN IF I have 3 Green Harvey Balls the "Overall Status" is YELLOW IF I have 2 Green Harvey Balls the "Overall Status" is RED I have…
-
Formula Range no longer working
Hello - We have a report that is built to feed a dashboard. It has worked fine for close to a year. Today I logged in to complete our weekly report email, and all of my forumulas are showing the #INVALID REF error. When looking at the formula, the 'range' is still there, but it is no longer actually working, it does not…
-
Count on condition between two dates
I have been racking my brain on how to write this formula - for some reason, it did not count anything What I am trying to do is: Count "Complete" between two dates. The formula goes: =COUNTIFS([Actual Start Date]:[Actual Start Date], ">=12/26/2022", [Actual End Date]:[Actual End Date], "<=05/26/2023", Status:Status,…
-
Displaying Multiple Quarters based on Start and End Date
Hi - I would like to request assistance with developing an equation. The equation needs to display one or many Quarters based on the 'Start' and 'End' date of a task. Many of the equations I have tried display the quarter in which the events starts. However, I would like the equation to support the following: If an event…
-
SUMIF Budget when priority does not equal x
I've tried to review this older post (among others) to see if I could figure out why my formula was not working. But was unable to sort out why. Trying to SUM a budget column if the Priority column does NOT equal "N/O" =SUMIF([Priority]:[Priority] <> "N/O"), [Budget]:[Budget]) =SUMIF([Budget]:[Budget], Priority:Priority <>…
-
IF, AND, OR Functions
So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…
-
SUMIF Help
I am trying to write a formula to add up a range of cells but only add up the first and the last of the cells that show a numerical value. So in the 3rd row it would add the 21 in the Monday and the 21 in the Wednesday column , in the 8th row it would add the 18 in the Tuesday column and the 18 in the Wednesday column, in…
