Formula results depends on links not value


I have a strange issue. My formula (nested conditionals based on fields you can see in the image) provides different results for the same values!

It turned out that the reason lies in the ID Roadmap link field. The first record has only one linked record while the second one has two - one of which is has empty values. When I delete that link, the Result formula changes to “ID excl from denominator”.

However, I’m not able to delete those links one by one (it’s a long story).

The question is: how do I create a formula that will be based only on values I can see?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.