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.
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Cell linking works in a Contact Column though, so a workaround may be to place the formula elsewhere and then link to that cell.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives