Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula results depends on links not value

Topic Labels: Formulas
192 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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