-
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…
-
Dashboard Error
Hi guys, Wondering if anyone can help me out with a Dashboard error i am seeing? I have attached the screenshots relevant. * The error is presenting on a Dashboard which looks up to a Summary Worksheet, which in turn references the core detailed data. * The Chart Type i have selected by default is a Pie Chart (shouldn't…
-
Autopopulating date/ cannot edit
Hi Smartsheet peeps, I am having date trouble in my project sheets. Below is the process I do: 1. Use dependencies to autopopulate the actual start and actual end at beginning of a project 2. Copy and paste those dates into the grey planned start and planned end columns 3. Edit the actual start and actual end date columns…
-
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?…
-
Excel Dashboard Templates
Is there any way to upload an Excel dashboard into Smartsheets so that it is converted to a Smartsheets dashboard? My boss is interested in using the Excel templates but annoyed that there aren't any templates available for Smartsheet dashboards. The beauty of the Smartsheet Dashboards is that external executives can…
-
Link to PDF file on Smart Sheet Form
Hello, Is it possible to make a nice hyperlink for a PDF on my smartsheet form? The current link I have is http://www.DOMAINNAMEHERE.com/mbk/RA Submission - English.pdf My first thought was to put an HTML tag in the form, but that didn't work. When I search the community forum, most of the posts talk about hyperlinks on…
-
produce a report.
Hello, ive been asked if we can produce a report with the percentage done column like the illustration shown below?
-
Identifying all links in a sheet
Another Smartsheet newbie here...I'm sorting through 25 (ish) sheets and there are multiple links between them. Trying to quickly identify all of the Links In and Links out for each sheet to quickly assess how everything ties together. Is there a quick way to pull this info vs. trolling through each sheet?
-
Sharing within a Workspace
I have some folders setup in a workspace. In the column 'Sharing' for the folders, it says 'Workspace'. In the 'Workspace Shared To:' list, it shows three users.. Somehow all users can see the items in the folder, not just the three users in the 'workspace shared to' list. How do I restrict these folders? Thanks!
-
Count Formula
Is there a formula I could use to populate a number into a cell that is a counter of workdays since job has started, and it starts counting once a check box is checked off and stops counting when another check box is checked? this way we can keep an eye on our time frame of a job from start to finish
