Using Smartsheet
Archives for June 2020
Discussion List
-
Time line displayQuestionAnswered - Pending Review wsguerin 15 views 7 comments 0 points Most recent by Debbie Sawyer Using SmartsheetFirst post 06/30/20,Last post 07/02/20I need to do a Gannt chart with only Week 1, Week 2, Week 3, no Secondary Heading is needed. Seems like a very common need but I'm not seeing a way to do it...thoughts on this?Using Smartsheet157wsguerin -
Answered - Pending Review Jeremy Jones 33 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 06/30/20,Last post 07/14/20I have a request from one of my project managers to pull a report that will list all of the individual comments added to a sheet. Basically, they would like to be able to review the comments added to the individual line items in one holis…Using Smartsheet335Jeremy Jones
-
Answered - Pending Review Elsie Rockers 53 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/30/20,Last post 07/01/20The sheet I am trying to share is not in a workspace and the individual I am sharing to already has admin access. Im unsure what to do next since I have shared other sheets with this person with no problem.Using Smartsheet531Elsie Rockers -
Answered - Pending Review Frank H Smith 13 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/30/20,Last post 07/01/20I'm working on several automated responses and trying to determine the maximum charter limits for each one and does this include spaces: Character limit for alert someone automation (I believe it is 200 characters, not sure about spaces) C…Using Smartsheet131Frank H Smith
-
Answered - Pending Review Yashwant Singh 22 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/30/20,Last post 07/02/20Hi, could you please suggest below view possible or not in smartsheet. based on below conditions . (Image) Conditions : (Image)Using Smartsheet221Yashwant Singh
-
Answered - Pending Review Laura Montagno 16 views 2 comments 0 points Most recent by Laura Montagno Using SmartsheetFirst post 06/30/20,Last post 07/01/20I have created a sheet and a collection of forms that we are using to have employees complete a daily self-screening for COVID symptoms. The sheet is quickly reaching its maximum row count. I'd like to archive the records (rows) for each m…Using Smartsheet162Laura Montagno
-
Answered - Pending Review Saroja Hanasoge 12 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 06/30/20,Last post 07/08/20I want to automatically create a new smartsheet as part of an automated workflow which gets its name from a cell in the original smart sheet.Using Smartsheet123Saroja Hanasoge -
using SUMIF / SUMIFSQuestionAnswered - Pending Review Cameron McGregor 11 views 3 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 06/30/20,Last post 06/30/20im now starting to become formula blind, help i have 1 column with a reference to use as the identifier, "1-3" in the image, but i want to SUM up all the values in multiple columns! But the only way i can get this to work is look…Using Smartsheet113Cameron McGregor
-
Merging cells / text overflowAccepted AnswerFirst post 06/30/20,Last post 07/16/20Hi It would be really helpful if there was an option to merge cells or to allow text to flow over (and wrap) so that the text could run the full width of the sheet. In the example below, I would like to text in the Primary Column on row 6…Using Smartsheet374Marijan
-
Answered - Pending Review Mitch Butler 24 views 3 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 06/30/20,Last post 07/01/20(Image) I am trying to chart a lot of data point over multiple years but there are way too many labels on the horizontal axis. Is there a way to reduce the number of labels to allow the chart the be understandable?Using Smartsheet243Mitch Butler
-
When using checkbox put strikethrough on row when checked?Accepted AnswerAccepted Answer Brittany Lucarell 22 views 2 comments 0 points Most recent by Brittany Lucarell Using SmartsheetFirst post 06/29/20,Last post 06/29/20Does anyone know if there is a way to make a row strikethrough when checkbox is marked?Using Smartsheet222Brittany Lucarell
-
Answered - Pending Review Gordon 74 views 3 comments 0 points Most recent by Terry Lewis Using SmartsheetFirst post 06/29/20,Last post 07/22/20When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? If not, is there a way to then take the output sheet data and cross reference to matching rows in a third sheet, and can I build furt…Using Smartsheet743Gordon
-
Can order of columns be locked?QuestionAnswered - Pending Review Tanya Brooks 11 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 06/29/20,Last post 07/08/20I have several columns that link to other sheets. If the order of the columns in the inbound sheet is changed from that of the outbound sheet, the linked information ends up in the wrong column. Is there a way to rfreeze coumn order?Using Smartsheet113Tanya Brooks
-
Drag & Drop Emails from Outlook to SmartsheetAccepted AnswerFirst post 06/29/20,Last post 07/01/20Just recently the wonderful feature to drag & drop my Outlook email to Smartsheet is no longer working. Unfortunately, we do not have 365 so this feature was very useful in sharing information. Do I need to update something? What is di…Using Smartsheet925MMerin -
Answered - Pending Review Topher Barnett 44 views 3 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/29/20,Last post 07/02/20Hi All, I have a checklist form that fills in different columns with a status for each test that is passed or failed. Each row is a different room. If a test is failed, there is a 'Notes' column beside the test status column that gets fil…Using Smartsheet443Topher Barnett
-
Automatically work out Contract Expiry DatesAccepted AnswerAccepted Answer Steve Bertram 12 views 3 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 06/29/20,Last post 06/29/20Hi, i'm trying to write a formula that will automatically work out the expiry date of a contract any given number of years in the future. If the 'OSD' is the start date and the contract runs for 8 years this is fairly simple e.g. OSD - 01/…Using Smartsheet123Steve Bertram
-
Approval workflow validationQuestionAnswered - Pending Review Andy H 44 views 3 comments 0 points Most recent by Andy H Using SmartsheetFirst post 06/29/20,Last post 07/22/20Is there an easy way to validate that a request for approval submitted via a form is not approved by the person who created the request? My sheet contains a Contact List column from which approvers are selected. I have tried to validate th…Using Smartsheet443Andy H
-
Answered - Pending Review GregJames 22 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/29/20,Last post 07/02/20Hi there, Have been searching for a way to resolve this before posting but with no luck so far. I want to know if its possible to update the column properties based on a specific set of values from a lookup table? The column properties re…Using Smartsheet221GregJames
-
Multiple Page Reports & HeadersQuestionAnswered - Pending Review Sue Pemberton 15 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/29/20,Last post 07/01/20Hi All, I have a report that will be viewed outside of smartsheets - Hardcopy or PDF. Is there a way that I can have the column headers at the top of each page? This will obviously be slightly different depending on if the page is portrai…Using Smartsheet151Sue Pemberton
-
Answered - Pending Review Yashwant Singh 14 views 1 comment 0 points Most recent by Ben G Using SmartsheetFirst post 06/28/20,Last post 07/01/20Hi team, in smartsheet , it's possible to trigger notification on predecessor date. date is not fix, change in every month.Using Smartsheet141Yashwant Singh
-
Backups and RecoveryQuestionAnswered - Pending Review Ryan W 36 views 2 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/28/20,Last post 06/29/20I am an admin at my company and I was instructed to actually just log in as my manager, the owner of our smartsheet account, and do everything from his account. Well he unfortunately got let go the other day. I have reached out to a dif…Using Smartsheet362Ryan W
-
Half Donut ChartQuestionAnswered - Pending Review Vickie Lim 25 views 4 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/27/20,Last post 07/01/20I wanted to make a half donut chart that shows a count of all the status (in progress, completed, etc). I can do it easily for one sheet, how can I do it for multiple sheets. I tried creating a roll-up report of by sheet name, but all I …Using Smartsheet254Vickie Lim
-
First post 06/27/20,Last post 06/27/20Hi Smartsheet Community, In the coming weeks, we will start a transition to begin using three new email subdomains to send emails generated by our Smartsheet app; such as automated workflows, sharing, conversation notifications and passw…Using Smartsheet320Morgan Smuck
-
Permissions to only view certain rows in a large task listAccepted AnswerAccepted Answer Michelle Lamothe 15 views 8 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 06/26/20,Last post 06/29/20We have an extensive "Mastersheet" for each of our projects that contains a lot of information. We also have outside partners that we want to give permission to view only SOME of the rows in the Mastersheet. Is there a way to do …Using Smartsheet158Michelle Lamothe
-
Multiple sorts/countifs of different columnsAccepted AnswerAccepted Answer Ben Scholz 34 views 6 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 06/26/20,Last post 06/29/20Hello - new user here! I have a new sheet with ~200 rows with ~25 columns. I have created a form to feed data into the sheet and that is working great. A few of those columns include creator name, department, category, and a few other 'm…Using Smartsheet346Ben Scholz
-
Approval via a formQuestionAnswered - Pending Review Gillian Pritchard 13 views 1 comment 0 points Most recent by RossL Using SmartsheetFirst post 06/26/20,Last post 06/26/20I have set up a form for adding new projects to a sheet but we would like this be approved before adding the rows. Couldn't see this as an option on the form so i've tried via setting up a workflow for when rows are added to be approved bu…Using Smartsheet131Gillian Pritchard -
Do Personal Settings apply to all sheets you are shared to?Accepted AnswerAccepted Answer David SCOTT Johnson 14 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 06/26/20,Last post 06/29/20If I change my Personal settings, not to receive notifications for Sheet Changes and Reminders, does that apply to every sheet I am shared-to.. or only the Sheet I was logged into, when I changed my Person Settings?Using Smartsheet143David SCOTT Johnson
-
Answered - Pending Review acunningham95401 13 views 1 comment 0 points Most recent by Ben G Using SmartsheetFirst post 06/26/20,Last post 06/29/20Hi all, I have come across an issue. I have a dummy project I created with the parent/child formatting management has agreed on (Project/Parent; Task/Child). This lives in row 1-8 of our sheet. The idea is that when a new project is crea…Using Smartsheet131acunningham95401
-
conditional formating is not workingAccepted AnswerAccepted Answer Amanda Gann 22 views 6 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 06/26/20,Last post 06/26/20Hello! I am unable to determine what is preventing this simple conditional formatting rule to apply to my sheet. There are two in the image below. The orance/emergency request works perfectly. I was able to confirm that the common issue o…Using Smartsheet226Amanda Gann
-
Auto update columns across sheetsAccepted AnswerAccepted Answer Victor van R 22 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 06/26/20,Last post 06/29/20Hi, I use a form to collect details from participants. This goes in a participants sheet (1). The name and the country of residence (and none of the other collected information) I want to use in another sheet (2) and add some other colum…Using Smartsheet223Victor van R
