Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I need to have a contract cell automatically fill with the contact cell above it. The column type is contact list and I want the user to be able to select the contact in the first row and have the rest of the rows automatically fill with that contact.
Hi Jana,
Bad news. Unfortunately, Contact formatted columns do not support formulas.
If you can get away with not having the contact directly above the cells you wish to populate in the rows below, then you can use the following formula:
=IF(NOT(ISBLANK($[Contact Column]$1)),$[Contact Column]$1,"")
You are including a $ in the cell reference so it becomes an absolute reference. This means it will not change (e.g. [Contact Column]2, [Contact Column]3 etc.) when the formula is copied to other cells.
Now drag the handle in the bottom right of this cell all the way down the column as far as your data goes. Any new rows will now inherit the formula and will change automatically if the value in [Contact Column]1 is changed
Bear in mind though, that the results in your data rows will not be Contacts, only the contact name, and you will need to find something else to put in the remaining rows of your [Contact Column] so it doesn't look weird. Find something that doesn't need to be calculated using a formula and you'll be fine.
Kind regards,
Chris McKay
This is another feature that needs to be added/fixed. Give the contact columns the ability to use formulas. This seems pretty basic.
Hi everyone,
It's released now!
https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
