Single Unit Drop Down
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
It depends on your setup and how users are changing the values. Can you provide more detail into your setup and process?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome Thank you! go figure it was something so simple.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!