Entering values into a contact column

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?

EXPLANAITION OF SCREENSHOT:

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.

Find more posts tagged with

Cell linking

Comments

Andrée Starå

Hi Ben,

EDIT: There wasn't a picture when I answered.

Not sure exactly what you want to do.

If you want to cell link, that looks correct.

Is that what you want to happen?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Unfortunately, it's not possible at the moment to use formulas in contact columns, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Best,

Andrée

Paul Newcome

Cell linking works in a Contact Column though, so a workaround may be to place the formula elsewhere and then link to that cell.

Andrée Starå

Hi Ben,

It's possible to use formulas in contact columns now!

https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Michael Graysmark

Hi Andree

The introduction of Formulas in Contact Columns has unlocked a potentially very useful feature.

I have noted that is extremely flaky though.

For example I can create a formula, either a simple "=[AN Other Contact Cell]1", or something more complex like a vlookup to another sheet etc but the results are variable.

Initially the formula will return a value correctly but then when the sheet refreshes i get "#ContactColumn" Error in the contact cell containing the formula.

If i F2 Edit the cell (or copy and paste the formula back in) it works again until the page refreshes

Any Thoughts?

Andrée Starå

Hi Michael,

There are some known issues at the moment and Smartsheet are working on fixing them.

More info at the bottom of this post: https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sign in to join the conversation!

Quick Links

Trending discussions

Grid creation
Hi All, I have a sheet that I am creating to gather powder coat thickness data. The problem I have run into is that they can do up to 5 checks on the same line during the same day and shift. Then they get the average of those measurements to use for the day to determine if the thickness passed or failed. If I have a form…
APPROVAL SETTING VIA "ADVANCED OPTIONS" - APPROVAL WORKFLOW
Hi All, Need you support for the the issue. I was in the process of making an approval workflow for petty cash request, the problem was when i want to combine 2 different confirmation workflow by Requester to be appear in same column (Confirm), but mention notification like in the screenshot attached. The workflow consist…
Share Tab not activated
New to smart sheet pro and I desire to share to viewer, share tab not activated...how do I activate and share a sheet with a viewer?