Formulas

I am trying to follow the instructions on the SUMIF formula page. I created a sheet with only the "Sold Date" and the "Transaction Total" columns, entered some data, and I copied the formula "=SUMIF([Sold Date]1:[Sold Date]3, MONTH(@cell) = 2, [Transaction Total]1:[Transaction Total]3)" and pasted into a Summary Sheet…

Help!!! I'm trying to create a formula that counts a row if a column "A" value =X AND column B check box is checked. I have tried the following and it does not work. Any suggestions? =COUNTIF(Status:Status, OR(@cell = "Partially Invoiced", @cell = "Cancelled", @cell = "Contract Requested", @cell = "Contract with Client for…

Hi everyone, I have a formula in my sheet that is not showing up on my report. It's a simple formula; how many days late something is, and I really need that info displayed in the report. Ideas, tips or tricks? Thanks! Ashley

Hello All: I'm working on a product development sheet and we have products going live in different months, I created a column that has a drop-down for each month where I select the right month on the product row. The question I want to easily sum how many products we have lined up by month. What would be the easiest way to…

Hello, I created a sales projection vs actual sheet for 2021, I would like to use a formula with symbols to automatically change based on percentage. So if it's at 25% one, 50% one, 75% another, and by 100% show green, based on my column names, what would be the best setup for the formula? I greatly appreciate your help.

I am trying to "score" rows using Impact vs Effort columns. I know I can do this using a complicated nested IF statement. In google sheets, I can more easily use VLookup or Choose like this: =VLOOKUP(M4,{"Low",1;"Medium",2;"High",2},2,FALSE) / VLOOKUP(N4,{"Low",1;"Medium",2;"High",2},2,FALSE) or…

Struggling newbie here! For the life of me, I can not figure this out. I am trying to find the spend of each firm, and qualify it by the year so that once 2021 rolls around, I can track spend-by-year. I know the end of my formula below is wrong, but I cannot figure out how to qualify by formula by year. I've mastered the…

I have a column called Building Turnover and Scheduled - Days Out. Schedule days out takes turnover - today to get a number. I want to see the value and if the value is <30, I want to add 15, if it is I want to add 30. I want all of that in another column Can you help? =IF(OR([Scheduled - Days Out]@row1< 30, [Building…

Hello, I am using Data uploader to import data from an excel sheet. It is critical that we pull in the date and time from the sheet. However, the time is not being pulled in - only the date. So i went to the source excel sheet and extracted the into a separate column. I used the =TIME(HOUR(G2),MINUTE(G2),SECOND(G2)) and…

Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…