Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Automated updates to Dropdown List

Users need a way to dynamically match / update a Dropdown list column based on an Inventory sheet, e.g. criteria from another column or sheet.

Use case 1: When an item is out of stock, on an inventory list, remove the item from the order sheet and user form.

Use case 2: When a project or task is listed as complete, remove the item from a dropdown list for possible updates or requests. This could also be helpful for items on a development release task list.

I thought that this was in the pipeline while attending Engage 22, but I haven't heard any updates when checking with the Call Center.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions