CHILDREN() and INDEX() Killing Me!
I need to pull the value from the 1st child row, 3rd column. If that value is == to "Hold", then the cell should return a value of "Hold".
I'm trying to follow the help guide as well as some community posts, but I'm not getting it. What is the proper syntax?
The goal is to have the parent row's "Current Status" cell show a green check if the "Action Type" cell of the 1st child row is set to "Release". Using if statements, then if the "Action Type" cell is "Hold", then the "Current Status" cell will also be set to "Hold". And if "Action Type" is "Purge", then "Current Status" will show "Hold". That's just so that I can get the Green/Yellow/Red colors.
Help Article Resources
Check out the Formula Handbook template!