Help

Formula results depends on links not value

Topic Labels: Formulas
486 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Romuald
4 - Data Explorer
4 - Data Explorer

hi!

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!
image

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?

0 Replies 0