Set Formula Column to Inform Dropdown Column

Laurin
Laurin ✭✭
edited 06/06/23 in Formulas and Functions

Hey, gang! I'm trying to find a way to make a Formula column inform a Dropdown column.

I know formulas can't be used in Dropdowns, so I've created both columns within a sheet. Now I'm just hoping there's a way to automate the dropdown selection based on the formula query beside it.

This is all designed so that the company's owner has a quick Card View of what the team's doing This Week, Next Week, and In Three Weeks.

Currently, I manually update the To Do (dropdown). Is there a way to automate this? Thanks so much!

Answers

  • Eric Law
    Eric Law ✭✭✭✭✭✭

    Hello @Laurin can you give a little more context of how you want it to work?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 06/06/23

    Hi @Laurin

    I hope you're well and safe!

    You could use Workflows combined with the change a cell Action to change the values automatically without any formulas.

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    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.

  • Laurin
    Laurin ✭✭

    Thanks for the quick reply, @Eric Law !

    Ideally, whatever appears in the Do Formula column would automatically inform the selected item in the To Do dropdown. (Currently, I manually update it, but I'd prefer not to and have it done in real-time as dates shift.)

    Does that make sense? I realize this is kind of a weird ask. Just trying to solve for the inability to use formulas in dropdowns and dropdowns being required to populate Card View lanes. Thanks for your help!


    And @Andrée Starå thank you, but workflows don't seem to be working with the owner's single license instance of SS.

  • Eric Law
    Eric Law ✭✭✭✭✭✭

    Hello @Laurin

    All licenses should have automated workflow, except for the free version. Also, you SHOULD still be able to do formulas in dropdowns, if you are an admin or owner of the sheet.

  • Laurin
    Laurin ✭✭

    Interesting - while I'm helping him with this project, I'm logging in with his licensed account (so he's the owner/admin of the sheet.) I don't see a way to apply the formula to the dropdown, but will try exploring workflows again.Last time I tried it said I needed to upgrade the account. Thanks for the info and guidance, guys!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!