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.
Community Platform
Discussion List
-
First post 01/15/20,Last post 01/22/20I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…Using Smartsheet223poweb048 -
Answered xnickeddlemanx 28 views 5 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/17/20,Last post 01/20/20Hi Community, I am working with an INDEX MATCH formula to return content from another sheet; however, for each unique value, there are 4 duplicates. For example, an associate completed 4 learning events all attached to the same cohort na…Formulas and Functions285xnickeddlemanx
-
First post 08/15/18,Last post 01/20/20I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!Using Smartsheet695Sgiovinazzo
-
Stephanie Boulanger 48 views 0 comments 0 points Started by Stephanie Boulanger Welcome to the CommunityFirst post 01/10/20,Last post 01/10/20As we have now fully migrated over to our new community platform, you may see old posts being flagged as "new". Please follow the below steps to mark the entire forum or specific categories as "read". To mark the entire…Welcome to the Community480Stephanie Boulanger -
First post 07/24/19,Last post 01/10/20Getting an unparseable error when i do this: =COUNTIFS(DESCENDANTS([Final and Locked]824, 1)) Basically, I just want it to automatically count the number of checkboxes in the next column so when new children are added by other users, I d…Formulas and Functions323movieloverron
-
tcanelli41471 50 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 03/15/18,Last post 01/09/20Is there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by differe…Premium Apps and Integrations503tcanelli41471
-
First post 08/21/18,Last post 01/08/20Has anyone received this error message before? What are the options for large data? (Image)Using Smartsheet819David Skinner -
First post 12/05/19,Last post 12/05/19I have an individual account which allows me 10 sheets. If I decided to delete a sheet after use will that restore 1 back to my remaining sheets???Using Smartsheet241jmussells
-
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions402KDub618
-
First post 11/25/19,Last post 11/28/19hi team, I need help with removing the overheard data from the Smartsheet api call that returns a json file, I need to remove all the overhead before putting the data into the pipelines, thanks. (Image)API & Developers261somer
-
First post 10/03/19,Last post 11/26/19Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use …Formulas and Functions49928lcamacho19911 -
First post 11/17/19,Last post 11/22/19I have a Master SmartSheet from which I pull new rows into a SmartSheet Report. That works fine for Report users who are safe to have access to all the information in the Master SmartSheet. However, I have other users who need some row dat…Using Smartsheet141thomasbeaty111566
-
First post 11/06/19,Last post 11/20/19Hello Community, Heads up that we’re getting ready to make some updates to the experience here that will make it easier for you to find and share information. When we do that, we’ll need to make the site read-only for a period of time. …Announcements327Shaine Greenwood -
First post 11/20/19,Last post 11/20/19So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have…Formulas and Functions394NaNa
-
First post 01/20/17,Last post 11/14/19are there any Biotech or Pharma companies using Smartsheet that I can speak with regarding setting system up. Our finance group set the system up to track POs & Invoices, however Clinical needs the system to incorporate timelines and …Archived 2017 Posts303100
-
First post 11/12/19,Last post 11/13/19Hello all - I am building a dashboard and wanted to include a few charts. However, my charts come up fuzzy, regardless of size. See below. These are pretty nicely sized on my dashboard and still showing blurry. I saw from a post in N…Using Smartsheet232SophieKelly1
-
First post 10/29/19,Last post 11/06/19Hello, I have a master vendor list sheet that contains a checkbox column for vendor type. I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked. I need a separate sheet so I can use…Formulas and Functions166MJeffers
-
First post 06/11/18,Last post 10/30/19Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the same. We as a company would strongly…Using Smartsheet899Nathiele
-
First post 11/20/18,Last post 10/30/19I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…Formulas and Functions949UnaB
-
First post 05/01/19,Last post 10/28/19Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them…Using Smartsheet1402Jef Forward -
First post 03/16/18,Last post 10/28/19There have been a handful of occasions now where we load Smartsheet and it looks nothing like it should. Rows get mixed up with no pattern to discern why. Luckily, I had someone take screen shots of what it looked liked before so we could …Using Smartsheet199Preston -
First post 10/23/19,Last post 10/25/19Dears, Writing on the community as I am not getting any feedback on the support tickets. Our Malaysian department (both our co-workers + local customer) is logging in but not able to work as the sheets are not loading - see screenshot…Using Smartsheet134Mitch Van Riel
-
First post 07/15/19,Last post 10/24/19I've done some research, so I'm pretty sure I already know the answer. I have a project with a hard completion date. I would like to have any subtask scheduled backward from the completion date. Can that be done in Smartsheet?Using Smartsheet575Kawika59
-
First post 10/17/19,Last post 10/21/19How do i change the data source of a metric widget? You can 'add data' but this adds a new one. In my particular use case we can now copy and paste widgets between dashboards, however this is no way to edit the data, ie use the widget …Using Smartsheet487GregPeters
-
First post 10/17/19,Last post 10/18/19I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in t…Formulas and Functions709Allison Caskey
-
First post 10/10/19,Last post 10/16/19Hey there community! I have been working on this formula for a few days now and it just won't fly. I think the "<>Closed" is what is throwing it off? I have tried all sorts of varieties of syntax (<>"Closed&quo…Formulas and Functions1611rclerico
-
First post 06/27/19,Last post 10/16/19I'm having a problem creating an approval flow. When the approver denies the flow, it automatically sends an email to the one who requested the approval asking him to clear the wrong field. I need that after the field is arranged the …Using Smartsheet343jfabio94151
-
First post 10/14/19,Last post 10/14/19Hi, We manage Intake to Archive in Smartsheet. Our Intake Sheet (source sheet), where we collect all project info, is rather lengthy. When an Intake Request has been approved, I want the row to be moved to an Implementation Sheet (desti…Using Smartsheet223Ute
-
First post 10/11/19,Last post 10/13/19I am working on a presentation for our exec team about my experience out at Engage 2019. Does anyone remember the name of the company that spoke during the keynote speech about how they used Smartsheet to get resources organized & on t…Using Smartsheet194Sarah Renken
-
First post 10/10/19,Last post 10/11/19Hi! I am trying to find a formula to check a box Done when several other cells are checked done. Such as Master Task=done when Task 1, Task 2, Task 3 and Task 4 are checked done. My If Then formula doesn't seem to work. Any thoughts? =…Formulas and Functions184egrime
