-
Conditional Formatting
Hi - Trying to replicate this Excel Conditional format that runs based on a calculation off another column... So if Column A is less than 95% of Column B...light up Column A... Any guidance is appreciated...
-
Need row to turn yellow if date received is at least 2 days in the past
I need a way to turn a row yellow if the date received is at least two days in the past AND status is "bid complete", also turn red if date received is at least three days in the past and status is "bid complete". I would prefer if there was a way to do 48 hours and 72 hours but if not, days will work. I could not figure…
-
formula to populate due dates
basically I want my due date to be based of off the status below: Bar layout needed – 2 days Concept – 5 days Design changes – 3 days Assembly reviews – 1 day Concept – 5 days so I was trying something like this: =IF([Status] = “Bar Layout Needed”, =TODAY()+2 workday I am just trying to get one of them to work first then i…
-
Average Formula
If I am wanting to find the average of wage rates that are referenced on another sheet, how would I create that formula? I have tried several different things and nothing appears to be working.
-
referencing another sheet I need all clients in the client column, I need All Clients
My formula is as follows for 1 client: AFR =COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets Range 2}, "S2 - Urgent", {LPSC tickets Range 3}, "AFR") There are 10 different clients in {LPSC tickets Range 3} - these clients are used various times throughout the data. Question: How do I find out the number of…
-
What am I missing....
Some Background: I have been running these sheets for over 6 months and the formulas have never been a problem. It is a SUMIFS where the criterion is being searched for in a different sheet. I added a new column and wanted to do the same formula but searching in a different sheet. Column "Funds Spent MASTER DUMP" is…
-
My Count If formula doesn't work with a < in the field i need to count
I want to count the number of rows which have the <50sqm in the Implementation stage column, i don't get an error with the below formula but this also doesn't give me the correct number, it just returns a 0. =COUNTIFS([IMPLEMENTATION STAGE]:[IMPLEMENTATION STAGE], "<50sqm", [BUILD START DATE]:[BUILD START DATE],…
-
Form Submission Start of Shift
I have a form for the start of shift for operators. Safety inspection, 3s inspection, and other things they are supposed to do prior to starting their shift. For the location that I am attempting to implement this solution, we are running a 3 shift model.6am-2pm 2pm-10pm 10pm-6am I want to show a RYG for each shift if they…
-
Simple IF function not working
Hello, I have an issue with a simple IF formula. Here's the formula: =IF(Completion1 = "100%", "Closed", "Open") for Overall Progress Column. It's not working. Even if the value is NOT equals to "100%", the value showing is the false one (Open). I don't know why it's not working. A note: The logical expression (Completion…
-
Sum of multi select dropdown items with assigned values
I have a column (Design Software) formatted as Dropdown (multi select). The dropdown values are names of software products. I want to give a value to each software reflecting the respective cost (e.g., Adobe Substance = 3000, Browzwear vStitcher = 19000, etc.). I added the formula below in another column (Software Cost) to…