Hey Lucidchart Team -
I have a formula in my document that looks like this..
=UPSTREAM(UPSTREAM).Sequence + 1
When not connected to anything upstream it produces the following result #ERROR
When not adding the "+1" I get an empty result.
=UPSTREAM(UPSTREAM).Sequence produces []
I would like to use this in an IF statement to test for the empty result so that I can avoid the #ERROR and default my sequence to 1.
=IF(UPSTREAM(UPSTREAM).Sequence = [] 1 UPSTREAM(UPSTREAM).Sequence + 1) produces #ERROR
I've created a document that illustrates it: https://www.lucidchart.com/invitations/accept/9ba2f524-f97a-46bb-b228-33f92d3547bc
Cheers
Michael