Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using a dropdown list value as default for new rows
I'm creating a new task sheet.
One of the columns uses Dropdown List to set the value for that field. Most of the rows I add are going to use the first value on the dropdown list.
How can I set that value to be the "default" value for that field, so that it automatically displays, saving me from having to set it myself every time?
Comments
-
Dear Troy,
You may put an IF() formula in the column with dropdown list to get the default value when something is entered in another column. If you change its value later to sg else (from the dropdown list), you can, but the formula will be deleted of course.
I've just tried this: =IF([Column1]1 <> "", "default", "")
Hope it helps.
Atus
-
Another option is to add this formula to each row:
="default"
As long as that formula exists in the two rows above or below a newly added row, this formula will be added to the new row.
When a new value is selected in this cell, the formula will be deleted.
-
Hi Troy,
Another option is to use a "web form" for the adding of the data,In the form you can set a default value for any field, and have the for redisplay for the next input.
-
I am trying the suggestions above but every time I add a new row, the formula doesn't copy into the new cell (this negating the "default" for new rows). Any thoughts? I have the formula in the 2 wors above and below as suggested above.
-
Agreed - I'd like to be able to have my task sheet act as a table does in Excel. I'm looking to do as little work as possible after I've set it up, therefore if I add in a new Task Name I'd like to be able to set default values for specific fields ie - Status = "Not Started", Request Date = Today() etc...
Currently the only solution I see (and it works but will require updating later on) is to drag the formulas down to the bottom of my current task list (Row 50). When I eventually log more than 50 tasks I'll need to continue to drag the formulas down.
I'm hoping that there's someone who can provide a better solution than what I've proposed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives