How t set a default value to Symbol column

AdamK · 04/09/19

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

Andrée Starå · 04/09/19

Hi Adam,

How are the rows added to the sheet?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

AdamK · 04/09/19

Hi Andrée

the rows are added manually in smartsheet

Andrée Starå · 04/09/19

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

Mike Wilday · 04/09/19

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.

How t set a default value to Symbol column

Comments

Help Article Resources

Categories