Looking to auto select a value from a drop down when previous field has any value

Kristi Curry

Basically I have a contact list and when any contact is input I need to default the next field "status" to be "open - assigned". So as soon as someone is assigned to that item it is no longer the default of new-unassinged and changes over to open-assigned.

I have been trying all sorts of formulas with no luck. Help :)

Kelly Moore

Hello Kristi,

If I understand correctly, if your contact field is not blank you want your Status column to read "Open-Assigned".

This formula will go in your Status column. It says if the Contact column is not blank, the Status column should read 'open-assigned'. If that statement is false, the status will read 'New-unassigned'.

=If(Contact@row<>"", "Open-Assigned", "New-Unassigned")

You will need to change the Contact column name to whatever your actual column name

If you make this formula a column formula you may need to determine the other triggers that change the status of this column and nest additional IF statements into this formula. The community can assist if you get stuck with that.

I hope this helps

Kelly

Kelly Moore

Hello Kristi,

If I understand correctly, if your contact field is not blank you want your Status column to read "Open-Assigned".

This formula will go in your Status column. It says if the Contact column is not blank, the Status column should read 'open-assigned'. If that statement is false, the status will read 'New-unassigned'.

=If(Contact@row<>"", "Open-Assigned", "New-Unassigned")

You will need to change the Contact column name to whatever your actual column name

If you make this formula a column formula you may need to determine the other triggers that change the status of this column and nest additional IF statements into this formula. The community can assist if you get stuck with that.

I hope this helps

Kelly

Kristi Curry

This was perfect. Thank you so much!