Recent Discussions
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Answered - Pending Review Nick Rozaklis 24 views 3 comments 0 points Most recent by Nick Rozaklis Formulas and FunctionsFirst post 08/06/20,Last post 08/07/20Hello! I have a list of 38 objects (planes, trains, automobiles, what have you...) and I want to find out what the percentage complete is for either based on status. Is there a way for me to gather a total % complete based on status? For …Formulas and Functions243Nick Rozaklis -
First post 06/03/19,Last post 08/07/20I am attempting to do the following. If the "Completed" column has a check, in the checkbox, I would like the % Complete column to read 100% Here is the formula I thought would work using task 4.of the project. =IF(Complete…Formulas and Functions1903chicago25624 -
Activity log disappearedQuestionAnswered - Pending Review Sander K 12 views 2 comments 0 points Most recent by Sander K Using SmartsheetFirst post 08/03/20,Last post 08/07/20Hello All I have this issue with one of my sheet, where the activity log is empty. It looks like this: (Image) The sheet is months old, but last week it stopped showing the log, it only shows my views the same day I view it and nothing mor…Using Smartsheet122Sander K
-
Accepted Answer Gillian Pritchard 8 views 1 comment 0 points Most recent by Sean Morgan Using SmartsheetFirst post 08/06/20,Last post 08/07/20I am wondering is there a way to make sure your piecharts are the same size on dashboard?Using Smartsheet81Gillian Pritchard -
First post 08/07/20,Last post 08/07/20I have been using automation workflow but there is no trigger for proofing. When will it be made available?Using Smartsheet60Lee Li Chuan
-
Answered - Pending Review Nav 15 views 3 comments 0 points Most recent by Stefan Formulas and FunctionsFirst post 08/05/20,Last post 08/07/20Hi everyone - So i am trying to find a way to sum values in cells containing both number and text like "1 Macbook Pro, 2 Lenovo Tiny PC, etc. and give me the total for each item type in the totals column. Please see the screenshot of…Formulas and Functions153Nav
-
Answered - Pending Review youngdonkey 35 views 5 comments 0 points Most recent by youngdonkey Using SmartsheetFirst post 07/31/20,Last post 08/07/20Hi, not sure if others are aware, but Smartsheet is not accessible from China right now. We have a major issue with one of our global customer's Chinese employees unable to update project information in Smartsheet. Hoping the community can…Using Smartsheet355youngdonkey -
Merge headingsQuestionAnswered - Pending Review vipa2000 28 views 2 comments 0 points Most recent by vipa2000 Using SmartsheetFirst post 08/04/20,Last post 08/07/20I know that smartsheet does not allow merging of headings and understand why. However, I have a number of headings say 20. This 20 are made of 4 phases - say 5 each. Is there any work around other than putting Phase 1 as a prefix in the 1s…Using Smartsheet282vipa2000
-
Preview files and URLsQuestionAnswered - Pending Review stuartr 13 views 2 comments 0 points Most recent by stuartr Using SmartsheetFirst post 08/06/20,Last post 08/07/202 questions 1) is there a way to preview files and attachments? - I dont seem to have this option (see below) (Image) 2) is there a way of previewing URLs (much in the same way as slack) that provides a little more information before the u…Using Smartsheet132stuartr
-
WebEx TeamsQuestionAnswered - Pending Review bcase24986 30 views 4 comments 0 points Most recent by Christina Dominguez Using SmartsheetFirst post 06/10/20,Last post 08/06/20Are there help articles related to Smartsheet's integration with WebEx Teams? We have been able to create a BOT within WebEx Teams and complete the connection between Smartsheet and WebEx, however, only at a person level and we have a tea…Using Smartsheet304bcase24986 -
Answered - Pending Review Jennifer Ives 17 views 2 comments 0 points Most recent by Jennifer Ives Using SmartsheetFirst post 08/05/20,Last post 08/06/20I am requesting contact information via form which are later used in approval workflows. The form works perfectly, and the contact name is supplied to the sheet, but it does not appear as contact. Our contacts are managed via administrator…Using Smartsheet172Jennifer Ives
-
First post 06/09/20,Last post 08/06/20Hi , I deleted nearly all of one of my projects rows in error. There was no way to undo or put the data back. How do i fix this? I have exported the activity log into a CSV but I don't seem to be bale to re-import. Any ideas - HELP?Using Smartsheet303John Vickers -
Answered - Pending Review Sara Downing 12 views 1 comment 0 points Most recent by Bill Brendle Formulas and FunctionsFirst post 08/06/20,Last post 08/06/20I am trying to automate the "Status" column to display the following based on the "Original Action Due Date" column: Coming due in greater than 60 days - Green Coming due in 60 days - Yellow Past due - Red I am also try…Formulas and Functions121Sara Downing
-
Prefill Form with a Date ColumnQuestionFirst post 08/06/20,Last post 08/06/20Hey Smartsheets Community! I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arranged dates but only allow for a single sel…Using Smartsheet60Nate Roylance
-
Live Data Connector - Download Smartsheet To ExcelAccepted AnswerFirst post 08/05/20,Last post 08/06/20Hi there, Do you know if the Live Data Connector by smartsheet, can be used to automatically download Smartsheets to excel? Or is there another way to auto download Smartsheets to excel? Anyone, Please assist. Thank you!Using Smartsheet166A Rose
-
Question Nikki McIntosh 13 views 0 comments 0 points Started by Nikki McIntosh Formulas and FunctionsFirst post 08/06/20,Last post 08/06/20Hello and please help! I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows as headers that sh…Formulas and Functions130Nikki McIntosh
-
First post 08/03/20,Last post 08/06/20Hi, The Goal: Use index match to return a column name based on which column in a given range has the maximum value of that range. (Image) The problem: I can only get 1/5 of my return options to work, and only when I add 1 as 'column in…Formulas and Functions274Gen Ireland
-
Can you help with a counting formula question?Accepted AnswerAccepted Answer Jeffrey Metivier 24 views 4 comments 0 points Most recent by Jeffrey Metivier Formulas and FunctionsFirst post 08/06/20,Last post 08/06/20Hi - I'm trying to create a count if formula that will include Bid Stage from one column and either of Open or On Pause criteria from another column. This is what I tried =COUNTIFS({2020.3.31 Antitrust MA Subgroup Chart Range 2},"B…Formulas and Functions244Jeffrey Metivier
-
Admin PermissionsQuestionAnswered - Pending Review Donna T 9 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 08/06/20,Last post 08/06/20I have full admin permissions for our organization in Smartsheet. A sheet owner accessed a template and began using it; she is the owner. I did notice that her sheets are in a folder at the same level, but not within our workspace. I'…Using Smartsheet91Donna T -
Answered - Pending Review mgriffin 17 views 6 comments 0 points Most recent by mgriffin Formulas and FunctionsFirst post 07/29/20,Last post 08/06/20I need to auto-assign tasks in a round robin style (i.e. the assignment goes to the next person 'in line' in the contact list). Is there a way to do this with a formula? I understand that tasks can be auto-assigned based on criteria in a s…Formulas and Functions176mgriffin -
Answered - Pending Review mlanterman 24 views 4 comments 0 points Most recent by mlanterman Using SmartsheetFirst post 08/03/20,Last post 08/06/20Hello, I have a need to sort two columns, both ascending (works in Grid View) but that sort order is not staying for every column when I switch to card view. The business goal is to sort by workstation, then by the priority of work order…Using Smartsheet244mlanterman
-
How to Match Regions to States in a ColumnAccepted AnswerAccepted Answer Donna Stuart 13 views 13 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 08/06/20,Last post 08/06/20I am creating a sheet that needs to identify the "region" based on the "state" in the preceding column. I've tried multiple formulas and get back an error message (unparseable). What am I missing? =IF([State]1=ny,nj,ct,…Formulas and Functions1313Donna Stuart
-
Stopping Automatic Update RequestsAccepted AnswerAccepted Answer Maria Watters 12 views 2 comments 0 points Most recent by [email protected] Using SmartsheetFirst post 08/05/20,Last post 08/06/20Hello, I have many automatic update requests throughout a smartsheet; however, is there a way to create an automation that cancels the update requests without me having to go into each row and manually cancel them?Using Smartsheet122Maria Watters
-
Conditional Sum FormulaQuestionAnswered - Pending Review Anoop Mishra 6 views 1 comment 0 points Most recent by Michael Heisler Formulas and FunctionsFirst post 08/06/20,Last post 08/06/20(Image) Hello, I am trying to insert a formula for extended price of projects that auto calculates for close rating of A, B and C. Any help is much appreciated.Formulas and Functions61Anoop Mishra
-
First post 08/06/20,Last post 08/06/20Setup I am using, Form to Data Sheet to KPI Sheet to Dashboard. Data is entered into Form, then it populates the sheet correctly. I have the entries separated by 1/4 of day, with them being called Q1, Q2, Q3, Q4. This is done with some …Using Smartsheet70Jason Gunnells
-
Answered - Pending Review Steven Mazurek 9 views 1 comment 0 points Most recent by SoS | Dan Palenchar Using SmartsheetFirst post 08/06/20,Last post 08/06/20Have many reports pulling from a master sheet which are functioning correctly. But when this report is viewable on a Dashboard, the preview window is not showing the Primary Column values...? In fact, the dashboard report preview is showin…Using Smartsheet91Steven Mazurek
-
Answered - Pending Review Rajeev Kumar 9 views 1 comment 0 points Most recent by SoS | Dan Palenchar Using SmartsheetFirst post 08/06/20,Last post 08/06/20Hi I have data entry from which is used by one group of people to punch in data. I have created the form for that which sits on a smartsheet. I want to use the same form to retrieve the data (row) in the same form, so that another group ca…Using Smartsheet91Rajeev Kumar
-
Concatenate, Join, and IndexQuestionAnswered - Pending Review R Brown 8 views 2 comments 0 points Most recent by R Brown Formulas and FunctionsFirst post 08/05/20,Last post 08/06/20I am looking for a way to pull data from Sheet A into a helper sheet, concatenate and join the data, and then push the result into Sheet B. Sheet A might have 1 parent row and up to 10 children or 1 parent only or any combination thereof. …Formulas and Functions82R Brown
-
VLOOKUP/IF or INDEX/MATCH?Accepted AnswerAccepted Answer Hannah H 12 views 6 comments 0 points Most recent by Hannah H Formulas and FunctionsFirst post 08/05/20,Last post 08/06/20Hello, I'm not sure which combination of formulas I require (VLOOKUP, IF, INDEX, MATCH...) In sheet 1 I have the columns "resource name" (text) and "onboarding paid?" (check box) In sheet 2 I have the columns "res…Formulas and Functions126Hannah H
-
First post 08/05/20,Last post 08/06/20In my Inventory System I have an Order Request sheet that captures order info by completing a Form. Once that order is filled it is automatically moved to an Order Fulfilled sheet using Automated Workflows. However, sometimes we can only…Using Smartsheet152SLUGGO
