Using Smartsheet
Archives for June 2020
Discussion List
-
Time line displayQuestionAnswered - Pending Review wsguerin 14 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 Smartsheet147wsguerin -
Answered - Pending Review Jeremy Jones 15 views 4 comments 0 points Most recent by Cat Werbeck Using SmartsheetFirst post 06/30/20,Last post 07/13/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 Smartsheet154Jeremy Jones
-
Answered - Pending Review Elsie Rockers 16 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 Smartsheet161Elsie 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 26 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 Smartsheet261Yashwant Singh
-
Answered - Pending Review Laura Montagno 12 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 Smartsheet122Laura Montagno
-
Answered - Pending Review Saroja Hanasoge 11 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 Smartsheet113Saroja Hanasoge -
using SUMIF / SUMIFSQuestionAnswered - Pending Review Cameron McGregor 16 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 Smartsheet163Cameron McGregor
-
Merging cells / text overflowAccepted AnswerFirst post 06/30/20,Last post 07/01/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 Smartsheet173Marijan
-
Answered - Pending Review Mitch Butler 16 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 Smartsheet163Mitch Butler
-
When using checkbox put strikethrough on row when checked?Accepted AnswerAccepted Answer Brittany Lucarell 11 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 Smartsheet112Brittany Lucarell
-
First post 06/29/20,Last post 07/13/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 Smartsheet262Gordon
-
Can order of columns be locked?QuestionAnswered - Pending Review Tanya Brooks 12 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 Smartsheet123Tanya 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 Smartsheet615MMerin -
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 32 views 2 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/29/20,Last post 07/02/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 Smartsheet322Andy H
-
Answered - Pending Review GregJames 20 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 Smartsheet201GregJames
-
Multiple Page Reports & HeadersQuestionAnswered - Pending Review Sue Pemberton 12 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 Smartsheet121Sue Pemberton
-
Answered - Pending Review Yashwant Singh 12 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 Smartsheet121Yashwant Singh
-
Backups and RecoveryQuestionAnswered - Pending Review Ryan W 23 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 Smartsheet232Ryan W
-
Half Donut ChartQuestionAnswered - Pending Review Vickie Lim 18 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 Smartsheet184Vickie 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 Smartsheet240Morgan Smuck
-
Permissions to only view certain rows in a large task listAccepted AnswerAccepted Answer Michelle Lamothe 13 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 Smartsheet138Michelle Lamothe
-
Multiple sorts/countifs of different columnsAccepted AnswerAccepted Answer Ben Scholz 27 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 Smartsheet276Ben Scholz
-
Approval via a formQuestionAnswered - Pending Review Gillian Pritchard 16 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 Smartsheet161Gillian Pritchard -
Do Personal Settings apply to all sheets you are shared to?Accepted AnswerAccepted Answer David SCOTT Johnson 11 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 Smartsheet113David SCOTT Johnson
-
Answered - Pending Review acunningham95401 14 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 Smartsheet141acunningham95401
-
conditional formating is not workingAccepted AnswerAccepted Answer Amanda Gann 24 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 Smartsheet246Amanda Gann
-
Auto update columns across sheetsAccepted AnswerAccepted Answer Victor van R 19 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 Smartsheet193Victor van R
