We require our licensed users to conduct semi-annual user access reviews on their Smartsheets. They need to remove users who no longer need access rights and delete or archive smartsheets that are no longer needed. (See attached jpg) If th…
Using Smartsheet69Stephanie G
I have multiple predecessors between lines 19- 29. Is there a way to add all these in without having to type each and every line #.
for example- I want to avoid having to type in the predecessor field, 19,20,21,22,23,24,25,26,27,28,29
I am trying to create a template in Smartsheet that was housed in excel. There is a bit of a complicated formula I am trying to transfer and having a heck of a time. Here is the excel formula:
I need to be able to search by case.
I want to search for
but not both.
I have tried various forms of "RONIN" or "RONIN*" and have not been successful.
The specific use case is a TRADEMARKED NAME O…
Using Smartsheet34J. Craig Williams
I have one smartsheet which tracks projects within a continuous improvement process where I can define if a project is high priority or not. I wish to pick-up this indication up and using in other sheets that reference the same pro…
We have data that is organized into a Target->Category->Item hierarchy, for example:
Target: Big Event in Las Vegas
Category: Digital Blogs
Item: Blog about XYZ
There is a "Target Date" for the top level Target,…
I am trying to setup a Conditional Format formula to format a cell only when the cell contains a linked value of "Sheet Link from Cell in Other Sheet"
We use Smartsheet notifications and receive emails frequently letting us know that a task was completed, and it is now our turn to work on a task. We use MS Outlook as our email client, and within here I like to use the preview pane. When …
Using Smartsheet12David M.
Is there no way to use a custom template via the "Create New / +" button on the tab bar instead of going to Home and selecting it over there?
After the recent update I started having problems with one or two links here and there not properly updating. Double clicking on the receiving cell would point to the right cell in the source sheet but the value was wrong. I could repair t…
Using Smartsheet144Jim Hook
Has anyone seen any updates regarding the Cell Linking issue? I reported it on Thursday, but they say it's in their Tier 3 team's hands for investigation.
i get a lot of helpful information from the Community, Help and Blog sites. Is it possible to subscribe to a daily or weekly list of posts to these areas as part of my ongoing education about Smartsheet?
Using Smartsheet37Morri Young
How do I do this: I need to collect data (name, address, etc) from new clients and I have created a Smartsheet for basic data. I then email the new client with a link to the form and the client fills out the sheet.
However, each client …
Using Smartsheet53Cindy Hawkins
This may be a simple fix; however, I am fairly new to Smartsheet and any insight would be appreciated. I built a report that is linked to three different sheets. They were originally imported from Excel that way the formula…
Is there a way to restrict or grant specific edit permissions with a collaborator? The permission settings under "Editor" are to broad, however, viewer does not have enough permission.
e.g. I have 10 rows in a sheet that one of…
I have been looking for the solution to share into a Workspace. I see the Workspace and I have Editor access. I do not see the options on the sharing sheet checkbox or under Home from the screenshot. Please advise if I am missin…
Is there a possibility how I can insert a excel chart into sight without inserting a snapshot.
Using Smartsheet1Andreas Gevay
I have created a punch list with a column (checkbox) to mark completed items. I am sharing the sheet with collaborators (non-licensed) by weblink. This will be accessed through the web on a smartphone. These are our field installers and do…
Has anyone used this form yet? Looking for an understanding of whether each employee needs to have their own sheet??
My company just finished our event in 2017, and I want to take the same exact smartsheet from last year and use it for 2018.
Is there a way to take all my past bullets, and change the dates to 2018 without changing them all …
I have a bunch of numbers in a column, I want to find all the rows that include the # 13 in the number. The "contains" filter option does not work. Need suggestions on finding certain subsets of a longer number on the fly.
Using Smartsheet178Bill Brandt
I am trying automate pulling data entered in the form, that pulls into the sheet to then pull into a sight without using a report as the formatting is not very good, can anyone help?]
I have attached a screen shot to support above.
I would like to nest a short checklist of rows under an activity in a Project Sheet such that the nested rows representing the checklist do not require durations and dependencies.
However, SmartSheet requires the duratio…
In some of my header rows I don't input data, so I want some of those cells to be blank. How do I blank them? See attachment.
We have a pipeline report pulling data from a primary sheet that we need to separate out by year. Is there a way to add a row or page break to distinguish and separate the two years?
Also, In regards to header row at top of reports is the…
Using Smartsheet114Lisa Davis
I would like to create a sheet or report that combines all of my other sheets so that I can look at them all together and sort by task.
Ideally, this "master sheet" would update as each individual sheet is upda…
Created a dashboard for multiple sheets that I would like to send to stakeholders once a week. I don't see any options to send other than publishing a link and emailing myself
Using Smartsheet12Randy Van Winkle
In smartsheet how do I select a checkbox for a group and have it select all checkboxes in that group?
As we are rolling out SS company-wide, many people are asking if we can have a single summary of notifications sent vs multiple emails each time. Is this possible?
Using Smartsheet28Sarah Irving
My goal is to have a formula populate the dues dates with one condition.
Currently Drawing Due Date is populated 2 weeks from Order Date
If the "Type" Column is "Q" then I need the Drawing Due Date to be 1 …