Data Shuttle Expression Not Working


I'm trying to create a Unique ID using an expression in Data Shuttle that looks at three columns. First, if there is a value in column A, then use that, if not use column B to create the first value (Value 1). Then I'm checking in column C to see this there's a value (Value 2). Then, I create the Unique ID, by looking for Value 2, if that's blank I use Value 1, if there is something in Value 2, I use that + Value 1.

Problem is, nothing happens when I run the data shuttle.

Any ideas on why this isn't working?




  • Neil Watson
    Neil Watson ✭✭✭✭✭✭

    Can you share a screenshot of the expression?

  • Tim Dollmeyer
    Tim Dollmeyer ✭✭✭✭
    edited 06/21/23

    Here's the expression:

    =IF(ISBLANK(IF(ISBLANK([Current Requisition]@row), [Filled Requisition]@row, [Current Requisition]@row)), [Position ID]@row, [Position ID]@row + "-" + (IF(ISBLANK([Current Requisition]@row), [Filled Requisition]@row, [Current Requisition]@row)))

    It works in the sheet, just not in the Data Shuttle expression.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!