Display URL when condition met

Nilesh ✭✭✭✭
edited 11/07/22 in Formulas and Functions

Hello Experts,

i have two sheet having unique column app name, i have URL column to capture data.

i tried - if([app1]@row = {app2} ," https:URL", "")

i want to show the URL when app1 and app2 are matched otherwise i want to show blank.


  • JSanita
    JSanita ✭✭✭✭
    edited 11/07/22

    may be just be a little syntax issue.

    Does this help?

    =IF([app1]@row = [app2]@row, "https:URL", "")

  • Nilesh
    Nilesh ✭✭✭✭

    Its same, if([app1]@row = {app2} ," https:URL", "")

    app2 is coming from another sheet thats why its showing {app2}

  • Julio S.
    Julio S. Moderator

    Hi Nilesh,

    The result in your formula will depend on what is being referenced in the cross-sheet reference. If this is a whole Column, it is expected that no match is going to be found. Your formula would work if the referenced content would be a single cell as my example below but this would require you to insert different references in each formula which may not be ideal:

    Depending on how the second sheet is configured, it is possible that a VLOOKUP or an INDEX(MATCH()) may better accomplish what you intend as in my example below (which you can then convert to a Column Formula):

    With the above, if there isn't a matching app in the "app 2" column from sheet 2, values in URL column won't be populated (will be left blank)

    I hope that this can be of help



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!