-
HELP! How do I modify my formula to separate months and years?
I am separating "Total Monthly Sales," but I need to separate the years as well. For example, our projects were sold in 2021, but carried over into 2022. I need to be able to separate 2022 and 2021. Here is my formula: =SUMIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1, [Contract Amount]:[Contract Amount])
-
Pulling multiple information from one sheet to another
Hi everyone! I need to calculate some information based on several criteria. I have a sheet called Quality and in it, there is a lot of information. but the columns i need is; Date, Product type, Good quality and total quantity. In the product type collums we have 3 different products, but we only need 2 for this…
-
Rolling Monthly % Complete Formula
Hello, I cant figure out a formula for what I need and I need some help please! I am looking for a formula so the % complete will only show a value in the previous month(s) and the current month. For right now I would like November and onwards to show up as 0, but when it becomes November then I would like November to show…
-
Checkbox Formula Not Working
I am trying to write a formula that states If a value of a specific cell is equal to $0 then check a checkbox. I have written this formula and it is not working: =IF([Remaining Value by Customer]@row = "$0", 1, 0) The $0 in Remaining Value by Customer field has a formula in it to return the value so I am wondering if that…
-
Looking to count the number of times a string of specific text occurs in a column
I want to use a count formula to determine the number of times a SKU occurs in an open text column. Below is the formula for the highlighted cell: =COUNTIF(SKU:SKU, CONTAINS("SKU2", @cell)) The value I am looking for is 3 because SKU2 appears 2 times in the 3rd row and once in the 2nd row. Any insights on how to count…
-
Return multiple rows of results based on one row elsewhere
I'm trying to convert collected information on team's schedules in office into a calendar view to represent it. The data is collected as 1 row per week (checkmark if in the office of Week Start on X Monday). However, converting that into 1 row per day each Team is in the office (to be able to represent in the calendar…
-
Typing Minutes of meetings directly in dashbord
HI all We do our meeting with a dashboard a couple times a week. We have a chart that shows the development of all our current projects and products. Sometimes we need to write notes to the projects, (which we have a grid for in the project folder), but it would be great if it was possible to write notes directly into that…
-
SUMIFS only for negative number
Hello ! I have two columns to follow the progress of my team planning. One is for the reference end date, the one I set at the beginning and to which I must stick. And the second one is the adjusted end date, the one that is reviewed once a week to get closer to reality. I have a formula that counts the variance between…
-
Help with V-lookup
I have two sheets with the following 2 columns. column 1 - HRC code column 2 - status The HRC code will always match on both sheets but the status may be different. Sheet 1 will have the most current status but sheet 2 may have old information. I want the vlookup from sheet 2 to find the hrc code on sheet 1 and…
-
Cell reference - when original cell content is deleted, the referencing cell still shows value
I have two Sheets. In Sheet A I have my full content. I am displaying some cell content from Sheet A in my Sheet B. I created the referencing as a Column Formula, so that if I add another row to my Sheet A, it automatically displays in Sheet B. That works just find. What does not work is if I later on decide to delete a…
