Update from one sheet to reflect in another sheet using INDEX/MATCH

ashkumar88
edited 09/12/24 in Smartsheet Basics

Hi all,

I'm a newbie and I really did explore every articles to find the answer but I still cannot resolve my issue.

I have 2 sheets Master Sheet and Master Client Sheet (Copy from the Master Sheet). I want to update the status column in my Master Sheet to be reflect in Master Client Sheet. I dont want to show all the columns to my client where I want to show only the Task, Status and Section.

The formula I tried is as below where I put the formula in the Master Client Sheet:

=INDEX({Master Sheet Status}, MATCH([Task]@row, {Master Sheet Task}, 0))

The error I'm facing is #INVALID REF

Please assist and you help is truly appreciated.

Answers