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.

Help with Children Function

Bill Brandt
Bill Brandt ✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

I am using =COUNTIF(CHILDREN(), "") + " Missing Data" which works fine. I am trying to modify this to only show a value if there is missing data otherwise be blank. I have tried numerous iterations of the IF command and always end up with "Unparsable". Any suggestions?

 

Thanks

Tags:

Comments

This discussion has been closed.