Google Sheets Formulas
Posted: Fri Jul 15, 2022 5:07 pm
I have a few rather complex formulas I would like to use with google sheets connector app but I can't quite seem to get the <<rowNumber>> to work in this particular formula. I have used <<rowNumber>> in other more simple formulas but there's something about this one.
In the 2nd example we are getting the sum from said sheet in column c where A<rowNumber> matches column F in said sheet. Again wanting to reference the current contents in cell A<rowNumber> to search the other sheet and not a specifc cell
Any insight as to why this isn't working or how this might work would be appreciated.
- Expense Code::=INDEX('MMFulfillment Billing [Switch.Date:Format="yyyy-MM-dd",TimeZone="UTC"]'!$F$2:$F$9000,MATCH(0,COUNTIF($A$1:A1,'MMFulfillment Billing [Switch.Date:Format="yyyy-MM-dd",TimeZone="UTC"]'!$F$2:$F$9000), 0))::formula
- Shipping::=SUMIF('MMFulfillment Billing [Switch.Date:Format="yyyy-MM-dd",TimeZone="UTC"]'!$F:$F,$A<<rowNumber>>,'MMFulfillment Billing [Switch.Date:Format="yyyy-MM-dd",TimeZone="UTC"]'!$C:$C)::formula
In the 2nd example we are getting the sum from said sheet in column c where A<rowNumber> matches column F in said sheet. Again wanting to reference the current contents in cell A<rowNumber> to search the other sheet and not a specifc cell
Any insight as to why this isn't working or how this might work would be appreciated.