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

Options
Emma
Emma
edited 12/09/19 in Archived 2017 Posts

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

 

Screen Shot 2017-04-19 at 18.17.39.png

Tags:

Comments

This discussion has been closed.