Share
ReportI have a lookup formula that works, but it still is throwing up an error when trying to retrieve data from the network before it even finishes resolving the formula. I have IfBlankorError in the formula, and added an additional IfError to see if I can "head it off at the pass". Unfortunately it fires the error before it finishes looking at the formula, so even though everything in the app is working and fine my users still see the red banner every time. I have been banging my brain against this for days. I have formula-level error managment turned on. Even tried turning it off but that just showed the exact error which is that the lookup is returning a null value. It sees the null, throws the error, then sees the IfError and works fine. I just want to stop the error banner from triggering. I'm frustrated.
You’re offline. This is a read only version of the page.
All responses (
Answers (
18,256
