Automatically populate a cell in a new row
I have a Smartsheet in which my team members add a row and fill in details to request time off. I'd like the Status column of any new row to automatically be set to Pending but I can't seem to find a way to do this. Any advice would be much appreciated, thanks!
Best Answer
-
Have you considered having your team members use a form instead of having them add rows directly to the sheet? When using a form you can set form fields to populate with a specific answer by choosing a default value and HIDING the field so the user can't see it. (See image below) This could create a really simple option for users to submit for time off
For more on forms see:
Example of hidden Field and Default Value
.
Answers
-
Have you considered having your team members use a form instead of having them add rows directly to the sheet? When using a form you can set form fields to populate with a specific answer by choosing a default value and HIDING the field so the user can't see it. (See image below) This could create a really simple option for users to submit for time off
For more on forms see:
Example of hidden Field and Default Value
.
-
Speedy and helpful advice, thank you!
-
You're welcome. Glad I could be of assistance.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!