Checking a box sets a value in a dropdown list field

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Checking a box sets a value in a dropdown list field

h1pst3r88h1pst3r88
edited 12/09/19 in Using Smartsheet

Hi folks,

I have a sheet with a checkbox called "Qtly" and another dropdown field called "Lead Status" -- the values in the dropdown are: No Lead, Lead, Active Lead, and Deal. 

I am trying to figure out a formula for when the "Qtly" checkbox is checked, that the value in the "Lead Status" dropdown field automatically gets set to "Lead".

Thanks in advance!

 

Comments

  • L@123[email protected] ✭✭✭✭✭

    =if([email protected] = true, "Lead"

    =if([email protected] = 1,"Lead"

    =if(Qtly5 = 1, "Lead"

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    Try something like this. If you have a formula in the Lead cell like the one below you can't change the status manually because that will delete the formula.

    =IF([email protected] = 1; "Lead")

    The same version but with the below changes for your and others convenience.

    =IF([email protected] = 1, "Lead")

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Did it work?

    Hope that helps!

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Thanks, both; I will try later today.

    yes

     

    -Chris

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    Let us know how it goes!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.