Really simple If statement - value if true doesnt work if value if false is ""
Hi I have a relatively straightforward if statement and it works, but not always.
This is my formula and it works,
=IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), "nope")
however if I replace "nope" with other types of values, the whole thing stops working, including the value if true ..
e.g. =IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), "") returns blank whether true or false
And =IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), Responsible@row) returns blank when true, works when false
Best Answer
-
Hi @Jacinta
That seems to be a bug. Have you made a ticket already?
Answers
-
Hi @Jacinta
That seems to be a bug. Have you made a ticket already?
-
I have now lodged a bug ticket and I have found a workaround - by creating a column to do the hierarchy count and then running the if statement on that column. very weird.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!