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

New User..
Hello, I am a new user to Smartsheet and have a question on Saved Automation Workflows. I am trying to edit the email by adding a due date in the subject line of the email once it reaches a trigger date. Please advise on how I can change the due date from month.
auto-resend update (or approval) request after 30 days
I have some automations set up where the work is intensive (or people forget) and update (or approval) requests sit for more than 30 days. The notification center wipes these requests out after 30 days and although they sit in email, people seem more likely to completely forget about these completely. Does anyone know a…
Adding Contacts To Contact Columns
In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for "sharing". I want to share sheets with my whole operation (75+ people), but having to individually…

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

Watch video

Smartsheet Basics

Discussion List