Fill in project number based on ancestor level
I want to auto fill the project_number between the the Purple and Red rows. So all the children of Purple Project have a Project_Number = 4 and all the Red Children have a Project_number of 7
Tried using something like this. So if the Project is checked return the Project_Number. This give me "UNPARSABLE"
Tried to use ANCESTOR.
Help Article Resources
Check out the Formula Handbook template!