System Availability

Matt Raffi

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?

Bassam Khalil

Hi @Matt Raffi 

Hope you are fine, could you please supply a screenshot for your sheet ( remove any sensitive date)

Matt Raffi

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?

Genevieve P.

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