How to resolve the error in flow formulas for conditions?

Question

We are migrating workflow rules to flows. Formulas for Conditions is used because of cross-object references (not shown in image below).

Now I also need to include in that formula a reference to the formula(text) field to check if the result is blank. Now the problem is that if the formula in the formula field contains a reference to a lookup, the "error in referenced formula" happens. The interesting thing is that if ISBLANK is replaced by ISNULL, the formula becomes valid, but of course ISNULL is not the correct solution.

The image below is a simplified reproduction of the error: the Formula_1__c contains a lookup Link_1__c.

Is there a workaround for this, aside from copying the whole formula in Formula_1__c inside the Formulas for Conditions (which is what we did for now)? If this is a bug, where can I report this?

Dipesh Bhardwaj · Accepted Answer

It's possible that what you're seeing as flow formulas for conditions is a bug, so I'd submit a case to follow to validate whether or not what you're trying to do is supported. I would also consider moving the logic of what is in the formula to the condition formula itself. This may or may not be possible depending on what else the formula field is referencing besides the lookup, but entry condition formulas do support traversing up the lookup chain directly. I see in the comments that this is after-save, but for the sake of those reading along, I'd also like to point out that if this was a before-save Flow, I'd really avoid using a formula field since those won't be calculated yet at the time of entry condition evaluation.

Katarina8 · Answer

If you're looking for a casual game for entertainment, Drift Boss is a solid choice. It isn't overly complex, yet it offers great replayability without getting boring.

Alexanderduen · Answer

It sounds like you're encountering a frustrating issue with the migration from workflow rules to flows, especially with cross-object references in formulas. While copying the entire formula into the Conditions might be a temporary fix, it's not ideal. Have you considered checking if there are any updates or patches related to this issue? On a lighter note, I recently enjoyed playing some geoguessr unlimited, which helped me unwind while tackling similar challenges.

Oliviaparkerr · Answer

I want to express my utmost admiration for the author's ability to Smash Karts maintain a consistent level of quality and depth throughout this lengthy article, showcasing their expertise and unwavering passion for the subject matter.

Tamna Iyana · Answer

This is because Salesforce does not presently support formulas in entry criteria that use formula fields that involve traversals. For the time being, using the formula rather than referring to it is the workaround. Regarding scratch games online flow, it is after-saved due to an email alert, but since the issue is with the conditional formulae, I don't think that matters in this case.

How to resolve the error in flow formulas for conditions?

About this question

Your answer

5 Answers

More Salesforce discussions

Learn & Explore

Salesforce Tutorials

Salesforce Interview Q&A

Latest Salesforce Blogs

Want answers to more Salesforce questions?

Stay in the loop — it’s free

You’re on the list!