Single Unit Drop Down
![Seamas Finnerty](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I have several single unit drop down lists, yes or no, etc. Is there a way that SmartSheet will automatically display a chosen unit?
Such as, a column will always appear as no unless changed to yes?
Thanks
Best Answer
-
You can set default values in the form builder for each field.
Answers
-
It depends on your setup and how users are changing the values. Can you provide more detail into your setup and process?
-
The general idea is that some requests will require an extension. The extension column is yes or no. Right now the column appears blank unless someone changes it to yes or no. We would like it to automatically appear as no with the option to change it to yes.
We also have a date received and a due date column. The due date column is automatically updated based on the date received column. If "yes" is chosen under extension taken the due date column is automatically extended an extra X days.
Hopefully that gives enough detail.
-
How are users entering data? Are they submitting a form or are they manually entering data? How do new rows get added? Do you include hierarchy in your sheet?
-
We have a shared form open to public. As individuals submit the form a new row will automatically be added to the top of our sheet. Formulas are automatically updated as well so everything always auto calculates as a new row is added.
No hierarchy in our sheet.
-
You can set default values in the form builder for each field.
-
@Paul Newcome Thank you! go figure it was something so simple.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!