Hey again everyone and anyone.
I am trying to come up with a little automation for my sheet and this is essentially what I am trying to do.
I have a drop down to select a certain status (More Info Needed, Scheduled, Testing, Completed). Essentially what I want to do is I want to be able to select a status and have it automatically put a value in for an overall status percentage. So More Info Needed would be 25%, Scheduled would be 50%, Testing would be 75% and Completed would be 100%.
I managed to do this and get it for the 100% =IF([@[Dev Status]]="Completed",1,0) . I also tried adding some and statements in there and that is where the wheels came off.
Any help would be appreciated.
I am trying to come up with a little automation for my sheet and this is essentially what I am trying to do.
I have a drop down to select a certain status (More Info Needed, Scheduled, Testing, Completed). Essentially what I want to do is I want to be able to select a status and have it automatically put a value in for an overall status percentage. So More Info Needed would be 25%, Scheduled would be 50%, Testing would be 75% and Completed would be 100%.
I managed to do this and get it for the 100% =IF([@[Dev Status]]="Completed",1,0) . I also tried adding some and statements in there and that is where the wheels came off.
Any help would be appreciated.