-
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…
-
Locking Cell - with Conditions
Is there any way to lock/restrict a cell that asks users to choose a date? For example, I want users to be able to choose a date earlier than what is "listed" in the cell but be unable to choose a date after the date that is listed. If the cell reads 9/1/2019, the user should be able to change the date to 8/30/19 but NOT…
-
Sorting and conserving formula
When I sort rows, the formulas are not maintained: = SUMIF($[column_A]$7:$[column_A]237, "Received", [Column_B]$7:[Column_B]237)) gets transformed into this: = SUMIF($[column_A]$57:$[column_A]237, "Received", [Column_B]$57:[Column_B]237)) the $ has no effect. and I cannot use the [column_A]:[column_A] syntax as it will…
-
Sumifs Date Range w Cross sheet formulas
Im close on a sumifs formula, but for some reason i cant quite get it. trying to count installations on a give date from a given list of properties Here's what i have. it's returning a unparceable response =SUMIFS({7900 Park Central Install QTY}:{7900 Park Central Install QTY}, {7900 Park Central Install Date}:{7900 Park…
-
Sum of Children - not working
Hello All, I'm trying to get the sum of children. There are 4 children rows, with multiple rows beneath that. See image. In this case, the top row with cell value 0 would have a 2 because it's summing the purple 0 and purple 2. Purple 0 and Purple 2 are counting the cells below (children) that have checkboxes. I'm using…
-
Using CHILDREN(cell address) as a range in SUMIFS
I am trying to find the total of Task Total Hours only for rows with a tier level of 2 and where % complete = 1. I am writing this in a summary cell in a mini-dashboard that requires me to write the formula in the % Complete column. I am trying to use CHILDREN(cell address) as a range. What I have read leads me to believe…
