## Forum Stats

• 41,371 Members
• 22,326 Discussions

# 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

Accepted Answer Marilen.Navarro103391 41 views 1 comment Most recent by Genevieve P Formulas and Functions
First post 06/27/20,Last post 07/01/20
Hello, I need to build a sheet summary (report) for all the sum of the table below. I want to show on my Dashboard a Summary of each Status (In Progress etc....for each month... for Jose and Karlo and 5 more not included in my screen captu…
Formulas and Functions411
Marilen.Navarro103391
• Accepted Answer Dawn Skirvin 11 views 3 comments Most recent by Genevieve P Formulas and Functions
First post 06/29/20,Last post 07/01/20
=IF([% Complete]@ROW<.7, "RED"), IF ([% Complete]@ROW< 1>.7, "YELLOW"), IF([% Complete]@ROW)=1, "GREEN"),""))) If below/above certain percentages, attempting to change the ball to red/yello…
Formulas and Functions113
Dawn Skirvin
• Answered - Pending Review Shesha_K 32 views 1 comment Most recent by Genevieve P Formulas and Functions
First post 06/26/20,Last post 07/01/20
Hello Community, I am hoping someone has a suggestion for my issue. I searched the previously asked questions and couldn't seem to find it. Ultimately, I am trying to maintain one master sheet of data that populates secondary filtered shee…
Formulas and Functions321
Shesha_K
• Answered - Pending Review Mitch Butler 21 views 3 comments Most recent by Paul Newcome Using Smartsheet
First 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 Smartsheet213
Mitch Butler
• Accepted Answer Brian Becnel 12 views 2 comments Most recent by Brian Becnel Formulas and Functions
First post 07/01/20,Last post 07/01/20
I am a newbie and I'm stumped. I am trying to calculate the remaining budget for projects that have a ProjPortStat(us) as "active" in a field on the Sheet Summary (I can successfully calculate a single column where the status is …
Formulas and Functions122
Brian Becnel
• Answered - Pending Review FreezeBrew 21 views 2 comments Most recent by Genevieve P Formulas and Functions
First post 06/26/20,Last post 07/01/20
Hi, I am working on building construction scheduling. In the template of my schedule, I have a list of items with predecessors. My questions, once I marked one item as N/A or DONE(two separate check boxes), how can I make the following ite…
Formulas and Functions212
FreezeBrew
• Accepted Answer Marijan 21 views 1 comment Most recent by Genevieve P Using Smartsheet
First post 07/01/20,Last post 07/01/20
I am an administrator on an Individual Plan. On your website (link below) it shows under the heading "Automation" that I can utilise the Request an approval automation "...manage multi-step approval processes,..." (Lin…
Using Smartsheet211
Marijan
• Answered - Pending Review Elsie Rockers 27 views 1 comment Most recent by Genevieve P Using Smartsheet
First post 06/30/20,Last post 07/01/20
The 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 Smartsheet271
Elsie Rockers
Accepted Answer Tanya Brooks 11 views 3 comments Most recent by Tanya Brooks Formulas and Functions
First post 06/29/20,Last post 07/01/20
In forms or reports is ther a way for user to enter a variable? Situation: Sheet contains thouseands of employee names and corresponding information. Do not want users directly in sheet so they need to update information via report. Is …
Formulas and Functions113
Tanya Brooks
• Answered - Pending Review Jennifer Seymour 11 views 1 comment Most recent by Jason Tarpinian Formulas and Functions
First post 07/01/20,Last post 07/01/20
I want to flip a column which will be last, first names and return first last. So Doe, John becomes John Doe I can get each piece - but is there any functionality to build the string? Having a first name column and a last name column is no…
Formulas and Functions111
Jennifer Seymour
• Answered - Pending Review Jennifer Seymour 11 views 1 comment Most recent by Jason Tarpinian Formulas and Functions
First post 07/01/20,Last post 07/01/20
Is there a way to take a column: Last, First and build [email protected] Scenario: I have data that is emailed to me as a cut and paste of part of a table. I send an email using the names included in this data. I have no co…
Formulas and Functions111
Jennifer Seymour
• Answered - Pending Review Sue Pemberton 11 views 1 comment Most recent by Genevieve P Using Smartsheet
First post 06/29/20,Last post 07/01/20
Hi 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 Smartsheet111
Sue Pemberton
• Answered - Pending Review Frank H Smith 13 views 1 comment Most recent by Genevieve P Using Smartsheet
First post 06/30/20,Last post 07/01/20
I'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 Smartsheet131
Frank H Smith
• Answered - Pending Review Elaine Bye 11 views 1 comment Most recent by Genevieve P Formulas and Functions
First post 06/30/20,Last post 07/01/20
I have a report pulling data from multiple sheets. I have the report on a dashboard. I would like to be able to filter the report from the dashboard? Is this possible?
Formulas and Functions111
Elaine Bye
• Answered - Pending Review Laura Montagno 12 views 2 comments Most recent by Laura Montagno Using Smartsheet
First post 06/30/20,Last post 07/01/20
I 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 Smartsheet122
Laura Montagno
• Accepted Answer MMerin 83 views 5 comments Most recent by Genevieve P Using Smartsheet
First post 06/29/20,Last post 07/01/20
Just 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 Smartsheet835
MMerin
• Accepted Answer alexis.ray89371 11 views 2 comments Most recent by Genevieve P Premium Apps and Integrations
First post 06/30/20,Last post 07/01/20
Hi, I have a MS Flow (power automate) that adds a new row to SS when an MS Form is submitted. I have additional columns in the SS that are not in the form for formula purposes. When the Opex and Capex cost come in I think they come in as …
alexis.ray89371
• Accepted Answer Rebecca Panaccione 22 views 3 comments Most recent by Genevieve P Formulas and Functions
First post 06/25/20,Last post 07/01/20
Hello, I have a test master grid sheet where dates of leave (and different types of leave) are collected through a form. Formula used for collecting dates together is: =IF([End Date]@row <= [Start Date]@row, [Start Date]@row + &qu…
Formulas and Functions223
Rebecca Panaccione
• Count dropdown and %Accepted Answer
Accepted Answer Alessandro Terranova 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
First post 06/30/20,Last post 07/01/20
Hi Community, I am defining the following formula to count how many children cells are blank out of the total number of children cells along with the associated percentage value. In a Team schedule sheet this will count how many time slot…
Formulas and Functions113
Alessandro Terranova
• Answered - Pending Review Doyle54 12 views 9 comments Most recent by Paul Newcome Formulas and Functions
First post 06/29/20,Last post 07/01/20
I am trying to use: CONTAINS(OnePt, @cell), [OnePt]:[OnePt] Essentially I am trying to use Location - OnePt - to see if there is a record of OnePt input into a record. If I cannot use the logic, can you explain the scenario and cell in a c…
Formulas and Functions129
Doyle54
• Answered - Pending Review Emily Quick 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
First post 06/30/20,Last post 07/01/20
I am wondering if there is a way to create a formula in a cell that will tell you if the following 10-30 cells say complete. For example, when working on a project if all of the tasks beneath are "Green" or marked as "Comple…
Formulas and Functions113
Emily Quick
• Answered - Pending Review Sean Callahan 23 views 3 comments Most recent by Genevieve P Formulas and Functions
First post 06/25/20,Last post 07/01/20
As far as I can tell this hasn't been brought up recently - hoping there may be new information available. I'm trying to build a report that pulls in tasks by current user, so that the viewer sees only those tasks that apply to him/her pul…
Formulas and Functions233
Sean Callahan
• Answered - Pending Review Vickie Lim 21 views 4 comments Most recent by Genevieve P Using Smartsheet
First post 06/27/20,Last post 07/01/20
I 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 Smartsheet214
Vickie Lim
• Accepted Answer Megan.Casto 51 views 3 comments Most recent by Genevieve P Formulas and Functions
First post 06/27/20,Last post 07/01/20
I'm trying to sum a total using two criteria and it won't work. I can do the sumif for each criteria seperately but when I try to do the "ifs" one to combine the criteria it says "unparseable". I have these fields in o…
Formulas and Functions513
Megan.Casto
• Answered - Pending Review Renald Musumba Olando 12 views 2 comments Most recent by Renald Musumba Olando Using Smartsheet
First post 07/01/20,Last post 07/01/20
(Image) I am setting up a workflow that requires some locked cells to be selected. Is it possible to unlock the selected columns only instead of unlocking everything?
Using Smartsheet122
Renald Musumba Olando
• Answered - Pending Review Rob Hagan 51 views 5 comments Most recent by Rob Hagan Using Smartsheet
First post 06/13/20,Last post 07/01/20
Hi, We have been using SmartSheet for many years and have developed our entire project management around it. Every production sheet is derived from the same template. Thus, every production sheet has the same columns and many of those colu…
Using Smartsheet515
Rob Hagan
• Answered - Pending Review Chanee Batton 32 views 2 comments Most recent by Chanee Batton Formulas and Functions
First post 06/29/20,Last post 07/01/20
I am nowhere near a Smartsheet Whiz. We have a column on our main sheet titled Create Date which we input. This is the date a work order was created. I am wanting to have another column titled TAT (turn around time) which will look at the …
Formulas and Functions322
Chanee Batton
• L11CAS 138 views 6 comments Most recent by Simon Wilcock Using Smartsheet
First post 03/13/19,Last post 07/01/20
Hi  i have an approval workflow that isn't quite functioning as i'd like. It works as follows: *  A Payments Officer inputs data to a sheet and creates a row comment to add context * they then change a status column to "Awaiting App…
Using Smartsheet1386
L11CAS
• Answered - Pending Review Christine Rosenberg 51 views 11 comments Most recent by Andrée Starå Using Smartsheet
First post 03/11/20,Last post 06/30/20
I have read the help articles for enterprise customers on how to work with branding, and I understand, that I can add an URL with a customized welcome page and Help Page. However, I am very interested in seeing examples of good /best prac…
Using Smartsheet5111
Christine Rosenberg