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
-
First post 10/03/18,Last post 08/06/20In Chrome, the scroll bar works when you manually drag it but does not work while using the mouse. The manual dragging is a reasonable workaround but would be nice to be able to use the scroll around on the sheet without the scroll bar. …Using Smartsheet885Melissa Campbell
-
Answered - Pending Review Ishtiaq Mustafa 15 views 1 comment 0 points Most recent by [email protected] Formulas and FunctionsFirst post 08/06/20,Last post 08/06/20Hi All, I have parents and children items in my smartsheet. Some of the parent items have children under them. When I use =AVG(CHILDREN()) it gives me average % complete for each parent item. However I would like to get a total %complete …Formulas and Functions151Ishtiaq Mustafa -
Answered - Pending Review Rennel Apolinares 19 views 2 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 08/05/20,Last post 08/06/20Hi, I have this weird case where Smartsheet automation suddenly changes the details in my data which triggered other automation that it shouldn't have because it was already acted upon. See figure below: (Image) As you can see, there is …Using Smartsheet192Rennel Apolinares
-
Formula Help!Accepted AnswerAccepted Answer Mandy Maleta 16 views 8 comments 0 points Most recent by Mandy Maleta Formulas and FunctionsFirst post 07/21/20,Last post 08/06/20I'm creating a dashboard that contains some metrics. I have my metric worksheet already setup and have pulled over info. I'm needing a particular formula and cannot seem to figure it out. Here is what I'm working with: I need to search one…Formulas and Functions168Mandy Maleta
-
First post 06/28/18,Last post 08/06/20Hi I wonder if anyone might be able to shed some light on an issue I'm experiencing. I'm a new Smartsheet user so I could well be doing something wrong or expecting Smartsheet to work in a way that it doesn't. I'll set out the issue below…Using Smartsheet4666Andy Skinner
-
Answered - Pending Review Anthony Carabbio 12 views 1 comment 0 points Most recent by SoS | Dan Palenchar Formulas and FunctionsFirst post 08/05/20,Last post 08/06/20Our company works in two week chunks we call iterations. Using the following formula in Excel I am able to calculate what the current iteration is. However when I import from Excel Smartsheet doesn't appear to like the formula. Using the c…Formulas and Functions121Anthony Carabbio
-
Cascading DropdownsQuestionAnswered - Pending Review Stacey Harvey 14 views 1 comment 0 points Most recent by SoS | Dan Palenchar Using SmartsheetFirst post 08/06/20,Last post 08/06/20Is there a way to do the cascading drop downs without having to have multiple columns? I know there is away to display different fields on a form, but I only want to restrict the items displayed in a single dropdown based off a response in…Using Smartsheet141Stacey Harvey
-
Accepted Answer Brian Cianciolo 10 views 1 comment 0 points Most recent by Brian Cianciolo Using SmartsheetFirst post 08/06/20,Last post 08/06/20I have a daily reports grid and everyone in my team must complete a form everyday. If by 3 on any given day they have yet to do this, I want an email reminder sent to them. Is this possible? Thanks in advance!Using Smartsheet101Brian Cianciolo
-
Move Rows ErrorQuestionAnswered - Pending Review alexis.ray89371 16 views 5 comments 1 point Most recent by Genevieve P Formulas and FunctionsFirst post 08/05/20,Last post 08/06/20Hi, This workflow used to work fine. I moved some sheets into a different workspace and now it won’t work no matter what I do. I have deleted the workflow and recreated and it still is not working. Has anyone seen this error or know how …Formulas and Functions165alexis.ray89371
-
updating cell linksQuestionAnswered - Pending Review Robert Schlichting 10 views 2 comments 0 points Most recent by Robert Schlichting Premium Apps and IntegrationsFirst post 08/06/20,Last post 08/06/20is there a way to make a sheet wide change of links to another sheet? I have a pair of sheets I use with one being a data collection, and the second is used for creating visuals. I then use both sheets repeatedly for client work. -- …Premium Apps and Integrations102Robert Schlichting
-
Answered - Pending Review pamela.moss89851 24 views 2 comments 0 points Most recent by pamela.moss89851 Premium Apps and IntegrationsFirst post 08/05/20,Last post 08/06/20We have built a training request and tracking system for our employees in Smartsheet. Badges are displayed when an employee completes recommended training milestones. Since I could not discover how to display an image based on formulas, I …Premium Apps and Integrations242pamela.moss89851
-
Can Zapier update a row when the row has a status change and new rows are being inserted from a formQuestionAnswered - Pending Review JHand 22 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 07/24/20,Last post 08/06/20Apologies for the lengthy question - challenging to explain succinctly! I am attempting to build a fairly complex partner onboarding & setup workflow in Smartsheet. At the beginning of the workflow sales completes a Smartsheet 'Partne…Using Smartsheet221JHand
-
Next earliest date after todayAccepted AnswerAccepted Answer Chris Carroll 15 views 3 comments 0 points Most recent by MCorbin Formulas and FunctionsFirst post 08/06/20,Last post 08/06/20Need help with a formula for this. I have a column of end dates. It should be showing this 8/12 date but I cant get it to show up. (Image)Formulas and Functions153Chris Carroll
-
Answered - Pending Review Corey Fletcher 11 views 3 comments 0 points Most recent by Corey Fletcher Formulas and FunctionsFirst post 08/06/20,Last post 08/06/20I am looking for a formula that will calculate the % of projects completed on time when the actual complete date is on or before the scheduled complete over a rolling 12-month period and the Project Status is Completed. The rolling 12-mont…Formulas and Functions113Corey Fletcher
-
Answered - Pending Review Priscilla Awad 9 views 4 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 08/05/20,Last post 08/06/20I am trying to create a formula to change a Date column to update to the current date when another column has been changed. I have used the TODAY function within IF but this updates the current date every time the sheet is opened and saved…Formulas and Functions94Priscilla Awad
-
Answered - Pending Review Julia C Peterson 6 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 08/06/20,Last post 08/06/20Hi, When there is a workflow to copy a row to another sheet, why does the copied row sometimes appear down at the bottom of the sheet, leaving ~50 completely empty rows in-between the last row or text? I know technically smartsheet must b…Using Smartsheet61Julia C Peterson
-
Question Claire Owen-Schubnell 9 views 0 comments 0 points Started by Claire Owen-Schubnell Using SmartsheetFirst post 08/06/20,Last post 08/06/20When I upload an attachment to a comment in the Proofing window, the attachment does not come through when the reviewer opens the Proof Review window. I'm trying to use this as a workaround for the fact that Proofing doesn't support audio/…Using Smartsheet90Claire Owen-Schubnell
-
Form AutomationQuestionAnswered - Pending Review Jason McGuire 17 views 5 comments 0 points Most recent by Stefan Using SmartsheetFirst post 08/03/20,Last post 08/06/20Hi, Not sure if this can be done. I've created a form that I want to send to users. Ideally, one person would fill in the name of the project, then through automation, send the form on for other users to continue filling out (with the pr…Using Smartsheet175Jason McGuire
-
Answered - Pending Review Sborror 13 views 2 comments 0 points Most recent by Sborror Formulas and FunctionsFirst post 08/06/20,Last post 08/06/20I'm trying to basically show sr. mgnt how many high project projects are all happening at the same time -- ideally I'd like to count them -- is there an easy way to do that? Essentially I'm using project type = High then want to show thos…Formulas and Functions132Sborror
-
I want to create a formula that would dispute 1 out of 3 message depending upon the content.QuestionAnswered - Pending Review Bolz Oke 20 views 2 comments 0 points Most recent by Bolz Oke Formulas and FunctionsFirst post 08/05/20,Last post 08/06/20I currently have a formula grabbing the data from the CCTV Warranty Expire cell and if it's less than today's date, it's displaying "Out of Warranty" in the CCTV Warranty Status column. If it's greater than today's day, it will …Formulas and Functions202Bolz Oke
-
First post 08/14/19,Last post 08/06/20Is there a way to get pop up message saying there is a duplicate entry of the line u entered through form. Something avoids duplicate entry.Using Smartsheet1979prathap.krishnashetty69881
-
Use of Coloured SymbolsAccepted AnswerAccepted Answer Nigel Michell 16 views 4 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 08/05/20,Last post 08/06/20I have two columns that use formulae to calculate whether a Task is on budget based on the hours worked over the Revised Hours. The first column uses RYG balls whereas the second column uses RYG 3-state arrows. The first column displays t…Formulas and Functions164Nigel Michell
-
Accepted Answer Geoffrey Kemp 8 views 2 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 08/05/20,Last post 08/06/20I'm trying to create a formula for a report that references another sheet but it needs to reference and check two columns. My crude formula below to illustrate: =COUNTIF ((RefSheet1Range1)="Windows Server" AND (RefSheet1Range2){…Formulas and Functions82Geoffrey Kemp
-
Alerts not sendingQuestionAnswered - Pending Review Jonathan Bartlett 46 views 7 comments 0 points Most recent by Daniel Pearson Using SmartsheetFirst post 04/28/20,Last post 08/06/20I'm setting up an alert using and expect it to come into my inbox immediately. I'm not getting anything. The details are: Trigger = "When rows are changed" and specifying the column and "changes to" value Run workflo…Using Smartsheet467Jonathan Bartlett
-
How do I add "last updated" to a dashboard?Accepted AnswerAccepted Answer SuzanneH 201 views 15 comments 0 points Most recent by Becky Horton Using SmartsheetFirst post 01/09/20,Last post 08/06/20I have a dashboard widget linking to a group of different smartsheets. I would like to add the last updated date (and name would be great too) so that the viewer will know if updates have been made without clicking into the sheet. What i…Using Smartsheet20115SuzanneH
-
Jörg Schmidt Novum Hospitality 6 views 0 comments 0 points Started by Jörg Schmidt Novum Hospitality Using SmartsheetFirst post 08/06/20,Last post 08/06/20Hallo together, I love the conversation functionality. Unfortunately, there is only a tiny indication what process the dialogue belongs to, i.e. at the end of the conversation at the bottom. The reference should be bigger and in the subje…Using Smartsheet60Jörg Schmidt Novum Hospitality
-
COUNTIFS and Date RangeAccepted AnswerAccepted Answer Lindsay Wilson 24 views 2 comments 0 points Most recent by Lindsay Wilson Formulas and FunctionsFirst post 08/04/20,Last post 08/06/20Hi I'm wondering if anyone can help. My formula below works great, but I want to adjust what's included in this count. For this count I want to filter on current date date from a range in a column (Current Due Date). e.g. date range 30/0…Formulas and Functions242Lindsay Wilson
-
Bi-directional sheet linking?Accepted AnswerAccepted Answer Brian Bertlin 10 views 3 comments 0 points Most recent by Brian Bertlin Using SmartsheetFirst post 08/05/20,Last post 08/06/20Is there anyway to bi-directly link two cells or rows between two sheets so if an change is made in either sheet, it is replicated to the other sheet? I found a similar question that was asked in 2015 that stated there was no way but chec…Using Smartsheet103Brian Bertlin
-
Question Maxwell Gren 11 views 0 comments 0 points Started by Maxwell Gren Premium Apps and IntegrationsFirst post 08/06/20,Last post 08/06/20I tried to follow the article to migrate power bi collection to power bi embedded (msdn article here). However, I got stuck very quickly. For example, in our app, we use these nuget packages (Microsoft.PowerBI.Api and powerbi.core), and th…Premium Apps and Integrations110Maxwell Gren -
Approval FlowQuestionAnswered - Pending Review nkosikhona.msani89271 17 views 17 comments 0 points Most recent by nkosikhona.msani89271 Using SmartsheetFirst post 08/03/20,Last post 08/06/20Hi There, I have developed an approval workflow with 5 different approvals in series, that is the second approver will only approves once the first approver has approved, the third approver will only approve once the second approver has a…Using Smartsheet1717nkosikhona.msani89271
