Smartsheet Basics

Archives for May 2018

Sorting Names with Accent Marks
We serve an international client base, and when I go to sort names in a smartsheet I built for a client directory, instead of placing names with accent marks in alphabetical order, the sort places all names with accent marks at the bottom of the list. For example, José would be sorted with the "J" names, but placed at the…
Create a Chart without using numeric data
Good day, May I ask if there is any way to create a Chart in Smartsheet without using a numeric data? I wanted to create a chart using names/phases as reference but I received an Invalid Data error message. It says, "To create a chart you must use numeric data".
Sign up through one form onto multiple sheets at once?
I use various different smartsheets to sign people up for various employee groups (the Smartsheet is a member signup list). Each group has its own Smartsheet and its own signup link. However, I would like for each signup form to let people choose "sign me up for these other groups" where they check as many boxes as they…
Template: Team Task List by Priority
Hi Everyone, I'm new to Smartsheet. In the Template titled Team Task List by Priority, there are headers. High Priority, Medium Priority, Low Priority and Completed. My question is: how do the tasks in lines below the priorities get assigned to which priority? Do they get auto-populated to each priority based on something?…
Add a New Task with all the sub rows
I have a sheet where I have all my projects and then sub categories indented underneath it. Is there a way I can easily add a new project that will create automatically add the sub categories?
How to enable the Guest account in Alfresco?
I have recently installed alfresco community edition in my Windows 7 but by default guest user account is disable state and i can't change state of the guest user account by clicking enable or disable check box.
Approval Requests
Is there a way to send an approval request to multiple people but require only one to approve it? For example, we would like either our AVP or our VP to approve travel requests, but they don't both need to approve. If I include both names in the section, then it adds a column for the second approval, which isn't…
Linking directly to files from a dashboard?
I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files. Saving as images wont work either, as we have 10+ files to link to, and want to organize…
Restrict a user's access to Dashboard only
I am new to Smartsheet but learning fast. We are starting a project to use Smartsheet for client onboarding to our software. I intend to create a client-facing dashboard but would like to restrict a user's access so they cannot click on the Home tab which they have no reason to view and is just a place for them to take a…
Assigned to limitation
Hi Everyone, Do you know if it is possible to assign the same task to many users ? or a group of user ? Thanks Olivier

Trending in Using Smartsheet

Organizing Smartsheets into folders - Impact to DVs and WorkApps
Hello, I'm trying to organize the workspace listing in Smartsheet. If I create folders and move sheets into different folders, will that mess anything up for the Dynamic Views and WorkApp? Thanks, Frank
Automation to send past due notifications to members
Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…
Bulk download of all the PDF attachments in a worksheet
Hello Community, I am quite new to the Smartsheet and came here to get some advice from you all, i would like to know if there is a way to download all the PDFs attached in different rows of worksheet at one go if the attachments are more than 1000, it would be very helpful if you can guide me through the process, i am a…

Smartsheet Basics

Discussion List