-
How to add time or subtract time from a date when "check" is selected?
Hi! Looking to see if this is possible. I have a packaging release date column that current pulls from another sheet for all items. I have items for Disney that I need to subtract 30 days when I click Disney checkbox column. When I uncheck the checkbox column, I want the date to revert back or add 30 days back. Here is the…
-
Review a Formula
I am trying to sum all noted columns and getting UNPARSEABLE. Help! =SUM([A. Need for the Project/ Project Narrative]@row, [A. IPVE Need for the Project/ Project Narrative:]@row, [BONUS]@row, [B. Demonstration of Experience and Proposed Servic]@row, [B. IPVE Demonstration of Experience and Proposed]@row, [C. Demonstration…
-
Formula Issue
I want to get a dollar amount based on if a checkbox is selected. I am running a program where participants can get gift cards as incentives. I am using a separate sheet for the amount for each incentive. The other sheet columns are named the same as the incentive. Each column is a checkbox. To explain what I want, let me…
-
Add Or Condition to my formula
Hi. How do I adjust my column formula to include Status <> Complete or <> Phase 2? My formula is: =IF(AND(Finish@row < TODAY(), Status@row <> "Complete", Health@row <> ""), "Yes", "")
-
Nested IF / AND Statements
I'm trying to put together formulas that will allow me to report forecasted labor across the months a project is active. I have all the formulas working individually but can't figure out how to group them into a singular formula. For example: Project Start: 6/17/24 Project End: 8/21/24 Forecast Cost: $10,000 The way I…
-
How can I exclude "child rows" when executing VLOOKUP?
I am currently trying to update the VLOOKUP formula to exclude child rows. I setup a reference sheet to run the formula, but the only way for it to run properly is to add the child rows. If any child row value is changed, it shows as #NO MATCH, however, I would just like to appear blank. I am currently running the current…
-
How to Step Rounding Percentage
Below is a very basic formula actual/workset a to get the %achieved. You can see that the two calculations are off one should be 33%, the other 20% What is the best way to show the actual value, not the rounded value? Thanks!
-
Index Collect and Multiple Output Values
Hi All, I have multiple things going on and am hoping I can find one formula to clean things up for my team. Basically, I have the below list as a helper sheet. Then, i have a form that our customers can complete. They can select from the list that is on the left of the example below and they can select multiple options…
-
VLOOKUP with concatenate
My project has a "master project" sheet and then dozens of individual project sheets. On the mast project spreadsheet, people will enter 3 letter customer mnemonics [Organization] and select from a drop down list in [Project}. The drop down list could be a single or multiple from that list. The primary column is a…
-
Pulling just the date from a cell
Hi! I think my question is pretty simple. On a sheet, I have two columns. One is "Primary", and it's blank. The other is "Created" - a date/time column that auto-populates from a form. I want the primary cell to only pull the date from the Created column. I've tried a few different formulas with no luck. Anyone have any…
