I have a zap that is taking order information and moving it to excel sheets on google drive. I have created an IF statement so that if Column I = * then take the date from Column B and add * to the date;
It looks something like this: IF(I2=74072,(B2+30),IF(I2=74076,(B2+7),IF(I2=74053,(B2+1)……etc, etc
My issue is that it works on the first row (2), but when it moves to the next rows, it doesn’t change to I3 and stays as I2.
Any idea how to make excel sheets change it to relate to the row it is in?