Can you do if this then that for auto entry from drop down list

Steve Powers

I want a column to chnge its value from a drop down list when a criteria is met.  What I am after is a column that is titled "ready for invoice" and is a check box.  I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the account currently.  What I want is for it to auto pick "Accounting" from the list in that "currently assigned to" column when the tick box  in ready for invoice column is checked.   Is this possible?  I cant find anything like this in the commands or formulas (I dont fully understand the formulas however) or in conditional formatting which is where I expect it to be located.  I can turn the box in that column (or any in the row) to a certain color etc but not get it to pick an entry for me when this other box is ticked.  Any advise?

Shaine Greenwood

Hi Steve,

 

If the "currently assigned to" column is a Contact type column, there currently isn't a way to create this automation–as formulas can't be placed in Contact columns.

 

Otherwise, if it's a Text/Number column, you might be able to create an IF statement to automate this:

 

=IF([Ready for Invoice]1 = 1, "Accounting")

 

Check out our Help Center articles to understand more about formulas in Smartsheet: 

 

Create and Edit Formulas (basics): https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet

 

Functions list: https://help.smartsheet.com/articles/775363-using-formulas

 

Andrée Starå

Hi Steve,

You can use formulas in contact columns now.

https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting