-
Enhancement Request - Hidden Columns Manager
Running out of screen real estate is a problem. I find myself hiding or dragging columns to right and then having to unhide them or drag them back into the active area of the screen as needed. Request for a utility that would store preferences for hidden columns that has the same general controls as the <filters> widget.…
-
Sheet Data Reports
Hello SmartSheet community! We've been using Smartsheet for a while now throughout our company and so far have several sheets. Some have important deadlines/dates while some just have to-do lists with several tasks that are flagged as important. I'm having difficulty figuring out how to compile all of the upcoming dates,…
-
More than one contact in the contact list drop-down
We have a column type "contact list" that we use to track sales reps for individual products. Sometimes we have a product with more than one sales rep. I created a group with both sales reps as part of the group thinking I could use the group as the contact. It isn't available in the dropdown, only individuals. I want to…
-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
-
Moving Rows with a Formula
Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
-
Outlook Integration - Link Email Address To SmartSheet Contact
I'm using the Outlook integration for SmartSheet to update my task list I manage in SmartSheet. In my task list I have an "Assigned To" column, with a column type of "Contact List." While in Outlook, I can update the "Assigned To" field. If I type in the person's email address correctly, SmartSheet will notice the email,…
-
IF Statement Help
I have a sales price database with one column for a retail price and another for a sale price. I'd like to make a 3rd column with a formula that populates the Save __% for our Marketing team. I made this formula which works with one small issue I'd like to resolve if possible. =IFERROR(("Save " + (ROUND(1 - ([Sale…
-
Jira Connector uploading Duration in Seconds
Something has changed. I had a JIRA Connector working well, exchanging task duration in days from a JIRA Field, and a Duration Column in my Smartsheet and something changed The connector now populates my mapped JIRA field using seconds rather than days. It used to populate the JIRA field in days, just the way it was…
-
Automated Approval Requests
HI , I Have set up an Approval Request Which works amazing My only Issue is that my client that needs to approve the job Request Gets in his email for each Request line an email but its an auto Reply to the Previous Request Is there a way by the delivery settings to set that the subject of the email should always Reference…
-
Trying to get fancy with formulas - RYG with "AND" conditions
I'm trying to get a formula that will do the following: Give me a RYG result in a column, by looking at whether a project item has gotten close to the due date, compared to what the status is on that item. I want it to give a Red result if it is within a specific number of days of the due date and has less than 25%…