Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
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 Joshua Lewis 28 views 3 comments 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 01/15/20,Last post 01/22/20I have a Smartsheet that will have values inputted each week and I would like to calculate an historical rolling average based on the last four weeks. What formula would I use to calculate this rolling average? Example data (Assuming c…Formulas and Functions283Joshua Lewis -
Answered Darren Mullen 35 views 2 comments 0 points Most recent by Darren Mullen Formulas and FunctionsFirst post 01/17/20,Last post 01/22/20Hi, I have a sheet with project workflows. Each workflow has an ID# and they have indented rows. I have a form that enters new rows into the top of the sheet. Everything is working fine as far as auto-filling all the gnarly formulas I…Formulas and Functions352Darren Mullen
-
First post 11/08/18,Last post 01/22/20There is a little disclaimer on Smartsheet's article about automated alerts under using double bracket placeholders. Has anyone experienced this happening to them? NOTE: Adding placeholders to your messages may possibly result in you rece…Using Smartsheet289SYSPK -
Question vs. DiscussionAccepted AnswerFirst post 01/21/20,Last post 01/22/20Hello. With the change of the Community Forums, I am seeing less activity on several of my submissions. Can someone explain the difference between, "Ask a Question" and "Discussion?" I have been submitting issues as &qu…Using Smartsheet223M. David
-
Automatic numbering for Work Breakdown StructureAccepted AnswerAccepted Answer ALAIN-STEPHANE 25 views 11 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 01/21/20,Last post 01/22/20Hello , Does " Automatic numbering for Work Breakdown Structure " exist in SMARTSHEET ? It's been a couple of days now that I am searching for . Can someone help me ?Using Smartsheet2511ALAIN-STEPHANE -
First post 01/15/20,Last post 01/22/20I'm using Smartsheet for recording software QA test results. There are some tests that when/if they pass, as indicated by a checkbox, that pass should cascade to pass other tests. The other tests may be in one or more other test groups: Te…Using Smartsheet352siouxzie7
-
Alessandro Terranova 16 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 01/20/20,Last post 01/22/20Hi Community, I am in the process of creating a new Team workflow and I would really appreciate to discover how to easily import Trello Custom Fields into Smartsheet. I am aware of the Trello import procedure https://help.smartsheet.com/…Premium Apps and Integrations163Alessandro Terranova
-
First post 01/21/20,Last post 01/22/20I have a checkbox column that is used when a project and any of it's tasks are Active. I have another checkbox column that is used when a project and/or any of it's tasks are Done. I have another column that will generate the date when th…Using Smartsheet142Angie Hatfield -
First post 01/22/20,Last post 01/22/20I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need t…Using Smartsheet131sdonnelly -
First post 01/20/20,Last post 01/22/20In Smartsheet, there is a function called Countif(CHILDREN([reference])). This is a great formula but what if I wanted the count of children based on more than 1 condition? I searched in the knowledge base, but couldn't find either a 'coun…Formulas and Functions311Stephane
-
FormAnsweredFirst post 01/21/20,Last post 01/22/20I created a form some months ago and I need to expand it now by some columns, but the update just doesn't show for the user who is filling in the form. Can anybody help? Thanks!Using Smartsheet163Mareike
-
Issues when opening a sheetAnsweredFirst post 01/22/20,Last post 01/22/20Hi, In certain sheets, where many conditional formatting rules, workflows and functions are set, every time I open the sheet it colors all rows in red and it offers me the option to save my changes although nothing has changed in the sheet…Formulas and Functions61Amit Dahan
-
First post 11/27/18,Last post 01/22/20I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one op…Formulas and Functions39516Dajah
-
Answered Rishabh Ghuwalewala 20 views 3 comments 0 points Most recent by Genevieve P. Using SmartsheetFirst post 01/17/20,Last post 01/22/20Hello Smartsheet Community, I am planning on sending out a form periodically (every 2 weeks) requesting certain users to feed in the tasks they have performed for that period. I was hoping to set each response as a child row, while the per…Using Smartsheet203Rishabh Ghuwalewala -
SUMIF by Vendor and DateAnsweredFirst post 01/17/20,Last post 01/22/20I am new to Smartsheets and cannot figure out the formula for a particular SUMIF. Basically, I need the total by Vendor & Year. I have an incredibly long list of invoices that I've imported into Smartsheets, and want to be able to use …Formulas and Functions253cnikkih
-
Track Cell IncreasesAnsweredFirst post 01/22/20,Last post 01/22/20How can I track when the numbers in a cell increase? We have cells that fluctuate all the time. They contain SUMIF formulas that pull from another sheet. I'd like to know when a cell increases- not just if it changes at all. Is this possi…Using Smartsheet61SYSPK
-
First post 02/04/19,Last post 01/22/20We are having issues with pages loading and submitting forms. The following message is returned. I emailed support. Anyone else having issues? This page isn’t working app.smartsheet.com didn’t send any data. ERR_EMPTY_RESPONSEUsing Smartsheet3410Angie Hatfield
-
First post 08/10/18,Last post 01/22/20Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come i…Using Smartsheet476RossL
-
First post 08/13/19,Last post 01/22/20I see that there are 2 choices of 4 Status Colours: Green, Yellow, Red, Blue (or Gray). Could we get an option for 5 Status Colours? Blue - Not Started Green - In Progress Yellow - At Risk Red - Behind Schedule Gray - Completed Than…Using Smartsheet514Michael Reinhardt
-
Formula with multiple equationsAnsweredAnswered Meaghan Dunn 13 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/21/20,Last post 01/22/20I'm trying to convert a fairly simple formula from excel into one of sheets that has multiple equations in it and can't seem to find the one that works best. formula in excel would be =(B45*B46)+B45Formulas and Functions131Meaghan Dunn
-
First post 01/21/20,Last post 01/22/20Is there a way to hook into Smartsheet to load a custom CSS file? Or even bootstrap? Smartsheet has tremendous power but its visual appearance is very static. Especially in dashboards. The ability to be able to punch up the graphics, se…API & Developers91jamieG -
Portal Publish View - editingAccepted AnswerFirst post 01/21/20,Last post 01/22/20Hi Good afternoon We have a shop management portal that we were making revisions to the sheets directly in the portal home page now we cannot and this comes (attached). How do we change this so we can edit sheets right from the dashboard…Using Smartsheet94BESP10 -
First post 04/25/18,Last post 01/22/20Any one know if we can set auto email comments, instead of manually email comment? Thanks in advanced! (Image)Using Smartsheet4813Vaynard
-
Answered Julio Martinez Coronado 12 views 1 comment 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/21/20,Last post 01/22/20Hi, I'm using a template and it already allow me to flag a column when At Risk. I would like to count how many items I have flagged, but i'm not sure how. I've used =SUMIF({Sheet - Request Tracker with Form Range 1}, "Red") =C…Formulas and Functions121Julio Martinez Coronado
-
Duration between Military TimeAnsweredAnswered Brittany Hajicek 21 views 7 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/21/20,Last post 01/21/20What is the easiest formula to use to determine the time difference between two Military Times? I'm using the 4 digit military time and also I need the formula to calculate across midnight. I'd like the time difference to be in minutes (bu…Formulas and Functions217Brittany Hajicek
-
Need to add ISBLANK to a formulaAccepted AnswerAccepted Answer Stephanie Stewart 13 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/21/20,Last post 01/21/20Good morning, To determine the status of a row, I have the following formula (in the Status) column: =IF(Complete1 = "Yes", "COMPLETED", IF(Complete1 = "Cancelled", "CANCELLED", (IF(TODAY() >= [Du…Formulas and Functions133Stephanie Stewart
-
IF NOT ISBLANK helpAnsweredAnswered Zachary Mitchell 19 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/21/20,Last post 01/21/20I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patien…Formulas and Functions193Zachary Mitchell
-
First post 01/20/20,Last post 01/21/20Hello, I am using the following formula to represent health color for individual rows: =IF([Start Date]40 > TODAY(), "Blue", IF(AND([% Complete]40 < 1, [End Date]40 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), &q…Formulas and Functions144Adam Fink
-
First post 05/31/18,Last post 01/21/20I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files. Savin…Using Smartsheet1293Carly Sorensen -
First post 01/25/19,Last post 01/21/20Hey team I have been using SmartSheets since day one and I continue using it. I have a question about a report that I have built. I have a report that I have built that pulls in all my projects plans title ROW 1 based on a where clause fo…Using Smartsheet395Kelly.Brady76386
