Cross Sheet References

Options
ljtice
ljtice
edited 02/19/24 in Smartsheet Basics

I am trying to create some UAT Testing and Issue Trackers. I have two (2) sheets, one called Tests and one called Issues. As the scenarios in the Test sheets are pre-defined, I would like to be able in the Issues sheet to add the scenario number to the field in the row Issue row but then autopopulate the issue number back in a column on the Test sheet.

Example. Test Sheet with Issue Reference populated from

Issue Log with Scenario field.

In short, I would fill out the Issue sheet first and add the related scenario, which would then autopopulate the Issue 1 column in the Test sheet. I'm not sure why I'm having such a hard time with this.

Best Answer

  • heyjay
    heyjay ✭✭✭✭✭
    Answer ✓
    Options

    If I understand in correctly, the formula needs to be entered in the column Issue 1 of the Test Sheet.

    =Index({SIT #},Match([Test Case]@row,{Scenario},0))
    

    Anything in curly brackets needs to be set as reference.

    ...

Answers

  • heyjay
    heyjay ✭✭✭✭✭
    Answer ✓
    Options

    If I understand in correctly, the formula needs to be entered in the column Issue 1 of the Test Sheet.

    =Index({SIT #},Match([Test Case]@row,{Scenario},0))
    

    Anything in curly brackets needs to be set as reference.

    ...

  • ljtice
    Options

    Thanks, I made that work. I'll get the hang of this syntax soon, I hope. However, when I make updates, they don't seem to keep up, I get no match. Is there a lag?