I’m using O365 Excel via SharePoint.
I have a formula that’s correct in my spreadsheet and performs as intended, but when I attempt to sync any changes I get an error.
I’ve regenerated the column several times to make sure it’s picking up the formula correctly.
Maybe I’m missing something here but it keeps showing a #ref for one of the column references.
The formula is consistent for the entire column.
My Excel Formula:
=IF(K2=TRUE,VLOOKUP(L2,E:CI,83,FALSE),IF(OR(AC2>=N2,CH2=“TRUE”,CH2=TRUE),TRUE,FALSE))
My Spreadsheet formula in AppSheet:
IF(RC[-76]=TRUE,VLOOKUP(RC[-75],C[-82]:C,83,FALSE),IF(OR(RC[-58]>=RC[-73],RC[-1]=“TRUE”,RC[-1]=TRUE),TRUE,FALSE))
The formula in the error message:
=IF(1200=TRUE,VLOOKUP(1200,:A,83,FALSE),IF(OR(1200>=1200,#REF!1200=“TRUE”,#REF!1200=TRUE),TRUE,FALSE))
Thank you,
Kyle
LinkedIn
Twitter
