Hi, I am trying to create a count of the number of linked items in a connected board but also set the default value to 1 if there are no linked items. I am using the formula below but I am still getting 0 in the output if there are no linked items, am I missing something simple?
IF(({LG Epics#Count})<>“”,{LG Epics#Count},1)
I used “” as the formula prompt says the count function default value is “” so I assumed that it would be the result if there are no linked items found.
Hi Andrew,
You are close but in fact, when no items are linked the Count is actually 0, not an empty string. But since the 0 is not a number but text (I know computers can make things complicated), you should adapt your formula to the following:
IF(({LG Epics#Count})=“0”,1,{LG Epics#Count})
See my example below, here I’ve used the following formula:
IF({Child#Count}="0",1,{Child#Count})
Hope this helps!
Best,
Maarten
Thanks Maarten.
Thats really good to know about 0 not being treated as a number, might explain other odd behaviour I have come across. In the meantime I had resorted to using a Max function that did the job.
