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

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})


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!