Need 1 sheet to reference the same cell in row 1 (must always be row 1) of another sheet (form fed).

Haily

I have one sheet that gets it's information from a form (Monthly Update Sheet). In the Monthly Update Sheet there is a field (Scope Health) which is a color icon (red, yellow, green, blue). I want to transfer the most recent (always row 1) color to another sheet (Status Table Sheet) without having to change the cell link with each update (form submission).

I have been trying to create an absolute reference but I don't think I am doing it correctly

A cell in Status Table Sheet (={Monthly Update $[Scope Health]$1} or ={Separate reference sheet $[Absolute reference column]$Absolute reference row})

Paul Newcome

Try this:

=INDEX({Source Sheet RYGB Column}, 1)

Paul Newcome

Try this:

=INDEX({Source Sheet RYGB Column}, 1)

Haily

Awesome Thank you!

Paul Newcome

Happy to help. 👍️