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
-
IF Formula IssueAnswered QuestionFirst post 03/27/20,Last post 03/27/20Hey all! This is so simple but having issues. I want to show "1" "2" or "3" for "Low" "Medium" "High" =IF([Level of Change]@row, = Low, "1", IF([Level of Change]@row, =…Formulas and Functions123NBudd -
Sumifs Adding multiple criteriaAnswered QuestionAnswered bradleyesmith86431 14 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/27/20,Last post 03/27/20Good morning, I am trying to add up total hours of a {Project Type} Column if the project type contains the following: Implementation, Implementation - Small Market, and ELD Implementation =SUMIFS([Hours Worked]:[Hours Worked], Date:Dat…Formulas and Functions145bradleyesmith86431 -
managing supply chain riskUnanswered QuestionFirst post 03/27/20,Last post 03/27/20Do you have a template that could be used to manage supply chain risk? What template could be used in order to properly manage it?Using Smartsheet110bzgryzek -
How to count incomplete tasks using % Complete?Accepted AnswerAccepted Answer Thomas Yonker 12 views 4 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/26/20,Last post 03/27/20Hi, I've got a project I've imported from MSProject, and my smartsheet has a % complete column. I'm trying to use COUNTIF to identify the number of tasks that are unstarted, those that are complete, and those that are in progress using th…Formulas and Functions124Thomas Yonker -
Does COUNTIFS work with only 2 conditions?Answered QuestionAnswered Avantika Murthi 15 views 2 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/27/20,Last post 03/27/20Ive been trying to add multiple conditions in to calculate some values for my Sheet Summary, but I cant seem to add more than 2 conditions. Each of them work individually & with 2 conditions, but when i add the third condition it alway…Formulas and Functions152Avantika Murthi -
Protecting Folders From Admins In WorkspaceAnswered QuestionAnswered Jonathan Forrester 9 views 2 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 03/27/20,Last post 03/27/20I have template folders in a Workspace that either gets edited or deleted by Admins. I cant make them editors because then they cannot make folders and edit other documents that they need to work with. Is there a way to make it so certain …Using Smartsheet92Jonathan Forrester
-
Hide details in a sheetAnswered QuestionAnswered Yashwant Singh 25 views 10 comments 0 points Most recent by Lititia Briggs API & DevelopersFirst post 03/16/20,Last post 03/27/20I am working on a sheet which contain multiple country wise data. i will share sheet to all country wise reviewer to update information.. i want to hide sheet data and show only respected country data to end user.. how's is possible.??API & Developers2510Yashwant Singh
-
SUMIF/SUMIFS based on criteriaAnswered QuestionAnswered Jessintha Nathan 9 views 3 comments 0 points Most recent by Debbie Sawyer Formulas and FunctionsFirst post 03/27/20,Last post 03/27/20Hi! How do I sum a specific category (Primary Column) with reference to a separate sheet. I keep getting multiple errors: https://us.v-cdn.net/6031209/uploads/332/RGPFM8JD7HIF.pngFormulas and Functions93Jessintha Nathan
-
Formula to clear in certain fields of a rowAccepted AnswerAccepted Answer Marla Berge 13 views 5 comments 0 points Most recent by Marla Berge Using SmartsheetFirst post 03/26/20,Last post 03/27/20I have a smartsheet for a workflow. If at some point there is a change order, then the workflow needs to start back at the beginning and most of the populated cells need to be cleared out. Is there a formula to make this automatically ha…Using Smartsheet135Marla Berge
-
End of Month FunctionAccepted AnswerAccepted Answer amiller66941 9 views 7 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/26/20,Last post 03/27/20Good afternoon all, I'm trying to figure out how to apply the =EOMONTH(A1,0) from excel into a smartsheet. Any guidance on this would be most appreciated! Thanks!Formulas and Functions97amiller66941
-
Formula for COUNTIFAccepted AnswerAccepted Answer rymurph 29 views 25 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/23/20,Last post 03/27/20We have a form for tracking sick time. Employee must fill out the form on first day of sick. They have to fill out the same form again when they return to work. These are both tracked in the Status column (Sick and Returning). We a…Formulas and Functions2925rymurph
-
Can update requests not be combined by recipient?Accepted AnswerAccepted Answer Dustin Shuman 7 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 03/27/20,Last post 03/27/20While I understand the benefits of a sheet's workflow combining multiple rows into 1 update request, if the email field for all of those rows match, is there a way to not combine and send an email per row, meaning a user may get multiple e…Using Smartsheet71Dustin Shuman
-
First post 03/27/20,Last post 03/27/20Hello all, I have created a data sheet with KPI's for our team members (non-licensed users). I have created a dashboard so they could see their personal KPI's but I don't want them to have access to the full table, for confidentiality reas…Using Smartsheet613Jacques Frein
-
Julia C Peterson 7 views 0 comments 0 points Started by Julia C Peterson Premium Apps and IntegrationsFirst post 03/27/20,Last post 03/27/20Is there any way to see what data on a sheet has been updated/modified after a datauploader run?Premium Apps and Integrations70Julia C Peterson
-
First post 08/18/18,Last post 03/27/20Has anyone created worksheets to keep track of Client tasks for an accounting Practice? Trying to keep up with all of the assignments and tasks in one central placeUsing Smartsheet593Bal - CPA -
Countif a cell is blank or dated before a dateAnswered QuestionFirst post 03/26/20,Last post 03/27/20Hi all I'm pulling my hair out trying to figure out the correct way of writing a Countif a cell is either blank OR contains a date before a date referenced in a different column. I've been playing around with =COUNTIF({DateClosed},OR(ISBLA…Formulas and Functions199s_mawer
-
OR in SUMIF functionAnswered QuestionAnswered Sharareh Zand 8 views 2 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/27/20,Last post 03/27/20Hello, I am trying to use OR in SUMIF function as below but get invalid operation error: =SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]83) + SUMIFS({Q1 '20- LE}, {Group}, [P…Formulas and Functions82Sharareh Zand
-
Accepted Answer Marla Berge 11 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 03/26/20,Last post 03/27/20I have a column that is a multiple contact column and when I add multiple contacts, it adds that all on the same row, how do I get the names to be displayed 1 name per line withing the cell?Using Smartsheet113Marla Berge
-
First post 07/18/18,Last post 03/27/20Hi, We would like to customize our smartsheet form in order to create an online opprtunity for Forum registration. For this purpose, we need to add the logos of our company and that of our partner. Would you please inform us how this ca…Using Smartsheet4538Sepi Deh -
First post 03/27/20,Last post 03/27/20I have one case，want to mark the origin value，for example: https://us.v-cdn.net/6031209/uploads/002/28PCFK7G2AA6.png How can I do this?Formulas and Functions91Florence Li
-
First post 03/27/20,Last post 03/27/20Hello all, I have created a data sheet with KPI's for our team members (non-licensed users). I have created a dashboard so they could see their personal KPI's but I don't want them to have access to the full table, for confidentiality reas…Using Smartsheet71Jacques Frein
-
Calculating 13 weeks moving averageAnswered QuestionAnswered Jessintha Nathan 21 views 3 comments 0 points Most recent by Jessintha Nathan Formulas and FunctionsFirst post 03/21/20,Last post 03/27/20Hi! How do I calculate 13 weeks average for a series of data in a column? I need the formula to detect every incremental week add of data. Thank you!Formulas and Functions213Jessintha Nathan
-
First post 03/24/20,Last post 03/27/20As a single mom- and full-time employee, COVID-19 brought unique challenges to our household. I both wanted to keep my kid's education progressing while maintaining progress at work. I quickly realized we needed a schedule to maintain san…The New Work/Life Reality702@crystalrmorey -
Deleting a UserAnswered QuestionFirst post 03/25/20,Last post 03/26/20Why is it when I delete a user that they are still included in Workflows? Wouldn't it make sense that if a user is deleted, that they be deleted from everywhere in Smartsheet? Why must I manually remove that person from every workflow in e…Using Smartsheet176Ken
-
First post 03/26/20,Last post 03/26/20Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your orga…The New Work/Life Reality140Hunter Reed -
Approval Workflow: Rejection "Alert Someone" not workingAnswered QuestionFirst post 03/21/20,Last post 03/26/20Hello, I am running a 3 stage approval process. If stages 2 or 3 REJECT the approval I have it setup to "Alert" the Stage 1 approver. https://us.v-cdn.net/6031209/uploads/336/JFIGJVM0XUBR.png I have triggered the workflow now 3 …Using Smartsheet235Geoff Baker
-
First post 03/26/20,Last post 03/26/20I am trying to pull my data from Excel into Smartsheet and have it to have multi-select columns. I am attaching my Word doc with the descriptions and images to explain. I cannot figure out how to get that document to post nicely in this w…Using Smartsheet90TeriOWY
-
First post 04/06/18,Last post 03/26/20Dear All, Our program consists of 5 sub projects and each of them have their plan. All of these individual plans need to be rolled up into a consolidated master plan that would finally track the inter-dependencies and the critical path. …Using Smartsheet359Taru
-
Accumulative Formula required for daily cadence?Accepted AnswerAccepted Answer chris.italiano78351 18 views 9 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 03/25/20,Last post 03/26/20Good Morning Hope someone can help me. I want to keep track of the accumulative total for each spreadsheet. For example see below - Tomorrow when i enter in Thursdays actual data of 5 - i would like: The bottom total to add up to Target to…Formulas and Functions189chris.italiano78351
-
Cost Code Verification-Budget vs. ActualsAccepted AnswerAccepted Answer Clint Stitser 9 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 03/25/20,Last post 03/26/20Hello Everyone, I build budgets in Smartsheets and then import actuals from our accounting department, provided on an excel sheet, which I then manually manipulate and upload to a different sheet in Smartsheets. Then I have a few differen…Using Smartsheet93Clint Stitser
