How t set a default value to Symbol column

Hello!

I have a symbol column with 3 options representing payment status, (Yes, No, Hold).

By default it should be "Hold" until the user choses if the payment was accepted or rejected, so what I would like is that whenever a new row is filled, the symbol cell should be set to "Hold" by default. I know formulas don't work with dropdown lists, but I don't know if there's an option to set it to Hold by default without a formula.

Thank you in advance

Tags:

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Adam,

    How are the rows added to the sheet?

    Have a fantastic week!

    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: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi Andrée

    the rows are added manually in smartsheet

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Ok.

    Do they have to be added manually in the sheet?

    It could be solved with a form, and it could also be solved if the adjacent rows have the correct structure.

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    I agree with Andree. You can provide hidden default settings with a form, so if your user would populate the sheet with a form, that would allow you to set the default value of the field.