Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Can you do if this then that for auto entry from drop down list
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
-
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
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives