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?


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Matt Raffi 

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

    PMP Certified

    ☑️ 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"

  • Matt Raffi
    Matt Raffi ✭✭
    edited 12/15/20

    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.
    Genevieve P. Employee Admin

    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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!