Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
If all children are not blank then enter a phrase
Hi
I am having trouble writing a formula that will return the phrase "Completed" in a cell of a parent row if all the children are not blank. If there are some blank cells then it would return "Not Completed".
I am trying to get the word in the parent row in the column "Opera Analysis Code", if all the children have something entered in that column then I want it to enter "Completed".
I managed to get it working for other columns however those columns are either dropdown columns or checkbox columns, can't seem to work it out for text columns.
Any help would be appreciated.
Thanks,
Emma
Comments
-
I would give you a more thorough answer, but I'm heading to a meeting.
I think you want something like =IF(COUNTIF(CHILDREN(), ISBLANK(@cell))=0, "Completed", '')
Basically, if all children not blank then Completed.
-
Thanks Adam, I'll give that a try.
Emma
-
Hi Adam
I entered =IF(COUNTIF(CHILDREN(), ISBLANK(@cell))=0, "Completed", ''Not Completed") however got a #UNPARESABLE error unfortunately.
Have I entered anything wrong?
Thanks,
Emma
-
-
That works perfect, thanks Adam
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives