How can I index match (if) data is not found on first sheet to go to a second sheet fo find the valu

kgahm7569

kgahm7569 ✭✭✭

06/30/22 in Formulas and Functions

Ex.

index (Code), match (EID@Row), sheet 1 EID

But if ot found there I want it to look at sheet 2 for EID

0 ·

Answers

kgahm7569 ✭✭✭

06/30/22

Resolved IFERROR --

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Attempting to add to a large formula but getting #unparseable
Attempting to add a fifth sheet reference mimicking the previous ones in the formula however getting UNPARSEABLE. I attached a photo of the formula and the updated one below (if i paste it breaks my post) and when in the sheet i notice that the () around cell are orange on the original and green on the new ones so maybe i…
Sheet summary formula to return first value above 0
Seeking a sheet summary formula to return the first value above 0 for "Countdown" column. This value will be displayed as "Countdown to next launch" in a dashboard.
Another If Formula
=IF(NOT(ISBLANK([Payment Type]@row)),CONCATENATE([Payment Type]@row,"-",TEXT([Invoice Date]@row,"MM/DD/YY"),"-PD-",TEXT([Posted Date]@row,"MM/DD/YY")),"") I cant figure out whats wrong with this formula. The column names all work and are named appropriately