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
-
Connecting Tableau Desktop MacQuestionAnswered - Pending Review Carlos Yanes 23 views 3 comments 0 points Most recent by Carlos Yanes Premium Apps and IntegrationsFirst post 07/30/20,Last post 08/06/20Hi all, I'm trying to connect Tableau Desktop for Mac to Smartsheet, however it seems to get stuck after entering my credentials. The problem doesn't occur on a PC and am able to connect without any issues. Any ideas on how to fix this? Th…Premium Apps and Integrations233Carlos Yanes -
change reply email on automationAccepted AnswerAccepted Answer Improve Consulting 13 views 3 comments 0 points Most recent by Improve Consulting Using SmartsheetFirst post 08/05/20,Last post 08/06/20Hi, I setup automation on my clients' smartsheets systems. Now I have many emails coming from their subcontractors who reply to me when they receive an automatic update request. How can I stop it happening for existing setups prevent it f…Using Smartsheet133Improve Consulting
-
IF statement with an OR....QuestionAnswered - Pending Review Brian Petricone 7 views 2 comments 0 points Most recent by lewis hamilton Using SmartsheetFirst post 08/05/20,Last post 08/06/20I'm pretty new to all of this, and the examples I've viewed are not helping. I have a column two columns and need a third to show a value based off the first two. If a column "grade" = "NBC" and other column has grade &…Using Smartsheet72Brian Petricone
-
Help with a SUMIF formula and a reconciliation spreadsheetAccepted AnswerAccepted Answer Mark Silvester 25 views 9 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 07/31/20,Last post 08/06/20I am trying to build a reconciliation spreadsheet that compares two sets of data. Pictured below: (Image) The first set of data with the "QBO SKU" is pulling the information correctly using the below formula: =SUMIFS({QBO – sh…Formulas and Functions259Mark Silvester
-
Ignoring Blank CellsAccepted AnswerAccepted Answer Alishia Topper 27 views 4 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 08/01/20,Last post 08/06/20How do I make this formula ignore blank cells? I want it to total the percent of YES cells to NO in a range. =COUNTIFS(CHILDREN(), OR(@cell = "YES", @cell = "No aplica")) / COUNTIFS(CHILDREN(), OR(@cell = "",…Formulas and Functions274Alishia Topper
-
is the drag and drop feature not working?Accepted AnswerAccepted Answer Brandi Fuller 131 views 11 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 06/25/20,Last post 08/06/20Hello, I often drag and drop PDFs and images from email or my computer into Smartsheet, but this function does not seem to be working as of late. I am using Outlook and Google Chrome if that matters. The only way I seem to be able to at…Using Smartsheet13111Brandi Fuller
-
Answered - Pending Review laura.buchanan 14 views 6 comments 0 points Most recent by laura.buchanan Formulas and FunctionsFirst post 08/05/20,Last post 08/06/20The formula below is working perfectly pulling the time Laura Spent on Projects, year to date. Now the boss wants, instead of year to date, he wants to display only Dates from the previous Sun - Sat. So we want our graph to always show the…Formulas and Functions146laura.buchanan
-
I have a check box for completed, I would like my Date Completed box to AUTO populate todays date whQuestionAnswered - Pending Review Tammy Parker 32 views 11 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 04/23/20,Last post 08/06/20I have a completed column with a check box. When that box is checked, I would like the Date Completed box to auto populate with Todays date. Is that possible? I tried =IF(Complete1 = 1,TODAY(),"")) but that does not work... ughFormulas and Functions3211Tammy Parker
-
Answered - Pending Review Brian Bertlin 8 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 08/05/20,Last post 08/05/20Is there a way to add content from a text cell to a dashboard via metric, report or other widget so the resulting visual on the dashboard is scrollable within the dashboard? This is to accommodate a variable amount of text in the cell from…Using Smartsheet81Brian Bertlin
-
First post 08/05/20,Last post 08/05/20Hi, I have a column with a formula that calculates the Current Step Calc in a process based on there being a date or not in a Task Started column. That part is working fine. My results look like this in the Next Step Calc and Current Step…Formulas and Functions160Jeana
-
Forms AutomationQuestionAnswered - Pending Review Oscar Dennison 10 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 08/05/20,Last post 08/05/20I have created a form and have set up an automation that sends the form link to a customer. When the customer opens the link from email the form is different than the form I created. It includes the customer email address as a drop down bo…Using Smartsheet101Oscar Dennison
-
Print row to pdfAccepted AnswerAccepted Answer Improve Consulting 23 views 2 comments 0 points Most recent by Improve Consulting Using SmartsheetFirst post 08/03/20,Last post 08/05/20Hi, I print a row to pdf (to replicate the look of the form), but would like the logo to display on the top. Can this be done? LaurenUsing Smartsheet232Improve Consulting
-
Answered - Pending Review Daniel William Maycock 56 views 6 comments 0 points Most recent by Rich Stowell Using SmartsheetFirst post 02/24/20,Last post 08/05/20I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/n…Using Smartsheet566Daniel William Maycock
-
First post 02/08/19,Last post 08/05/20How to format numbers in cells to show thousands separator and two decimal places. I tried to search , could not find any thread about this. Someone please help. I am new to smartsheet.Formulas and Functions826FazalurRehman
-
Answered - Pending Review Werner Gerstacker 24 views 16 comments 0 points Most recent by Werner Gerstacker Using SmartsheetFirst post 07/29/20,Last post 08/05/20I have an intermediate sheet with only one row that pulls the results of some calculations from my master data sheet in order create an archive entry. This intermediate sheet has an automation set up to copy the row into my archive sheet a…Using Smartsheet2416Werner Gerstacker
-
Answered - Pending Review Alex Lubow 23 views 4 comments 0 points Most recent by Alex Lubow API & DevelopersFirst post 07/27/20,Last post 08/05/20I just recently started using automate io and just recently ran into some major issues. Automate io allows you to create a bot with the trigger of 'New Row' so anytime a new row is created on a sheet, it will trigger the bot. Soon after se…API & Developers234Alex Lubow
-
Accepted Answer Michael Voth 27 views 6 comments 0 points Most recent by Michael Voth Formulas and FunctionsFirst post 08/04/20,Last post 08/05/20Hello, I am working on a construction project with a lot of RFIs and would like our issue tracking logs to reference my main RFI log. All the RFIs have unique ID #s. I want the Issue tracking logs to update the RFI # once it is updated on…Formulas and Functions276Michael Voth
-
Accepted Answer Corey Fletcher 29 views 13 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20I need to write a formula for counting active projects that are past due for a current month based on schedule complete date being in that current month and when actual complete date is blank. Project Status = Active Schedule Complete Date…Formulas and Functions2913Corey Fletcher
-
VLookup is not bring back valuesQuestionAnswered - Pending Review Gladys Liley 19 views 13 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20I am using vlookup in a master tracking sheet that is looking up Names and bring back date values in a data entry sheet. The data entry sheet is updated on a weekly basis from the same group of Names multiple times during the week so the …Formulas and Functions1913Gladys Liley
-
What is wrong with my formula?Accepted AnswerAccepted Answer Dennis Slagle 18 views 2 comments 0 points Most recent by Dennis Slagle Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20I'm trying to do multiple IF formulas to show a Green, Yellow, or Red traffic light based on a % complete column. I can get "Red" (<70%) to show by itself, "Green" (100%) to show by itself, but I can't get the yellow…Formulas and Functions182Dennis Slagle
-
First post 04/23/19,Last post 08/05/20On a shared sheet, only one person is having this pop up every time they go to save. What could be causing this? When he goes to save, it stays on the spinning wheel of "saving your data" for minutes until the error message pops …Using Smartsheet2366jmezera
-
First post 02/08/19,Last post 08/05/20Hi all, I have a smartsheet that my operations team manages. It tracks all orders that we receive through our defined shipping process. Each order is a new row and there are multiple columns. One of them is the "Estimated Shipping Da…Premium Apps and Integrations2476mabraham
-
Sumif in a RYG symbol columnQuestionAnswered - Pending Review mlanterman 16 views 10 comments 0 points Most recent by mlanterman Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20Hello, I have a formula that returns a Red, Yellow, or Green icon depending on criteria in another column. Red, Yellow or Green correspond to a priority in our work order flow. Then, in a metrics summary sheet, I have a Sumif formula ba…Formulas and Functions1610mlanterman
-
Embed Weather widgetQuestionAnswered - Pending Review kk 161 views 5 comments 0 points Most recent by Brian Cianciolo Using SmartsheetFirst post 02/19/20,Last post 08/05/20Is there any way to embed a link on my dashboard that will reflect the current weather in our area?Using Smartsheet1615kk -
Multiple IF functions NestedAccepted AnswerAccepted Answer Yeshaya 20 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/04/20,Last post 08/05/20Hello, I would like to Nest two If functions in one cell. Below is what I have, but I am receiving an error #unparseable. =IF([Sales Person 1]2667 = "Y", ([Net Profit]2667 - 100) * 0.5, IF([Commission due]2667 > 0, "0&quo…Formulas and Functions205Yeshaya
-
First post 12/05/18,Last post 08/05/20Hello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance odedFormulas and Functions9029odedL
-
Double NotificationsAccepted AnswerAccepted Answer KC Fife 14 views 1 comment 0 points Most recent by Michael Heisler Formulas and FunctionsFirst post 08/04/20,Last post 08/05/20I have a work flow set up for vacation requests at our company. This is what happens: Enter information on a form Form is sent to relevant project Manager for approval If approved it is copied to another sheet to populate a calendar view o…Formulas and Functions141KC Fife
-
Answered - Pending Review Jamie Bedford 70 views 13 comments 0 points Most recent by Jamie Bedford Formulas and FunctionsFirst post 05/14/20,Last post 08/05/20The "Smartsheet Formula Examples" template, while very helpful, appears to have a variety of issues with cell references that have been moved over time. Somewhere around row 26 things start to get weird. Is this only on my copy o…Formulas and Functions7013Jamie Bedford
-
Answered - Pending Review Melissa Richardson 11 views 1 comment 0 points Most recent by Paul Newcome API & DevelopersFirst post 08/05/20,Last post 08/05/20I´m using the barcode scan function in a form to enter the barcode. However, when I do the scan an extra character , ', is entered in front of the number. So instead of the number 10345470605 being entered, '10345470605 is entered instea…API & Developers111Melissa Richardson
-
Answered - Pending Review Marilin Campos 20 views 3 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 08/04/20,Last post 08/05/20My sheet can contain several rows belonging to the same vendor. I want to send an email notification that includes all of those rows to the vendor, instead of sending multiple email notifications with only one row of information. I've sear…Using Smartsheet203Marilin Campos
