Skip to content
  • Try Smartsheet

    • Smartsheet Basics

    Smartsheet Basics

    Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

    selecting multiple values in dropdown using url query string

    ✭✭✭✭✭
    in Smartsheet Basics

    Hi I'm trying to get multiple values into a form using url query string. I have created a formula.

    =URL string to form? + "PBM=" + IF([PBM 5]@row; "value 1" + "&" + "PBM=" + IF([PBM 7]@row; "value 2")+ "&" + "PBM=" + IF([PBM 8]@row; "value 3"))

    The form has vertical checkboxes and the column is a dropdown with multiple select.

    I do not get the values to be selected, I have used different way's but no result.

    any tips?

    Tags:
    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭✭
      Answer ✓

      Hi thanks for your response. The IF function is only a part of the total formula. I figured out why it did not work. The destination form had remark fields filled that had different names then the column names, apparently the remarks field overrules the column names in case of a url. Cleaning out all remarks field, did the trick.

      · Share on FacebookShare on Twitter

    Answers

    • Community Champion

      Hi @Hilbert Kok, I would move the 3 "IF" statements into 3 helper columns and see what values those return. Then add these together in the formula.

      The IF functions also don't look correct, the logical expression in particular: IF( logical_expression, value_if_true, [value_if_false, ] )

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭
      Answer ✓

      Hi thanks for your response. The IF function is only a part of the total formula. I figured out why it did not work. The destination form had remark fields filled that had different names then the column names, apparently the remarks field overrules the column names in case of a url. Cleaning out all remarks field, did the trick.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending in Smartsheet Basics

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video