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

Find more posts tagged with

Sales

Formulas

Comments

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

AdamK

Hi Andrée

the rows are added manually in smartsheet

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

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…