-
Want to add cells and return 1/2 if they don't equal a cell ERROR
=SUM(IF([Reel Stop]@row:[Quantity Scrapped]@row = [Reel Start]@row, 1, 2))
-
Summing previous months information
Hi everyone. I am trying to add up previous months information based on todays date. For example, if its March 10th, I only want to add January and February data. If its April only add January, February and March data. I have tried numerous SUMIFS formulas by using the MONTH(),-1 and TODAY() function but nothing works. Can…
-
month ()
i am trying to get the month from pulling the year and week. I have looked at a lot of post and it says the same formula. I have added it and it worked good for month 1 but get an "invalid value" for month 2 and on. can you let me know what i am doing wrong. =MONTH(DATE(Year@row, 1, Week@row * 7 - 2) -…
-
Moving rows automation with keeping layout of parent/children
I have been able to set up automation on my sheet to move rows to another sheet. It does add rows to the sheet but, it puts them at the bottom. I am looking to move the row in the particular parent-child grouping it exists in on the original sheet to the “closed/archived” sheet. I do have the sheets set up identical to one…
-
What is wrong with this formula?
I keep getting invalid value. Can someone assist? =INDEX(COLLECT({Last Name First1}, {Sector}, [Last Name, First Name]@row), 1)
-
COUNTIF Between Date Range
Hello, I am trying to see how many projects were completed in in 2021. I have several different dates and years within the column, but I'm looking for a count of all projects with a 2021 date. The below formula is what I'm using but I am getting #UNPARSEABLE. =COUNTIFS([NOC Recorded Date]:[NOC Recorded Date], >=DATE(2021,…
-
Sumifs Equations
I'm trying to do the same sumifs equation on my sheet to read the total amount of quotes sold per month but when I try to do multiple months it says "Circular Reference" , and in the other cell that I have the same equation but for a differed date selected range it says "blocked". The equation is down below =SUMIFS([Amount…
-
IF OR ISBLANK Help!
Good afternoon, I am trying to create a formula that searches 2 cells with a row, and if both are blank then it will return "Online", but if either one has a value in it then it will return that value. The two cells will never both have a value in at the same time, just one or the other. The cells are as follows:…
-
Count If Function
I would like to use the CountIF function to summarize information for a dashboard. I want to count the number of services by client. The column used for service type is mult-select because clients contract for more than one service. For example client 1 may use service A, B, C and client 2 uses B,C,D. I need the formula to…
-
How to Change Row Color based on Status change
Hello, I am trying to change the color of an entire row based on the status of 3 different columns but not sure how to use formula or conditional formatting Example: When Column X = Approved, then row color should be "Yellow" When Column Y =Approved, then row color should be "Blue" When Column Z = Approved, then row color…