Trending in Formulas and Functions
-
Help creating formula to update inventory automatically
The following is our brochure requests sheet. Right now we manually update our inventory each time we receive a request. Here is a snapshot of the new inventory sheet. I'd like to create a formula that automatically subtracts 100 from Spanish Qty each time the Request Completed is checked, the Request Denied column is…
-
If Function - Nested - Negative Percentage - Symbols
I have a formula that is driving me insane. I am trying to get symbols to change color based on the % to Plan column (see screenshot). If the % is positive, I want the On Track Column to show Green. If it is negative BUT greater than -25%, I would like to show Yellow and all others to show Red. The problem is I am getting…
-
If Date is blank + past formula
I can't figure out why this would return a "yes" when the date cell is blank. =IF([Date of Site Survey (Product)]@row = " ", " ", IF(TODAY() > [Date of Site Survey (Product)]@row, "yes", " ")) Intended logic/result - If date cell is blank, then "blank" (this worked when I tried without the 2nd argument added) If date is in…