-
Updating Fields Based on Input
I have a form in which I let people enter in either a Monthly Budget or Total Budget. If it's Monthly, each Monthly Budget field obviously gets filled in with a value, but if it's a Total Budget, those Monthly Budget Fields are left Blank. Q: I know how to allocate the Budget for each month, but is there anyway to populate…
-
IF Function (related to dates)
Hi @ all, I have a formula issue where I would like to get your help. As you can see I have a delivery cell which I would like to link to my "Financial Year" cell based on the following condition: FY2020 = starting 01.01.2020 until 31.12.2020 FY2021 = starting 01.01.2021 until 31.12.2021 FY2022 =starting 01.01.2022 until…
-
Formula not working as in instructions.
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…
-
COUNTIF Checkbox Help!
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…
-
Do formulas not transfer over to reports?
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
-
Count how many formula questions
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…
-
How To Use Formulas with Symbols for Sales Sheet
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.
-
Simpler way to convert High/Medium/Low symbols to score - without using nested IFs?
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…
-
Trying to use SUMIFS function to count spend in 2020 by Firm
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…
-
Need help with a formula that is using data from 2 columns
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…