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
-
Accepted Answer Shawnob1 15 views 4 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 05/21/20,Last post 05/27/20I am trying to add a value to a cell if a checkbox is checked. The cell I am trying to add to is already populated with an existing value. I want to add the two for a new value. If Lift check box is checked then add $467.50 to revenue ce…Formulas and Functions154Shawnob1 -
Answered - Pending Review Mike Mahoney 24 views 3 comments 0 points Most recent by Genevieve P Premium Apps and IntegrationsFirst post 05/21/20,Last post 05/27/20The app is displaying Section titles and taking up valuable vertical space. and it looks unprofessional as they have no purpose for being there. Please help if you can. https://us.v-cdn.net/6031209/uploads/9ZLPCOIY6RGJ/sheet-example.jpg ht…Premium Apps and Integrations243Mike Mahoney
-
Dynamic ViewQuestionAnswered - Pending Review Carolina Asensio 7 views 1 comment 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 05/27/20,Last post 05/27/20Hello, I created a Dynamic View yesterday (and saved it) and today when I accessed Dynamic View App it appeared as if I had no views at all. I also shared it with a co-worker and she did not receive an email. I re-did the view today and …Premium Apps and Integrations71Carolina Asensio
-
First post 02/26/18,Last post 05/27/20Is there any way to include the auto-numbering field on a web form so that users entering into the form have a reference number unique to their input?Using Smartsheet836neil39191
-
Accepted Answer Carolina Rivera 14 views 4 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/22/20,Last post 05/27/20Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both co…Formulas and Functions144Carolina Rivera
-
Dynamic Data Validation with Columns from another GridAccepted AnswerAccepted Answer Benjamin Hatmaker 9 views 4 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/26/20,Last post 05/27/20Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that …Using Smartsheet94Benjamin Hatmaker
-
Answered - Pending Review Shahara Anderson 26 views 5 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 05/21/20,Last post 05/27/20Hello, I am having an issue inserting a new in SMARTSHEET when a new form is created. I receive the following error. I was able to correct the other errors, but I at a loss on this particular error. Any help is definitely appreciated. …Premium Apps and Integrations265Shahara Anderson
-
First post 04/29/19,Last post 05/27/20Hi, Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email. LaurenUsing Smartsheet557Improve Consulting
-
First post 05/27/20,Last post 05/27/20Hi, In smatsheet how to create year wise dashboard. User select year and chart graph change dynamically as per year data.. it's possible using smartsheet ?Using Smartsheet90Yashwant Singh
-
Aging and Status in SmartsheetQuestionAnswered - Pending Review Mariniel Bautista 48 views 3 comments 0 points Most recent by Joo Tat Teoh Formulas and FunctionsFirst post 02/06/20,Last post 05/27/20https://us.v-cdn.net/6031209/uploads/924/HXIA25O2UKAM.png Above is a part of Service Request Database. May I know the formula for the following? Aging: The current formula I'm using is Today Column minus Start of Aging Column. May I kn…Formulas and Functions483Mariniel Bautista -
Tracking and Prefill InvoicesQuestionAnswered - Pending Review Andy Nix 13 views 4 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/22/20,Last post 05/26/20In the past 5 months of using Smartsheet we have implemented and change many things in our company. One of the most efficient for us would be Automation of Invoices. Does anyone happen to know if there is a template that will convert the I…Using Smartsheet134Andy Nix
-
First post 12/19/18,Last post 05/26/20Over the past couple of days, I have searched and read every article and even solicited help from SS and have worked myself in a circle. I have a drop-down list (Submitted, Approved, Declined), I need to "auto-populate" a date c…Formulas and Functions15317DENVER DEWEES
-
Accepted Answer Linda F 24 views 3 comments 0 points Most recent by Werner Gerstacker Formulas and FunctionsFirst post 05/22/20,Last post 05/26/20I need help on a formula for Project Assignment when a dollar amount is what determines who gets a Project assignment. For example, A Facilities coordinator will get a project if it falls between $5k - $24,999 Project Manager A will get…Formulas and Functions243Linda F
-
% pleaseQuestionAnswered - Pending Review JOSE IBANEZ 22 views 9 comments 0 points Most recent by JOSE IBANEZ Formulas and FunctionsFirst post 05/13/20,Last post 05/26/20Hi, I need help for to use % Thanks, JoluibaFormulas and Functions229JOSE IBANEZ
-
First post 05/26/20,Last post 05/26/20Hi, I'm looking to adjust my sheet based on one person having multiple jobs in one day. What I'd like to do it have it be that each person has only one job per day. Ideally, SS would be able to look at all other jobs this person is assigne…Using Smartsheet160Ben Cutler
-
Sharing to organizationQuestionAnswered - Pending Review Sean_H 20 views 5 comments 0 points Most recent by Sean_H Using SmartsheetFirst post 05/14/20,Last post 05/26/20Hello! I was wondering, is it possible to share a Smartsheet Report to everyone in the organization for editing? I'm using the 'Current User' Report parameter to limit what the user is looking at and what can be edited. But updating User G…Using Smartsheet205Sean_H
-
Answered - Pending Review Wendy Young 25 views 2 comments 0 points Most recent by Wendy Young Using SmartsheetFirst post 05/20/20,Last post 05/26/20Good morning, I'm calculating the completion progress for a project with weighted values on individual tasks. However, it's only calculating 50% of the actual progress. This is the formula that I'm using: =AVGW(PROGRESS:PROGRESS, [WEIGHT…Using Smartsheet252Wendy Young
-
Formula to restrict the parent row status from being complete unless all child rows are completeQuestionAnswered - Pending Review Heather Garner 11 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/26/20,Last post 05/26/20I need it to also take into account that some don't have child rows. Here is the formula I'm using, however, when a row doesn't have any child rows it is triggering a not started result. Could someone assist? Any help would be much appr…Using Smartsheet111Heather Garner
-
Answered - Pending Review Amy Evans2 12 views 10 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 05/26/20,Last post 05/26/20Hello, https://us.v-cdn.net/6031209/uploads/ZEOMK8837EUM/sumif.png In the attached image, I want to only SUM up rows with "DONE" in the Status Column. I want to sum up by month so I want to add the values in Story Points column …Formulas and Functions1210Amy Evans2
-
Answered - Pending Review Danielle D'Alessandro 13 views 3 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 05/26/20,Last post 05/26/20=IF(AND(% Complete]3 < 1,[End Date]3 < TODAY()), "On Time", IF(AND([% Complete]3 < 1,[End Date]3 = TODAY()), "Due", IF(AND([% Complete]3 < 1,[End Date]3 > TODAY()), "Past Due","Complete&quo…Formulas and Functions133Danielle D'Alessandro
-
CountIf NOT equal to 100%QuestionAnswered - Pending Review Jennifer Flanagan 15 views 6 comments 0 points Most recent by [email protected] Using SmartsheetFirst post 05/26/20,Last post 05/26/20How do I create a CountIf function for all cells that DO NOT equal 100% under a percent complete column? I tried the both of following but they do not work: =COUNTIF [% Complete]:[% Complete], <> =1) =COUNTIF [% Complete]:[% Complet…Using Smartsheet156Jennifer Flanagan
-
Calendar Export and "Time" Scheduled TransferringAccepted AnswerAccepted Answer Anna Henson 19 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 05/12/20,Last post 05/26/20Hi all! I am experiencing difficulty exporting the calendar view of my sheets into Outlook or Google Calendar (I have tried both) and the time transferring with the date. Unlike in SmartSheets where it shows the set specific times and date…Premium Apps and Integrations193Anna Henson
-
Smartsheet_Product Certified ExamAccepted AnswerAccepted Answer Anna Henson 10 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 05/26/20,Last post 05/26/20Hi! I have invested in the Center of Excellence training videos and Certified Exam. I have completed all the trainings and feel prepared with experience to take the exam. Before beginning, quick question: If fail to make the 80%, is the r…Premium Apps and Integrations103Anna Henson
-
COUNTIFS criteria including dates after XAccepted AnswerAccepted Answer [email protected] Seattle 10 views 2 comments 0 points Most recent by [email protected] Seattle Formulas and FunctionsFirst post 05/22/20,Last post 05/26/20I'm trying to create a formula that counts the number of entries submitted to a separate sheet per person completed since a specific date (3/24/2020). My formula that works for counting all entries by individual is =COUNTIF({Other Sheet R…Formulas and Functions102[email protected] Seattle -
How do I assign a default value to fields in my Sheet/Form?Accepted AnswerAccepted Answer Lisa Evans 11 views 3 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/26/20,Last post 05/26/20For example, in my daily standup kanban board the card format has 2 fields that I'd like to default to a static value, and 1 field that I'd like to default to the [start date]=today's date, but allow it to be changed if the user choses to …Using Smartsheet113Lisa Evans
-
Answered - Pending Review SueinSpain 32 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/20/20,Last post 05/26/20I'm looking to add some formula to my summary sheet and the requirement is for analytics for Last month, last quarter and last year - so excluding current month Examples if: current month = May 2020 last month = April 2020 last quarter =…Formulas and Functions323SueinSpain
-
Answered - Pending Review matthew chan 18 views 5 comments 0 points Most recent by Mike Wilday Formulas and FunctionsFirst post 05/22/20,Last post 05/26/20how do i get a smartsheet to automatically register completion date in a cell based on condition to be achieved in another cell? for example, a task to automatically register the completion date on the day a task is approved by a managerFormulas and Functions185matthew chan
-
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
