-
Auto populate data and allow customers to update
Hi! I work for a membership based trade association and I'm trying to build a form that would allow me to share profile information on file with our customers (member companies) and then allow them to update outdated information. For example, I would auto populate contact information, # of employees, etc. and they would…
-
Workflow automation - update requests
Hi, I need help. I have a workflow to send an automatic update request when a deadline is achived. The workflow is working perfect but I would like to send line by line and not all lines in same request. Anyone can help me to solve this? In addition i would like also to send an automatic e-mail when the first request is…
-
Update Request does not allow editing field
I have a workflow that sends an update request to each resource assigned. I'm trying to get them to update "% Complete", but it's showing as uneditable. The user is an Editor, and it does allow them to edit other fields, such as Task Name and Resource Name. The % Complete is not a locked column, and the row(s) are also not…
-
Form Response Validation
How can I validate the format of responses? For example, I want phone numbers entered as 000.000.0000, so when a user enters their phone as 0000000000, or 000-000-0000, they will be shown an error message that directs them to enter it in the appropriate format. Also, is there any way to validate an email address?
-
Having Issue with "COUNTIF" returns "0"
Hi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range but I got the result as "0" for everything. I have tried to change the name to execute but that doesn't work. can you please…
-
"Send" row function now requires paid license - no advanced warning
Why were we not informed about this? Copied below is the exact email I received from Smartsheet Product Info on September 17th. This is very frustrating to have a functionality stripped with no warning. We ran through this list with our teams to determine whether or not any of our free users would require an upgrade. This…
-
When configuring an email like an update request, what are the domain options?
e.g., would it come from carolyn@smartsheet or could it come from carolyn@uva?
-
I cannot see my workflows but they are still running
I set up workflows that are still sending update requests. However, when I try to manage my workflows, they are not visible to me. It appears that I have no workflows. Is anyone else seeing this?
-
Multiselect Dropdown with Form integration
Hi SS, The community has been asking for a multiselect dropdown option since 2015. It seems there was some confusion in the other community posts, so I wanted to readdress the issue. Feature request: Dropdown menu with multiple selection option with integration into the forms. The work around of multiple columns is sloppy…
-
HYPERLINK API
We have been using HYPERLINK("http://website.ws/links", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyperlink manually for each row is a terrible ordeal. It would be great if you add HYPERLINK("URL", "Text")…