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.
Support
Discussion List
-
First post 01/22/20,Last post 01/22/20I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) …Formulas and Functions100Michael Palko
-
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 -
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 06/27/19,Last post 01/20/20Does anyone know what happened to the Kindle Fire App? It is no longer in the app store and is now unavailable.Using Smartsheet283NBurrus -
First post 01/18/19,Last post 01/20/20We started using Smartsheet in October 2017. It WAS a great help to us for time, expense tracking and project management. We made serious gains in productivity once we figured out how to use Smartsheet for our specific needs. All was well …Using Smartsheet334[email protected] -
COUNTIFS with Due Date and StatusAccepted AnswerFirst post 01/17/20,Last post 01/17/20Hi! I've been trying to use a COUNTIFS formula to determine how many projects are 5 days out from the due date, as well as, which projects are either blank or In Progress. I definitely don't have the formula formatted correctly so it is no…Using Smartsheet213PR
-
SummaryAccepted AnswerAccepted Answer Kristie Diersen 9 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/17/20,Last post 01/17/20I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status. https://us.v-cdn.net/6031209/uploads/277/JKXO5DMT4B8I.jpg Does anyone know what would be the best way to complete th…Formulas and Functions91Kristie Diersen
-
First post 11/27/19,Last post 01/13/20We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…Formulas and Functions6314TrevorM
-
*NEW: Proofing using ReportsAccepted AnswerAccepted Answer amontemayor 43 views 20 comments 0 points Most recent by BrianBosché Using SmartsheetFirst post 10/01/19,Last post 01/10/20The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…Using Smartsheet4320amontemayor
-
Save Button For WebformsAnsweredFirst post 01/08/20,Last post 01/09/20Hello Smartsheet, I have seen multiple threads from as far back as 2015 asking for a save button for webform https://community.smartsheet.com/discussion/1909/saving-coming-back-to-a-partially-complete-web-form https://community.smartsheet…Using Smartsheet221Jia Lee
-
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 Smartsheet729David Skinner -
Calculate average durations between datesAccepted AnswerAccepted Answer Chris Walker 43 views 2 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/03/20,Last post 01/06/20I have an original sheet with hundreds of rows of information (Source Sheet) that I am looking to summarize calculations in to a second sheet (Summary Sheet), in order to feed in to a dashboard. Source Sheet has two date fields that I am i…Formulas and Functions432Chris Walker
-
Progress Bar Roll-upAccepted AnswerAccepted Answer PR 111 views 15 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/05/19,Last post 12/30/19Hello, Is there a way for the progress bar of the children rows to roll up to a parent roll where it would display the average in the progress bar form? As you can see in the screenshot, the progress bars are updated with the status of …Formulas and Functions11115PR
-
First post 07/29/19,Last post 12/29/19Hello, Is anyone else disappointed in the pricing and the lack of availability of the Smartsheet Addons/Premium Features? The features of these premium addons are pretty badass and would be useful. I feel like I would use dynamic report…Using Smartsheet265NBurrus
-
First post 11/14/19,Last post 12/27/19Hello! I have a Smartsheet that I use to track multiple data entries each day from our vendor agents. I created a form for them to fill out for each instance, and they typically have no problem adding the data to my Smartsheet. Recently…Using Smartsheet545ehodgdon
-
First post 03/14/19,Last post 12/26/19I'd like to request Smartsheet look into adding the "auto-refresh" feature, currently only available on Dashboards, to Reports. We use reports to filter columns for individuals in teams that share a sheet, but who don't need t…Using Smartsheet785Colin Entrekin
-
First post 12/17/19,Last post 12/17/19Hi, I'm looking for some help on how to eliminate some risk when team members leave the company. They are deleted as a user and sheets transferred, however these said users after they have been deleted are still able to access into Smartsh…Using Smartsheet221Jorjie Higginson
-
First post 04/30/15,Last post 12/12/19When using webforms and submitter puts in their name, if their name is already in contacts it doesn't match to contacts name. So you end up with a new name entry the same as an already existing name in your contacts column. Could they be…Archived 2015 Posts4442Mark Bonham
-
First post 12/04/19,Last post 12/08/19Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's …Formulas and Functions366lisarae723
-
First post 12/05/19,Last post 12/06/19I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box. In other words, there are two columns to include in the count from my Comm…Formulas and Functions421slilienfeld113476
-
First post 12/05/19,Last post 12/06/19I understand this is not a place to deal with indivisual cases, but as I cannot reach anyone in Smartsheet, I've decided to write here. Thought I've been trying to contact Smartsheet since mid-November either through "Contuct us"…Using Smartsheet273E Sa
-
First post 08/01/19,Last post 12/05/19Hi, There seems to issues with date formats at the moment. I've had a few client's reach out with issues and I've also seen issues from others in the community. If you're experiencing issues and If you haven’t already, I would recommend…Using Smartsheet324Andrée Starå -
First post 11/22/19,Last post 12/05/19=SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), "")) I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started …Formulas and Functions279Jason Cocco
-
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 Smartsheet211jmussells
-
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 Functions352KDub618
-
First post 12/04/19,Last post 12/04/19Is there a way to alter the Column Headers? IE Bold or Sizing or Font? I haven't seen any of these options but I just want to verify that it is truly the case.Using Smartsheet343MikeCorvin -
First post 12/04/19,Last post 12/04/19Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from …Formulas and Functions210cthrasher97141 -
First post 12/03/19,Last post 12/04/19Hi, I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and who is on call. Also, includes …Formulas and Functions231Chuck Perez
-
First post 12/03/19,Last post 12/03/19Nov 20th the ability to click on links in reports stopped working! I have submitted tickets and not a single reply or any help of any kind! Example = https://goo.gl/maps/cX1j23VBCMX1Zxde7 returns this: This site can’t be reached ht…Using Smartsheet241TJSmith
-
First post 08/07/17,Last post 12/01/19My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in E…Archived 2017 Posts202Michael.Baker
