nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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?

Comments

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.