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
-
First post 08/07/20,Last post 08/07/20Is there a way to view previously published smartsheets? I am looking for a way to look back and see previous contents.Using Smartsheet70Che Fortaleza -
Sheet Summary - SUM Chilldren Rows based on Status and DatesAccepted AnswerAccepted Answer Davis Dye 12 views 4 comments 0 points Most recent by Davis Dye Formulas and FunctionsFirst post 08/07/20,Last post 08/07/20Good Afternoon! I am trying to sum children rows where certain status' exist where the Pick-Up Date is today, within the next two days, and in the future beyond that. (Really, 3 formulas). (Image) I tried applying the following formula bef…Formulas and Functions124Davis Dye
-
COMPARE COLUMNSQuestionAnswered - Pending Review Sebastian Avila 9 views 1 comment 0 points Most recent by [email protected] Formulas and FunctionsFirst post 08/07/20,Last post 08/07/20Hi have two columns with ID´s and i want to compare them see, if an Id number has a match or a mismatch in the other column. What kind of formula de you recomend to do this? I used Vlookup: =VLOOKUP([NÚMERO DE SINIESTRO]1; {SINIESTROS CF};…Formulas and Functions91Sebastian Avila
-
Formula to calculate fiscal quarterAccepted AnswerAccepted Answer Lee Ratzlaff 43 views 5 comments 0 points Most recent by Paul Pindell Formulas and FunctionsFirst post 01/24/20,Last post 08/07/20Hello! I am trying to create an IF statement to show the federal fiscal quarter an event occurred. Could someone please help troubleshoot my syntax? Federal Quarters: Q1: Oct, Nov, Dec (10, 11, 12) Q2: 1, 2, 3 Q3: 4, 5, 6 Q4: 7, 8, 9 Not …Formulas and Functions435Lee Ratzlaff -
Is there a way to Cc myself on all automated alerts that are sent to contacts in a specific column?QuestionAnswered - Pending Review Shelby 8 views 5 comments 0 points Most recent by [email protected] Using SmartsheetFirst post 08/07/20,Last post 08/07/20For documentation purposes, I need to Cc myself on all automated alerts that are sent to a vendor to notify the vendor that a warranty claim has been assigned to them. I set up a workflow that sends an alert to each contact that is include…Using Smartsheet85Shelby
-
First post 08/07/20,Last post 08/07/20Hi there, Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as "Read only - HTML", but this option does not appear to be available when publishing a report. There are comments …Using Smartsheet110Jamie Bedford
-
First post 08/07/20,Last post 08/07/20I can not even see what the header in the third column says. I know it says CM Help Needed. All I can see is part of the N and the eeded. How do I fix this without making the column super-wide? (that would waste a lot of space) I tried t…Using Smartsheet80Marc Lajoie
-
#INVALID REF for WidgetQuestionAnswered - Pending Review Jamie Wisegerber 14 views 7 comments 0 points Most recent by Jamie Wisegerber Formulas and FunctionsFirst post 07/31/20,Last post 08/07/20Hi Community. I'm hoping someone can help me out. I created a task tracking sheet. A general rule is that our reporting month is always two month behind today. In my sheet summary I have a formula using index match, which works perfectly t…Formulas and Functions147Jamie Wisegerber -
SUMIFS FormulaQuestionAnswered - Pending Review Irina Iatco 16 views 3 comments 0 points Most recent by Irina Iatco Formulas and FunctionsFirst post 08/06/20,Last post 08/07/20Hi, I am trying to sum the numbers in the first column where the states are CA, CO, DC and IA. Could you please help. I a still learning formulas in Smartsheet. Thanks! (Image)Formulas and Functions163Irina Iatco
-
First post 08/07/20,Last post 08/07/20Hi. I'm sending a link to my report in an automated workflow as an "Alert Someone". The recipient email contains a link to the report and a snapshot of the report, but it is limited to 100 rows. A message appears at the bottom t…Using Smartsheet70Sandra Dye -
#NO MATCH on simple VLOOKUPQuestionAnswered - Pending Review Neil Fleming 12 views 13 comments 0 points Most recent by Neil Fleming Formulas and FunctionsFirst post 08/06/20,Last post 08/07/20Simple VLOOKUP based on text field returns #NO MATCH. Driving me crazy!: (Image) (Image) Ideas?Formulas and Functions1213Neil Fleming
-
Where are those free objects????Accepted AnswerAccepted Answer Ken Hankoff 11 views 3 comments 0 points Most recent by Ken Hankoff Using SmartsheetFirst post 08/07/20,Last post 08/07/20Hi Community, Many moons ago, I stumbled upon Smartsheet collateral that could be downloaded for use in Dashboards/Portals. Specifically, it was things link artistically designed lines that could break up a Dashboard page, and other simil…Using Smartsheet113Ken Hankoff
-
COUNTIFS based on conditionsQuestionAnswered - Pending Review Sarah Lanahan 22 views 5 comments 0 points Most recent by Sarah Lanahan Formulas and FunctionsFirst post 07/30/20,Last post 08/07/20Hi I'm trying to count the number of teachers from different cohorts that have not yet given feedback through a form, so the cells with #NO MATCH. I have all of the data in 1 SS and am totally and running metrics in another. In the sheet…Formulas and Functions225Sarah Lanahan
-
COUNTIFS HelpAccepted AnswerAccepted Answer Carlos Yanes 8 views 4 comments 0 points Most recent by Carlos Yanes Using SmartsheetFirst post 08/07/20,Last post 08/07/20I'm trying to do a count if criteria within two columns meet particular criteria. I keep getting the unparseable error message. My formula is: =COUNTIFS({NCO-SD Intake Range 1}, [Contact Email]7, AND{NCO-SD Intake Range 2}, [Assigned Total…Using Smartsheet84Carlos Yanes
-
Bringing back multiple valuesQuestionAnswered - Pending Review Carlos Yanes 9 views 4 comments 0 points Most recent by Carlos Yanes Using SmartsheetFirst post 08/07/20,Last post 08/07/20Is there a formula that would bring back multiple cell values within a column, if there are two specific conditions being met? For example, I have a list of users that are working on tasks that are listed in each cell. I'm wanting to bring…Using Smartsheet94Carlos Yanes
-
Question Nikki McIntosh 9 views 0 comments 0 points Started by Nikki McIntosh Formulas and FunctionsFirst post 08/07/20,Last post 08/07/20Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows…Formulas and Functions90Nikki McIntosh
-
IF Formula doesn't workQuestionAnswered - Pending Review Anna Pelipas 13 views 6 comments 0 points Most recent by Michael Heisler Formulas and FunctionsFirst post 08/06/20,Last post 08/07/20Please help, what's wrong? It couldn't be parsed... =IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));"ДА";"НЕТ") Thank you in …Formulas and Functions136Anna Pelipas
-
Date Range FormulaAccepted AnswerAccepted Answer Cassie Sprague 9 views 2 comments 0 points Most recent by Cassie Sprague Formulas and FunctionsFirst post 08/07/20,Last post 08/07/20Hi, I'm trying to set up a formula to count the number of requests that were submitted between a specific date range. Below is the formula that I've written, however I'm still receiving an invalid operation error. Can anyone help me with t…Formulas and Functions92Cassie Sprague
-
First post 08/07/20,Last post 08/07/20Greetings my Smartsheeters-in-crime, And Happy Friday, all. Random question of the day here We have 60 product managers here all working off of a shared roadmap. I built a report, then modified it (yes, 60 times) for each of the product m…Using Smartsheet80Alan Rappa
-
if then... do this query.QuestionAnswered - Pending Review vipa2000 11 views 5 comments 0 points Most recent by Michael Heisler Formulas and FunctionsFirst post 08/06/20,Last post 08/07/20In the below - column Principal Check I have put: =if([Principal survey drawing required?]2="Yes",[Principal drawing validated?]="Awaiting response","Not Required") I am wanting the Principal drawing validated…Formulas and Functions115vipa2000
-
Answered - Pending Review Ray B 9 views 4 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 08/06/20,Last post 08/07/20Smartsheet Community: I am trying to Count If the Checkbox is Checked, the Date is Less than August 5 or Blank. I know I am close but can not see finish the Formula Correctly. Current Formula Below: =COUNTIFS({Issue / Defect UAT LOG Range …Formulas and Functions94Ray B
-
Auto RefreshQuestionFirst post 08/07/20,Last post 08/07/20Is there a way to set sheets to auto refresh? I have several reports set up for sheets, but will not refresh unless done manually. Also, when sheet B is updated from data entry from sheet A, conditional formatting does not update on shee…Using Smartsheet60Emerus CCC
-
Answered - Pending Review Jason Jones 18 views 2 comments 0 points Most recent by Jason Jones Formulas and FunctionsFirst post 08/07/20,Last post 08/07/20I have been working on this for hours and can’t seem to figure it out and can’t find proper support on line. This one is a time sensitive metric I am trying to get on our dashboard for our stakeholders to see. Any help you can give me woul…Formulas and Functions182Jason Jones
-
First post 01/30/18,Last post 08/07/20Hi Community, I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet. I'd still like to use t…Using Smartsheet2168Juston Oakes
-
First post 08/07/20,Last post 08/07/20I am trying to reference an automated creation column from sheet A to populate date AND time in a column in sheet B. I have been successful in the reference, but then have to format the receiving column to date format due to invalid data…Formulas and Functions90Emerus CCC
-
Auto CheckboxQuestionAnswered - Pending Review Emerus CCC 14 views 3 comments 0 points Most recent by Emerus CCC Formulas and FunctionsFirst post 08/05/20,Last post 08/07/20I would like a formula to check a box for open cases. I have a start date column and an end date column. Only check the box when there is a start date and no end date entered. Thank you!Formulas and Functions143Emerus CCC
-
First post 03/24/18,Last post 08/07/20Is it possible to reference the latest comment on a row, in a cell? And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opp…Using Smartsheet42316@daniel
-
Answered - Pending Review [email protected] 18 views 1 comment 0 points Most recent by [email protected] Formulas and FunctionsFirst post 08/05/20,Last post 08/07/20I know my question itself is confusing, so let me explain. I have configured data to come into Smartsheet from SharePoint via Power Automate. It is depositing some basic metadata into a "From SharePoint" sheet (image included her…Formulas and Functions181[email protected]
-
COUNTIFS + ORAccepted AnswerAccepted Answer Damon Lloyd 38 views 2 comments 0 points Most recent by Damon Lloyd Formulas and FunctionsFirst post 08/03/20,Last post 08/07/20Each quarter completed jobs get moved to a Completed Sheet for that relevant quarter. However, some of the tasks done on that job needs to be reported for a previous quarter. An example of a task would be a Preflight Review, which takes …Formulas and Functions382Damon Lloyd
-
Question Lindsey Cunningham 8 views 0 comments 0 points Started by Lindsey Cunningham Formulas and FunctionsFirst post 08/07/20,Last post 08/07/20I am trying to create a budget sheet that roll up the information inputed by mangers on 10 different sheets. Each manager has a grid like the one below and I want to duplicate that as a summation of information from each sheet. So a summat…Formulas and Functions80Lindsey Cunningham
