Uncheck the previous checkbox when a new box is checked

Mellba

Hello

How do I get rid of a previous check when a new checkbox is selected?

 

This is what really need to happen: (Task Name 6 needs to transition from one to another (Idea, Concept, Design, Validation, Lanuch) as the approvals are sent out.

            When project starts it is automatically in the Idea Phase

            When Idea Phase Gate Approval is sent-out – It then changes to Concept Phase

            When Concept Phase Gate Approval is sent-out – It then changes to Design Phase

            When Design Phase Gate Approval is sent-out – It then changes to Validation Phase

            When Validation Phase Gate Approval is sent-out – It then changes to Launch Phase

I have attached a screen shot for review.

Thank you.

 

p_bureau

Hello,

 

a formula won't do what your are looking for! This is because you want something to trigger when a change occurs (not from the value itself).

 

Maybe what you are looking for is Kanban management?

 

Paul.