-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
-
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…