-
HELP with IF formula and cell reference
I would like to check cell [Actual Finish Date}4 for a date before executing =IF(ISBLANK([Planned Finish Date]4), 0, IF([Planned Finish Date]4 < TODAY(), 1, 0)) which sets a FLAG to true. If [Actual Finish Date}4 has a date then set FLAG to false. If there is no date then execute on the above formula.
-
Master Sheet - Exceeds Row Limit
I am struggling to figure out how to have a "master" listing of customers that can be referenced by various sheets via INDEX/MATCH cross sheet formulas when that list is too large. Here is my background: I have a master customer listing of 6200 customers. I use DataUploader to upload this into 3 sheets due to size…
-
Filter suddenly not working
Hi All, I have an issue of a filter not working that previously worked fine. The filter looks for cells in a column formatted for text/numbers. Here's an example of the data in the column: NLOND_3104-1 NLOND_3709-2 -2 -1 -2 NLOND_5612-1 The filter looks for data that contain -1 and another filter looks for data that…
-
Formulas for current month and previous month
Hello all (See attached screenshot of my sheet) I need some help. I have a budge/cashflow sheet. From this sheet I would like to create a Dashboard Role-up sheet that gives me the following: PREVIOUS month's budgeted income PREVIOUS month's budgeted losses PREVIOUS month's actual income PREVIOUS month's actual losses…
-
Capture date when row changes
Hi, I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed. ie: 1. When status column changes to "animating" - start date needs to capture the date(fixed value) it was changed to "animating" 2. When status column changes to…
-
AUTOMATE RYGB
Hello All, I am trying to automate the blue ball based on complete and the red, yellow and green based on date. I have come up with the following formula but I am getting an UNPARSE any help would be great. =If(Status1 =Complete, "Blue", IF(OR(ISBLANK([End Date]1), [End Date]1 >= Today(-5)), "Red", IF([End…
-
Remotely fill in a new row on another sheet.
Hello, I have two separate sheets that need to be connected. One is an inventory sheet of all raw materials in stock, and the other is a record of all raw materials delivered. If we receive a delivery of a type of raw material we already have some in stock of, the quantity of that material is simply updated in the…
-
LIttle Help With Formula
I have a helper column (checkbox) that fills the checkbox in if the "D/I" date is past 14 days...30...45, AND IF "install date" is blank. Here's the formula i have that seems to be working so far =IF([D/I]@row < TODAY(-14), IF(ISBLANK([Install Date]@row), 1, 0)) couple of ?'s... 1. If i fill in the D/I with a date, and…
-
Approval flow for credit notes
Hi all, I have set up the first draft for an approval flow to draw up credit notes. At the moment I have a flow set up as test that works very well for 1 condition - but I need to have a flow that includes 3 conditions: - credit note approval request between 1-50 euro goes to person A - credit note approval request between…
-
Autopopulating contacts using vlookup
Hi, I have a sheet with several formulas, including a =vlookup on a text cell and =Join (). All these formulae autopopulate when a new row is added manually of via a form submission. However, I also have a contact column which, while successfully pulling the contact information into the cell using a =vlookup function, is…
