# Explore. Ask. Answer.

## Forum Stats

• 38,176 Members
• 20,430 Discussions
• 79,016 Comments

# 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 Richard Grimes 32 views 5 comments Most recent by Paul Newcome Formulas and Functions
First post 04/19/20,Last post 04/20/20
Hello, Please can someone help, I am using this formula to add one more criteria but it returns back saying #INVALID OPERATION, the formula works before i start using the AND to add the next criteria, and i cant see why? =SUMIFS({Cleani…
Formulas and Functions325
Richard Grimes
• Form LookupAccepted Answer
Accepted Answer James Moore 44 views 7 comments Most recent by Paul Newcome Formulas and Functions
First post 04/17/20,Last post 04/20/20
Is it possible to present a "Form" to a user, have them enter criteria. e.g. a unique customer number and then present other data to the user relating to that unique customer (e.g. the cust company name)? In other words, not prov…
Formulas and Functions447
James Moore
• Accepted Answer Karla George 23 views 3 comments Most recent by Paul Newcome Formulas and Functions
First post 04/13/20,Last post 04/20/20
I am trying to calculate employee utilization rates in smartsheet. I want to know the sum of individual employee effort (in percentage form) at any given given date in time. I have a list of current projects that has a line item for each…
Formulas and Functions233
Karla George
• Accepted Answer Tamara Sprung 34 views 8 comments Most recent by Andrée Starå Using Smartsheet
First post 04/17/20,Last post 04/20/20
I have an acct through my work. I actually have two accts. One I don't have the ability to make changes to a document unless the author gives me permission...nor do I have the ability to create a new doc. However...I do have the ability…
Using Smartsheet348
Tamara Sprung
• Answered - Pending Review Su Pi 13 views 7 comments Most recent by Andrée Starå Using Smartsheet
First post 04/17/20,Last post 04/20/20
I created a report that includes the "Sheet Name" column. The auto-generated links in this column go directly to the specific row on the sheet it's linking to. However, when I add the report as a widget on a dashboard, the links …
Using Smartsheet137
Su Pi
• Accepted Answer Corentin Dal Farra 12 views 6 comments Most recent by Paul Newcome Using Smartsheet
First post 04/20/20,Last post 04/20/20
Hello everyone, In smartsheet I tried to conifgure a workflow that launch an alert to a specific user. Does someone know if it is possible to configure an alert workflow that would be sent to someone according to his function or profil (fo…
Using Smartsheet126
Corentin Dal Farra
• Answered - Pending Review LLaCosta 11 views 4 comments Most recent by Paul Newcome Formulas and Functions
First post 04/16/20,Last post 04/20/20
We have (1) sheet that is used for basic data entry. No formulas or anything complicated. The user enters the date, start time, end time and categorizes the work they are doing by selecting a single category every task they complete. There…
Formulas and Functions114
LLaCosta
• Answered - Pending Review Rainier Hollands 21 views 5 comments Most recent by Paul Newcome Formulas and Functions
First post 04/16/20,Last post 04/20/20
Hi everyone, For my business I have multiple trucks, and every morning we record the statuses of the trucks before they start driving. I have multiple columns, each one being the different trucks. In the rows for those trucks I record the…
Formulas and Functions215
Rainier Hollands
• Answered - Pending Review Ashley Sabo 24 views 1 comment Most recent by Nathan Lloyd Premium Apps and Integrations
First post 04/17/20,Last post 04/20/20
Does anyone know if there is a way to export all workflows to identify which Salesforce fields are being used in the connector? Basically a map that identifies all the fields in Salesforce that Smartsheet touches and if its read only or re…
Premium Apps and Integrations241
Ashley Sabo
• Accepted Answer Volson 44 views 3 comments Most recent by Genevieve P Formulas and Functions
First post 04/18/20,Last post 04/20/20
Hello - I am trying to sum a grant \$ amount when one column is marked "Yes" to COVID-19 Related and the other column is either marked "Approve" or "Approve-Repurpose". I can't seem to figure it out. Can som…
Formulas and Functions443
Volson
• Accepted Answer SteCoxy 23 views 7 comments Most recent by Paul Newcome Formulas and Functions
First post 04/16/20,Last post 04/20/20
Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my fi…
Formulas and Functions237
SteCoxy
• Accepted Answer sahilhq 13 views 1 comment Most recent by Paul Newcome Formulas and Functions
First post 04/18/20,Last post 04/20/20
Hey, Can anybody please suggest me with a formula that would calculate the average time a person takes to close an action assigned to him in a row? I have attached below the layout of the sheet. The formula should calculate the start of t…
Formulas and Functions131
sahilhq
• Answered - Pending Review Melisa Dannhauser 56 views 1 comment Most recent by Paul Newcome Formulas and Functions
First post 04/17/20,Last post 04/20/20
Hi, I'm trying to create a table that looks up data from a list of entries based on multiple criteria. I have been able to achieve PART of my task with different formulas but can't figure out how to achieve my desired end result. I tried I…
Formulas and Functions561
Melisa Dannhauser
• Grace 1.4K views 9 comments Most recent by Paul Newcome Formulas and Functions
First post 05/01/18,Last post 04/20/20
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, &quo…
Formulas and Functions14109
Grace
• Answered - Pending Review beatea 23 views 1 comment Most recent by Etienne Mermillod API & Developers
First post 04/19/20,Last post 04/20/20
It would be perfect if I cuold simply show the Smartsheet information inside of Confluence. No need for further fancy Jira/Confluence integration which I know costs a lot of money.
API & Developers231
beatea
• Accepted Answer m_dorsey 11 views 14 comments Most recent by Paul Newcome Formulas and Functions
First post 04/15/20,Last post 04/20/20
Hello, I'm trying to determine when to start a project based on the due date and the effort. The effort exists in hours and I've converted that into days based on a 7 hour day (padding days to allow for admin/other work in a day). This is …
Formulas and Functions1114
m_dorsey
• Answered - Pending Review Shirley Pruitt 31 views 10 comments Most recent by Paul Newcome Using Smartsheet
First post 04/17/20,Last post 04/20/20
Current Formula is working based on column "Scott Tomren Approval": =IF([Scott Tomren approval]1 = "Submitted", "Hold", IF([Scott Tomren approval]1 = "Approved", "Go", IF([Scott Tomren appr…
Using Smartsheet3110
Shirley Pruitt
• Alma PM 55 views 7 comments Most recent by Andrée Starå Using Smartsheet
First post 02/08/18,Last post 04/20/20
Hello everyone I would like to know if it is possible Check the Checkbox on multiple lines together
Using Smartsheet557
Alma PM
• Accepted Answer Katie White 44 views 5 comments Most recent by Darren Richardson Formulas and Functions
First post 02/28/20,Last post 04/20/20
Can someone help point me in the right direction of where to go to submit a ticket for this? For four rows on my sheet (Row 1, 3, 4, 5) every time I save my sheet those rows update the modified date, even though I'm not touching those rows…
Formulas and Functions445
Katie White
• J. Craig Williams 35 views 4 comments Most recent by Jinn Luu Formulas and Functions
First post 02/18/18,Last post 04/20/20
A Viewer has little reason to need to see a formula in a column that is being displayed to them in a Report. Please remove the hover for the Formula (the other hover that displays the full contents (display value) of the cell is OK, just …
Formulas and Functions354
J. Craig Williams
• Answered - Pending Review Harley Esguerra 22 views 1 comment Most recent by Genevieve P Using Smartsheet
First post 04/18/20,Last post 04/20/20
Hello, I created a few filters which I would like to display in a dashboard. Is it possible to only display filtered data in a Dashboard? I cannot figure out how to do this? Help please.
Using Smartsheet221
Harley Esguerra
• Answered - Pending Review lamersrob 25 views 1 comment Most recent by Genevieve P Using Smartsheet
First post 04/17/20,Last post 04/20/20
Hi, I managed to create a column which contains the formula to count my project delays of scheduled finish vs. actual finish. I used this formula: =NETWORKDAY([Planned Finish]1, [Actual Finish]1) How can I show this in the actual GANTT bar…
Using Smartsheet251
lamersrob
• Answered - Pending Review Jennifer Kohl 12 views 1 comment Most recent by Genevieve P Using Smartsheet
First post 04/17/20,Last post 04/20/20
I would like to create a visual dashboard to show a graph of OTD, #/% Orders shipped/complete by customer, #/% orders shipped YTD by product, Orders open vs. shipped YTD, and orders shipped by month. I don't know why I am having a hard ti…
Using Smartsheet121
Jennifer Kohl
• Answered - Pending Review Christine Hunter 25 views 1 comment Most recent by Genevieve P Formulas and Functions
First post 04/16/20,Last post 04/20/20
Hello, I have a very long smartsheet list of names and emails in seperate columns. I want to join them to create a new column that turns them into a contact without having to fill out the contact card for each person. I tried =Join({na…
Formulas and Functions251
Christine Hunter
• Accepted Answer CDecker 12 views 4 comments Most recent by Andrée Starå Using Smartsheet
First post 04/08/20,Last post 04/19/20
It would be helpful to be able to filter a search to only look at a specific column in a sheet. Sometimes I know what column the info I am looking for is in but I am only able to search the whole sheet where there might be more than one in…
Using Smartsheet124
CDecker
• Accepted Answer Lee Ratzlaff 23 views 3 comments Most recent by Andrée Starå Formulas and Functions
First post 04/15/20,Last post 04/19/20
Hello! I have a project that includes three sites, and I initially decided to make three separate grids to keep everything independent. However, now I'm wondering if that was a mistake, as I would like to create a single dashboard that sum…
Formulas and Functions233
Lee Ratzlaff
• Answered - Pending Review Risto Nykanen 27 views 3 comments Most recent by Andrée Starå Premium Apps and Integrations
First post 04/16/20,Last post 04/19/20
Hello, Has anyone experience on Joget DX platform/form builder and integrated it with Smartsheet? I would be interested in hearing if it is easy to apply or a doable solution or if there are more suitable options. After viewing Joget a bi…
Premium Apps and Integrations273
Risto Nykanen
• Accepted Answer Donna T 38 views 5 comments Most recent by Andrée Starå Formulas and Functions
First post 03/25/20,Last post 04/19/20
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links dat…
Formulas and Functions385
Donna T
• Answered - Pending Review cleversheet 25 views 11 comments Most recent by Andrée Starå Using Smartsheet
First post 04/12/20,Last post 04/19/20
Smartsheet can't swallow more than 20,000 rows, but I need to check for the presence of an item on a list of roughly 100,000. Any suggestions? Specifically, in Smartsheet I want to take action on an item only if the contributor via a form …
Using Smartsheet2511
cleversheet
• FormulaQuestion
Answered - Pending Review nkosikhona.msani89271 43 views 12 comments Most recent by Andrée Starå Formulas and Functions
First post 04/15/20,Last post 04/19/20
Hi There, I have a list of requests that have dates that were created, so I want to run a report for all the requests that have been opened in the past 6 months from the date I am presenting my report on. Is there a formula I can use to …
Formulas and Functions4312
nkosikhona.msani89271