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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!