Contacts list on webform

Michael K

+1. Is this going to be released soon?

BrandoDepot

+1 It's April 2019!

David S

+1 please!

Andrée Starå

Hi everyone,

Please submit an Enhancement Request when you have a moment to have your vote added

A New Way to Submit Your Feature Requests

To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.

Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Angie Hatfield

+1

rza5095956

I would love this feature added. I do not know how to 'vote' on an item submitted -I only see the request form to add a new idea.

If anyone from Smartsheet can help - please add my vote!

Andrée Starå

Hi,

You also vote by sending in the enhancement request form.

Please submit an Enhancement Request when you have a moment.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mattias

Filled in an enhancement request, though this thread is another example of the feeling of not knowing what and when things will be implemented.

Thread started in April 2017 and July 2019 its still unclear how the roadmap looks for this.

Seems abit strange that a column with set properties in the sheet has different properties when used in a form within the same sheet?

I once again suggest that you make it possible to list the current enhancement requests done and let us users upvote them. Give us 5 upvotes / month so we dont get all giddy and upvote everything... 

Andrée Starå

Hi Mattias,

This might help!

Excellent news! Formulas in contact columns are coming very soon.

Coming Soon: A New Way to Assign Work

Formulas like =VLOOKUP enable your sheets to automatically return key data based on its association with a unique identifier. Today, formula output cannot be in a contact column, but we plan on supporting this very soon.

What does this mean for you? Teams that field requests in IT, marketing, and other departments will be able to automatically assign incoming requests to the correct person. This will help eliminate the manual process of assigning new work, and get the right people working on the right things more quickly.

For example, if you are a West Coast regional manager for a consulting firm, you can create a sheet for tracking customers. Using a Smartsheet form, prospective customers can fill out their name and address to request a bid.

With the forthcoming capability, you’ll be able to quickly set up a formula in the contact column then, dependent on the submission, look up the state and which regional manager is responsible. The correct person is assigned to that customer, and a notification is generated to let them know they have a new opportunity to work — all without any manual input.

One of Smartsheet’s fundamental commitments to our customers is continuous improvement. Ensuring that you can move from idea to impact — fast — is critical. Be on the lookout for performance enhancements that will improve formula speed within your sheets. We’re happy to share these changes with you, and look forward to many more to come. 

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mattias

Sounds like a feature update. Not sure if this will address the thing I was looking for though.

What I was looking for was a way to use the populated contact list on a sheet where the correspondant field in the form shows contact list form field as a dropdown select field.

The VLOOKUP feature seems to be a way to use the form post to set the contact list column to a name based on one of the fields in the form?

To achieve the solution I was after would mean to create a new field in the form and populate that with the same names as in the sheet contact list column and then use a formula to set the contact list on the sheet, or I am missing something here?

Regards

Mattias

Andrée Starå

Ok.

I think the formula in the contact column is the first step and that it will be possible to do what you want later.

Andrée Starå

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