Auto Changing Drop down list

Alex Klingbeil

is there a Formula that would Make a Drop down list of items change to the right info if x amount of checkbox are clicked?

looking for something like this in the drop down list "locked"

Ready to Order
Pre Fab
Ready to Ship
Site Lay Down Area
Staged in Work Area
Being Installed
Complete

and check boxes for Staff to click.

Review done is a checkbox and that would trigger "ready to order"

then when Review and Order Material are click( 2 different check box) and that would Trigger "Pre Fab"

when Review,Order Material, and PreFabComplete are all checked it would trigger "Ready to Ship"

so on with Flow of tasks. that way people never have to move the drop down list to the task it should be on so i know who has the next task.

Paul Newcome

You would us a nested IF formula. There are a ton of examples of those here in the Community already. Feel free to browse around looking for examples to help you get started. If you get something together but still run into some roadblocks, feel free to post what you have thus far, what it is doing, and what it is supposed to be doing (lots of details), and we should be able to help you tweak things to work for you.

kowal

Hi Alex,

Unfortunately there is no formula that can update the dropdown list.

I think the only way to achieve that is to work with Bridge.

Paul Newcome

@kowal I initially thought it was changing the dropdown column properties and was going to say the same thing, but reading more, it seems like they want to simply adjust the output on a row by row case based on other actions (boxes being checked) within the row. That's why I suggested the nested IF.

kowal

hi @Alex Klingbeil and @Paul Newcome my mistake, I jumped into conclusion too fast.

Alex Klingbeil

@Paul Newcome

i have tried a few Nested If's not sure if i am doing them right. so i have many check box's that are with Reports people are using and not looking at this large Splash sheet i have for info. i am looking to make the Drop down list change with when someone Clicks there box saying there part of the task is done.

when Foreman Review is needed is clicked i want the Status to Say "Review Stage".

when the Foreman Review Box completed is checked and Foreman Review needed is check i would like it Say "Detailing Stage"

when Detailing Complete and the Foreman reviews are both complete i would like it to say "Ready to Order"

so on with the task. but i am having trouble making it work. when i think i have it. it only says the when the Foreman Review is check and wont change to the next one.

Paul Newcome

Try working your nested IFs backwards from the last step to the first step.

=IF([Last Box]@row = 1, "Complete", IF([2nd to Last Box]@row = 1, "Last Step", IF([3rd to Last Box]@row = 1, "2nd to Last Step", ……………………………..