Contact list and webforms

Yovanka Barnard

Hi,

I have a column on my sheet which is the contact list.

However, in the webform it does not show as a contact list.  So I had to go and make it a dropdown with the exact same options as the contact list.

Now, these sheet line items are not pulling through on my various reports. Because in the report builder I must now put the criteria under "what" and no longer under "who".  I can put it in under "What" but then all arguments needs to be ORs or ANDs, making the report inoperable.  Because within "What" I need some "ors" and some "ands" conditions for it to then put in the dropdown column.

So how can I have a contact list on a webform or have "Ors" and "Ands" conditions on my report builder under "What"?

Y

 

J. Craig Williams

Ha! I just wrote an enhancement request and am adding a thread post now.

Will be back here to comment further after that.

Update:

I wrote the enhancement request: https://community.smartsheet.com/discussion/enhancement-request-improvements-contact-list-columns-forms

You can get the Contact List column to function as a Contact List by entering one or more contacts in the column properties. This will allow you to use the "Who" as desired.

Craig

Yovanka Barnard

Thanks Craig.  I replied on the enhancement request.  Still trying to figure out how I can make it work.