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

edited 12/09/19 in Archived 2017 Posts



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.





Screen Shot 2017-04-19 at 18.17.39.png



This discussion has been closed.