Single-Use Checkbox (or dropdown) - Can it be done?
Hi all! I looked in the forums and I didn't come upon any which matched this - but if you're aware of a similar thread, please link to it here!
We are looking to find a way to make a checkbox or dropdown option a single-use type thing. Basically - we track travel in a large sheet - and part of the information we collect from our travelers is where they are charging their travel back to, because we limit how many people can charge back to the project itself vs. their home division.
We use a form to collect travel log info - exclusively - only our core team has access to the actual sheet in SmartSheet. What we would like to do is put an item on the form that states something along the lines of "I will be the team member charging to the project for phase 1" and then have it be hidden or grayed-out for any subsequent form submissions, so that only the 1 person can choose that option for each project.
With my knowledge of SmartSheet I don't believe this to be possible - but I figured I'd put it out there to see if anyone else has been in a similar situation and what solutions they've found.
Thanks all - hopefully your new year is going well so far!
Comments
-
Hi,
Unfortunately, it's not possible at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
Possibly something could be set up with a third party tool like Zapier or similar or with another form solution.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!