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 Lakshman . 24 views 2 comments 0 points Most recent by Lakshman . API & DevelopersFirst post 05/21/20,Last post 05/26/20I am trying to generate a report based on the responses, but when i map those answers in the PDF. I am getting populated as below. does any one has a solution for this? https://us.v-cdn.net/6031209/uploads/EE7L2ADYB5Y7/image.pngAPI & Developers242Lakshman . -
First post 10/23/19,Last post 05/26/20Our PM's are experiencing a few issues with the Gantt Chart, and I hoping someone can help. In some instances, per the attached, the overall status suggests that the program is ahead of schedule. This is despite Sub-child 2a being on targ…Using Smartsheet1772Richard Heath
-
autofill of formulas is not working when adding more than one line of data without saving the sheetQuestionAnswered - Pending Review Joachim Mund 16 views 4 comments 0 points Most recent by Joachim Mund Formulas and FunctionsFirst post 04/14/20,Last post 05/26/20I have a sheet with some formulas. If I add a new row of data ,the formulas are autofilled as expected. If I add another row of data, the formulas are not autofilled. If I save the sheet after adding the first row of data, the next new row…Formulas and Functions164Joachim Mund
-
First post 07/25/18,Last post 05/26/20I'm trying to include a report on a dashboard, but I can't seem to figure out a way to freeze columns when the report is on the dashboard. Is there a way to do this? Any suggestions are greatly appreciated.Using Smartsheet1254MattRuggles -
Data Uploader- Mapping issueQuestionAnswered - Pending Review James Roberts 43 views 3 comments 0 points Most recent by Craig Brandt Premium Apps and IntegrationsFirst post 04/01/20,Last post 05/26/20I am trying to set up a new data uploader routine and when I get to the "mapping" section, it pulls up a blank page. https://us.v-cdn.net/6031209/uploads/857/7XG4LUMGFCO4.jpg https://us.v-cdn.net/6031209/uploads/714/4GQHDFTJ046M.…Premium Apps and Integrations433James Roberts
-
Answered - Pending Review jeflanne 12 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/26/20,Last post 05/26/20How do I auto populate a column when a new row is added?Using Smartsheet121jeflanne
-
Answered - Pending Review Matt Hanberry 13 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/26/20,Last post 05/26/20Hi I have set up automation on a sheet to email spacific people when lines are added, some of them have complained they are not recieving the emails and when i looked into the Activity Log it shows User Unsubscribed from Automated Workflow…Using Smartsheet131Matt Hanberry
-
COUNTIFSAccepted AnswerAccepted Answer Marilen.Navarro103391 26 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/24/20,Last post 05/26/20Hello, Hope you can help me. How do you use Countifs formula using the table below? https://us.v-cdn.net/6031209/uploads/NG4WRS9283SD/image.png 1 ) I need the count per month, per name of the person who bought it. There's only two names…Formulas and Functions263Marilen.Navarro103391 -
Accepted Answer Scott Peloquin 15 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/21/20,Last post 05/26/20I need help creating the formula to calculate the number of days an item is past due based on my Status column. The Status column contains the drop-down selection of “Complete”, “Not Started”, and “In Progress”. I want the calculation to r…Using Smartsheet155Scott Peloquin
-
Display Logo at the sheet levelAccepted AnswerFirst post 05/26/20,Last post 05/26/20Hi, is there a possibility to display 2 logos at the sheet level? I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspace. But what I am trying to d…Using Smartsheet126rcabral -
Answered - Pending Review Amanda Berta 19 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/22/20,Last post 05/26/20Hi, I noticed when using Index match on auto generated numbers something weird happens. On sheet A I use Index({desired result Sheet B}, match(sheet A @row, {search Criteria Sheet B},0),1) where Sheet A @Row is an auto generated number an…Using Smartsheet193Amanda Berta
-
Count If greater than or equal to 30 days from today?Accepted AnswerAccepted Answer nmazardw 19 views 10 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/21/20,Last post 05/26/20Hello, I am trying to find how many dates are greater than or equal to today that are past 30. I missing something the function isnt working. Formula — =COUNTIF([Account Corrections]:[Account Corrections]), ">=TODAY(-30)")Formulas and Functions1910nmazardw
-
Count FormulaAccepted AnswerAccepted Answer jgneely72151 30 views 14 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/21/20,Last post 05/26/20Hello! I am tracking assignments and a person can have more than one assignment. I need to be able to count the number of persons assigned on the sheet but don't want to count dupes. The fields are "First Name" and "Last…Formulas and Functions3014jgneely72151
-
Summary Report FormulaQuestionAnswered - Pending Review Lisa_Doris 17 views 6 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/22/20,Last post 05/26/20What is the formula for this scenario: I have laborers working at different job addresses, I want to calculate the total cost by Laborer Name and by each Job Address in a summary report. Below is the data. The result I am looking for woul…Formulas and Functions176Lisa_Doris
-
Form from one sheet populates another sheetAccepted AnswerFirst post 04/17/20,Last post 05/26/20Hello SS gurus, I am relatively new to SS "in the field", although I've watched over 20 hours of videos from the SS Learning Center so I have a good understanding of the mechanics. Here is what I'm trying to do... We need to t…Using Smartsheet9531Paul Grim
-
Answered - Pending Review Senthil Anandarangan 18 views 3 comments 0 points Most recent by Sean Morgan API & DevelopersFirst post 05/22/20,Last post 05/26/20I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?API & Developers183Senthil Anandarangan
-
Custom auto-number systemAccepted AnswerAccepted Answer Jessica Howell 12 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/15/20,Last post 05/26/20We would like to create a reference, auto- number system that takes the Facility ID entered, and the date of incident, to look something like this. (####- 05/15/2020) Does anyone know if its possible to do this? Thanks in Advance!Formulas and Functions125Jessica Howell
-
Alerts based on lookupQuestionAnswered - Pending Review David Hull 5 views 2 comments 0 points Most recent by David Hull Formulas and FunctionsFirst post 05/26/20,Last post 05/26/20I have a column in a sheet which is a Multi Select Dropdown with a number of roles listed. I want to set up alerts to individuals, sending them the rows in which their role is mentioned. The email addresses relating to each role are held i…Formulas and Functions52David Hull
-
First post 05/21/20,Last post 05/26/20Hi, Im trying to count the children of column [Estimado Importe Total] but I just want to count the values if the condition in column [Estatus Factura] says "Pagada", if not I just want to skip that row and count the rest of the…Formulas and Functions143Sylvia Elizabeth
-
How do I move the start date of a project on gantt chart so that tasks move back accordingly?QuestionAnswered - Pending Review Andrew Horscroft 19 views 9 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/12/20,Last post 05/26/20Hi, The start date of a project has been postponed. Can I move the start date of the project so that all tasks and dependencies move back accordingly? ThanksUsing Smartsheet199Andrew Horscroft
-
Answered - Pending Review Hoang Vo 22 views 1 comment 0 points Most recent by Sean Morgan API & DevelopersFirst post 05/20/20,Last post 05/26/20If I have a link such as the one below. How do I access a published sheet via API? What is the url and sheet ID to access? https://app.smartsheet.com/b/publish?EQBCT=xxxxx I gave this a try and it didn't work. https://api.smartsheet.com/…API & Developers221Hoang Vo
-
Answered - Pending Review ALAIN-STEPHANE 16 views 3 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/22/20,Last post 05/26/20Hi all , I have set a timeline report in which a today's line is displayed ( doted line ) , but when I insert the report in a dashboard , this line is no longer displayed . Can you help me ? Thank you in advance !Using Smartsheet163ALAIN-STEPHANE -
Networkdays, Error?Accepted AnswerAccepted Answer Jason P 19 views 8 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/19/20,Last post 05/26/20I'm running =NETWORKDAYS([Date Submitted]22, (TODAY())) which counts how long a design request has been in the Dept. In some cases the count is correct, based on today as 19th May 2020, yet in other cells it's out by a day or more? I've co…Formulas and Functions198Jason P
-
Using colum % completeQuestionAnswered - Pending Review JOSE IBANEZ 8 views 6 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/22/20,Last post 05/26/20Hi, I would like to know how I can assign the porcentage in the % complete column. If my stage has a duration of 20 days and I want to assign for each day%.Using Smartsheet86JOSE IBANEZ
-
Answered - Pending Review Stefano Ferretti 11 views 4 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/26/20,Last post 05/26/20Hi All, I need some help with a countifs functions I want the formula to provide me with the count of the cells that contain a specific text. Is there a way to point directly to the cell that contains that text rather than spell it out ? …Formulas and Functions114Stefano Ferretti
-
Answered - Pending Review smitzel99941 14 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/23/20,Last post 05/26/20We use dashboards extensively with remote teams. Most people have no problem accessing and seeing information correctly on the mobile app. I have one person, the President, that see the numeric percentage scale differently on his phone. No…Formulas and Functions141smitzel99941
-
Signatures on FormsQuestionAnswered - Pending Review Warren Labuschagne 14 views 5 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/25/20,Last post 05/26/20We would like to get employees to sign after they have been asked some questions via a Form. The Form will be filled in on an iPad or phone by Site Foreman and then the employee would need to sign acceptance. Is there a way to do this?Using Smartsheet145Warren Labuschagne
-
First post 08/13/19,Last post 05/26/20I created a Blueprint in Control Center that I do not want to use. Can I delete? I have searched and do not see a way to delete it.Using Smartsheet732Dee Barnard -
First post 05/26/20,Last post 05/26/20Hello Community, I'd like to filter the grid view to only show all predecessors for the current task. I thought this would be similar to filtering the grid view fro the Critical Path, but this doesn't seem to an option. is there a way to d…Using Smartsheet120Alan Praysman
-
Verifying Created by Column with Manager Email ColumnAccepted AnswerAccepted Answer Don Williams 13 views 2 comments 0 points Most recent by Don Williams Formulas and FunctionsFirst post 05/24/20,Last post 05/25/20I'm trying to show verification for a contact email address to match the "Created by" field generated by Smartsheet to ensure an entry/request is valid/accurate. Can someone help me out with this? Essentially flagging people wi…Formulas and Functions132Don Williams
