Forum Discussion

ALawton's avatar
ALawton
Copper Contributor
Feb 18, 2025

Auto-Populating Data From One Sheet To The Other

My structure is 2 separate tabs in the excel sheet. In one sheet, my "Devops Tasks" sheet, I have a status of "COMPLETE", and currently, everything besides 2 are set to "INCOMPLETE". When I se...
developer
excel
Formulas and Functions
PGSystemTester's avatar
PGSystemTester
Copper Contributor
Feb 19, 2025

That formula is in R1C1 format, so it's a little difficult to troubleshoot via a screenshot. Also what's the expected output on your Handover report?

  • ALawton's avatar
    ALawton
    Copper Contributor
    Feb 20, 2025

    Here are some more screenshots:

    Below is from my DevOps task sheet2:

    Photo 1Photo 2

    Below is from by Handover Report sheet 1:

    The expected behavior is that I set the status to complete via drop down arrow in DevOps Tasks:

    Then, after setting to complete, the ID, Title, who it is completed by or "assigned to" and which sprint it is from accurately populates here:

    Whereas right now, setting anything to complete at any point seems to populate something, and that something only being this "#NAME?".

Resources