Entering values into a contact column

Ben Donahue · 06/05/19

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.

Andrée Starå · 06/05/19

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å · 06/05/19

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 · 06/05/19

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å · 08/13/19

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 · 09/02/19

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å · 09/02/19

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

Entering values into a contact column

Comments

Categories