System Availability
I have three systems, let's call them A, B, and C. When I cluster A + C, I would like to prevent users from being able to select either System A and System C as standalone system requests. Both standalone Systems A and C should be marked as unavailable from the drop-down menu until the project finish date is in the past for the row in the Smartsheet which has System A + C selected.
Is there a workflow or formula that I can use?
Answers
-
Hi @Matt Raffi
Hope you are fine, could you please supply a screenshot for your sheet ( remove any sensitive date)
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thanks @Bassam.M Khalil. The screen capture below illustrates my ask;
If system A & C are clustered for a single Proof of Concept (POC) then the user cannot select the standalone system A and system C from the drop-down menu in the System Location column until the POC end date is in the past.
Here is my current IF statement formula that's embedded in the System Identifier Column for row 46.
=IF([System Location]46 = "Arrow/Denver", "A100-C", IF([System Location]46 = "NSL-B Shared", "A100-A", IF([System Location]46 = "NSL-B", "A100-B", IF([System Location]46 = "Arrow/Phoenix-A", "A100-D", IF([System Location]46 = "Arrow/Phoenix-B", "A100-E", IF([System Location]46 = "Arrow/Phoenix-C", "A100-F", IF([System Location]46 = "Arrow/Phoenix-A&C", "A100-G", IF([System Location]46 = "PM System", "A100-H", " "))))))))
What do I need to add to the above IF statement formula to meet my stated conditions?
-
Hi @Matt Raffi
There currently isn't a way to configure drop-downs to be dynamic in this way (to only make certain selections available if other conditions are met). Please submit this form to let our Product Team know about your use-case and feedback!
You could potentially have a separate column to house any data you want to make conditional, then use an update request to trigger and request an update to that row once all the criteria are met.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!