first time poster here.
I am trying to import Google Form responses into a Google Sheet tracker. Given the Google Form inserts a new row for each response, I need to use Array formulas. However, I am having trouble adapting the following formulas to be arrays:
1. Last non-blank cell in a range (subset of a row, based on an if statement Current attempt works on the first row, but does not create an array:
=arrayformula(INDEX('Inbound Request Forms'!F2:K2,MATCH(TRUE,INDEX(('Inbound Request Forms'!F2:K2<>0),0),0)))
2. First non-blank cell in a range (subset of a row), based on an if statement Current attempt:
=arrayformula(if(E74="Product category change",ArrayFormula(LOOKUP(2,1/('Inbound Request Forms'!A2:2>0),'Inbound Request Forms'!A2:2)),""))
Here is an example doc I made, feel free to edit.
Thank you!