Entering values into a contact column

Ben Donahue
Ben Donahue ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

In my dashboard reference sheet, I have a contacts column. Under this contacts column, after the table with the contacts, I have linked data from another sheet for another purpose/widget, and this works great.

I am trying to grab information from another cell in this same sheet using this formula: =[if COMPLETE]28 under the other linked data, in a Contacts Column. This does not work great, or, at all. Is there a way to make this work? 


What you are seeing in the .png is the bottom of the data table that needs the contacts column on the top of the screenshot (Benjamin Donahue) then a blank cell. The blue cells are data I entered manually directly into that cell. Under "% Complete by Days", I have linked a cell, and again under Hours Completed, and also under PM Phone, which is blank. The formula quoted above is under the #CONTACT COLUMN cell.