I want to display two drop-down list fields on a form (Model and Serial Number). The values in the serial number field should be conditioned by the one selected in the "Model" field.
Is there a way to do it?
Thank you for your cooperation.
Unfortunately not. How many different Models do you have?
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
Hi @Juan Carlos Reguera,
Recently I developed something similar for a client, and I ended up adding columns for each option.
In your use-case, it would be something like,
If Model A is selected in the form, it would show the serial numbers in the Model A Serial number column through the Logic feature.
Would that work?
I hope that helps!
Be safe and have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
@Andrée Starå That is along the lines of what I was thinking. Hahaha. That's why I asked how many Models there are.
Thanks for your answer.
Unfortunately, both the quantity on Model and Serial Number values are high and very changing, so I need an automatic process to do it. (Conditional filters on the displayed fields or something similar)
Thank you very much for your quick response.
Keep up well.
Andree may have other ideas, but if having different fields for each Model to display the appropriate Serial Number values is not an option then I am left with suggesting that you Submit A Product Enhancement Request when you have a chance.
@Juan Carlos Reguera
Ok. You would need to look at other options. How many different Models could there be?
I'm working with about 70 differents models.
Thanks in advance.
Happy to help!
A solution that would be perfect for this use-case is the premium add-on, Data Uploader. Is that an option?
We could use it to sync the values to the different columns and then build it with logic to show the correct dropdown list for the selected model in the form.
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
I am a business user but Data Shuttle is not activated. How to activate it?
Hello I am trying to calculate a sheet summary field to show how many times a value appears in the Location column. I am using the Count if function but it is only returning a value when the "location" is presented on it's own. For eg: my formula is =COUNTIF([*Location]:[*Location], "VIC"). This formula responds with a…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.