Returning A Symbol Value From Another Sheet

✭✭✭

Hi all!

I am trying to return a symbol value from a cross sheet reference, and I am having a little bit of difficulty at the moment. I have 2 sheets, we'll call the first sheet (that I am trying to reference) "Trends", and the second sheet "This Week". In "Trends", every row represents a week, and ta the end of every row there is a symbol, comparing the results of the current week to the previous. In the "This Week" Sheet, I would like to reference that symbol. I have a custom formula the provides a "week of" date (custom because it counts from Fridays-Thursdays instead of Mon-Sun or Sun-Sat), and I am trying to grab the symbol where the dates are equal. When I do this however, I get an "INVALID OPERATION" error. I'll link the formula along with explanations and necessary screenshots below:

=IF({Trends: Date} = [This Week]@row, {Trend: Symbol})

What I am doing with this formula is comparing the date in the "Trends" sheet, to the current week ok ("This Week") in the "This Week" sheet, and trying to return the value at the corresponding "Symbol" column.

Any all all help would b greatly appreciated, thank you in advance!

Tags:

• ✭✭✭✭✭✭

I don't think the screenshot attached, but if I understood your question correctly, you'll like to return a symbol from a Sheet B ("This Week") that shares the same date in Sheet A ("Trends"). If that is right, Index/Match formula is your friend, here's a link that simplifies how to use the function:

Note that you will need a unique identifier to anchor both sheets and return their respective symbol. This means if you have multiple entries sharing the same "date", it wouldn't work. A good way around this is to create a auto-number column to create a unique identifier.

Cheers,

Ric

• ✭✭✭✭✭✭

I don't think the screenshot attached, but if I understood your question correctly, you'll like to return a symbol from a Sheet B ("This Week") that shares the same date in Sheet A ("Trends"). If that is right, Index/Match formula is your friend, here's a link that simplifies how to use the function:

Note that you will need a unique identifier to anchor both sheets and return their respective symbol. This means if you have multiple entries sharing the same "date", it wouldn't work. A good way around this is to create a auto-number column to create a unique identifier.

Cheers,

Ric

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!