Smartsheet Basics

Archives for May 2018

Dynamic Durations
I would like to calculate the duration based on two tasks. For example, I want a start date from say task 1 to be the start date of Task 2, while the end date of Task 2, to be the start day of task 100. The duration should of Task 2 will now be the total number of days between task 1 and task 100. If I adjust Task 1 or…
Title characters
Is there a way to increase the character restriction in the column titles? I need this for the forms I am creating, they need to be longer in the column title to create the forms I need.
Filter default settings
I use up to 5 sheets at any one time, each containing information relating to different customers. I frequently need to filter information on any particular sub-client via a text/number column. The default ‘Create New Filter’ uses “contains” for me to enter a unique name of the sub-client, and all rows applicable to that…
Is smartsheet / control center be able to exclude the attached file format?
I am sure if it is possible to limit the attached file format. For example, we only allow the users to upload the certain file formats.
Allow users to add Comments, but not edit any other items?
Is there a setting that would allow "Viewer" users to add comments, but not change any fields? I have users entering records via a Form, but once the Form is submitted I need to lock all of the fields except the "Comments". If the comments are locked, the "Viewer" user has no way of adding additional information to the…
Use "Request for Approval", but without Confirmation Email?
Is there a way to suppress the Confirmation Email that is sent to a user when they complete a "Request for Approval"?
Is there a way to assign someone by phone number
I wanted to know if there is a way to assign someone by a phone number rather than an email address?
Showing filtered items in Card View
Hello, Would like to ask if there is any way to still show the items in Card View even if those items are hidden/filtered out in Grid View? Thank you in advance for any feedback.
Ways to send add more than one email in the send to column for each row
I would like to have more than one person in the send to column for each row. I have seen this done before and I am just not sure on how to do this. Please assist. Thank You
Having a form as an email
I am trying to have a form go into smartsheet once it is completed with the same colors and as the form and also not show that things were updated in yellow. Is there a way to do this?

Trending in Smartsheet Basics

Setting up a weekly automation to alert someone in 30, 60 and 90 days of a date
I have a sheet that tracks employees certifications. I'd like to setup a single automation that runs weekly to alert the employee when the expiration date is within 180, 90, 60 and 30 days away. I'd prefer that the 180 day alert only be sent monthly until the 90 day date is hit, then weekly. I'd like the message sent to…
Alerts
Hi there, I want to use the trigger and alert to notify someone in the next row when the task above is complete. E.g., if the Status column is changed to Complete in row 3, I want an alert to be sent to the contact in the Assigned To column in row 4. Is that possible? Megan
MAX COLLECT for dates in a row
I have a certification that requires a few lessons to be fully certified. Each lesson has a completion date in it's own column and a date column for when they become fully certified. So, if there if one training is missing a completion date they are not considered fully certified. My need is to be able to collect the max…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List