-
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")…
-
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)…
-
Trigger Approval Request with the submission of an Update Request
Is it possible to send an automatic Approval Request right after an automatic Update Request was filled in.
-
Report: Sheet Summary - Update Field from Report
I'm trying to find a workaround the lack of functionality in Update Requests. I have a Sheet Summary field called "Project Update" where our Project Lead is expected to put a brief statement on their project weekly. That field feeds up to the Project Dashboard and, subsequently, a Portfolio Dashboard to provide an update…