-
Chart from Metric sheet
Hi all! One of the projects I am working on is using a metric sheet to roll up information. When I create a report from this, to then display on a dashboard, the report shows the column headers. Being a metric sheet, the column headers are generic (Column3, Column4, etc.) as the data within the column varies based on which…
-
How can I align and/or centre my widgets on a Dashboard?
I have about 20 different widgets on a dashboard. I'm looking for a way to easily align selected widgets without having to count how many grid squares are between them. I'm thinking about the function in Visio or Adobe that lets you highlight a number of items and then align them by top, left, right or centre. This issue…
-
Creating Tabs or "Other Screens" on a Form
Is there a way to set up multiple tabs across the top of a form? I do not want to have a form that is extremely long, I would rather (if possible) put multiple tabs so I can consolidate and clean-up the form.
-
Sharing Failed
Hi folks, I am new to Smartsheet, but I've been successful in creating projects and connecting my clients. however, within the last 2 weeks, anytime someone asks for permission to share a sheet, I click the link, and it always says: "Sharing Failed" "
-
Is there a PR/FAQ template?
I need a template for PR/FAQ. Where can I find it?
-
How to use filter to hide and unhide columns
Hi, Is it possible to use filter to hide and unhide columns. For example, I created a Smartsheet that is collaborative of 3 departments and each department has 3-4 columns. I want to be able to see columns as a whole and as department specific by the click of the filter. Is this possible? Thank you, Richard
-
How to create a sheet that a user can search and update
Can I generate a spreadsheet containing account numbers, allowing other users to search for specific account numbers and modify certain columns like address or phone number, while keeping other columns protected from editing? Is this functionality available in Smartsheet?
-
Managing complex, multi-sheet schedules
We are building a large multi-family project. We set up our schedules to be broken out by building permit shell and units. There are 99 sheets in total built using the standard project template with some customizations. Our plan was to roll up these sheets into reports that would allow a project manager to easily update…
-
How do we have sheets without an Owner in our system?
I ran the Sheets Report as part of our ongoing continuous monitoring of access to our company data in Smartsheet (as we do allow outside collaborations). Today I see that there is a sheet shared to an outside email address, (Editor) which is fine, but there is no internal user listed as an Owner or Admin. I thought that…
-
Need only whole numbers in vertical axis of Dashboard chart widget
I am tracking items that should only ever be between 0 and 10 at the most, however when they are plotted on my dashboard widget (see below), it shows 0.2, 0.4, 1.2, etc. These will only ever be whole numbers (0-10) and are pulled from a count on my main sheet. How can I remove the non-whole numbers?
