Help

Formula to automate "master project status" based on "project status"

232 1
cancel
Showing results for 
Search instead for 
Did you mean: 
SharonC
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1

"project status" is what? A lookup field? Can you give some more context?