How to write a formula where the "parent" and "regular" rows =0, but children rows = 1?
I am creating a new "helper column" where I'd like to have the parent rows and the "regular" rows= 0, but children rows = 1?
Best Answer
-
You should be able to get there using
= COUNT(ANCESTORS(insert your column@row here))
That should return 0 for all top level parent rows & rows without any children but the children rows should result in 1. (If you indent more than one level the middle will be 1 and the most inner/indented will be 2 and so on…Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
Answers
-
You should be able to get there using
= COUNT(ANCESTORS(insert your column@row here))
That should return 0 for all top level parent rows & rows without any children but the children rows should result in 1. (If you indent more than one level the middle will be 1 and the most inner/indented will be 2 and so on…Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
-
This worked like a dream- thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives