Dear All
I am trying to automate "master project status" in the base, hopefully through creating a formula. "Master project" is a made of all small "projects". Logic as below:
- If all of "project status" is "concluded", then "master project status" is to reflect "concluded" automatically
- If all of "project status" is "planned", then "master project status" is to reflect "planned" automatically
- If all of "project status" is "onhold", then "master project status" is to reflect "onhold" automatically
- If one of the "project status" is "ongoing", then "master project status" is to reflect "ongoing" automatically
Thanks a lot!
