-
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")…
-
Hyperlink in Alert/ Automation
Hi, I would like to add a hyperlink to a Smartsheet report in an alert. The idea is that I want to direct the alert recipients to go to this report to complete a task. Is there anyway to get a hyperlink into the body text of the email alert? Otherwise I need to put the entire url into the body of the alert, and the…
-
Requests
I'm new to smartsheet. I was wondering if it was possible for a requestor to edit a request they have already sent in after submitting the form or do they have to fill out another form?
-
Request Updates on Reports
Anyone know of a creative way to show pending updates on a sheet? I have a 1000+ row sheet and only want to see the pending update requests.
-
Is it possible to NOT display the Row Number in an Update Request email?
We have a sheet that collects basic award nomination information using a Form submitted by the nominator (indiv A). We then need the nominee (indiv B) to update their mailing address with us. We are using an Update Request automation to capture the address information on the same row in the sheet as the rest of the…
-
Completed Tasks removed from calendar
Is there a way to remove completed tasks from the calendar without removing them from the sheet? I have a done column that checks off and greys out the row but the information still shows up on the calendar is there a way for it not to show up on the calendar? Thanks in advance.
-
Smartsheet at- risk formula
Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column. I only want the column to flag is the status is not complete and the target end date is past due. My current formula is =IF(AND(Status301 <> "Complete", [Target End Date]301 <= TODAY()), 1, 0) Currently, the column flags…
-
Can Smartsheet lock a column AFTER data is input, for referencing in Update Requests?
Hi, I have a Smartsheet workflow I would like to implement and can't seem to figure out if it's possible. I have a sheet with four columns: Name, Date (formula set to the following Monday after the CreatedBy date), Commitment Detail (a work task they are promising to get done), and a Commitment Completed (yes/no dropdown)…
-
Update Requests with columns for viewing only
Is it possible to make an update request, but only allow editing of certain columns? I want them to be able to see certain columns, but not change them.
