Recent Discussions

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

  • Che Fortaleza
    Question Che Fortaleza 7 views 0 comments Started by Che Fortaleza Using Smartsheet
    First post 08/07/20,Last post 08/07/20
    Is there a way to view previously published smartsheets? I am looking for a way to look back and see previous contents.
    Using Smartsheet70
    Che Fortaleza
  • Davis Dye
    Accepted Answer Davis Dye 12 views 4 comments Most recent by Davis Dye Formulas and Functions
    First post 08/07/20,Last post 08/07/20
    Good 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 Functions124
    Davis Dye
  • Sebastian Avila
    COMPARE COLUMNSQuestion
    Answered - Pending Review Sebastian Avila 9 views 1 comment Most recent by [email protected] Formulas and Functions
    First post 08/07/20,Last post 08/07/20
    Hi 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 Functions91
    Sebastian Avila
  • Lee Ratzlaff
    Accepted Answer Lee Ratzlaff 43 views 5 comments Most recent by Paul Pindell Formulas and Functions
    First post 01/24/20,Last post 08/07/20
    Hello! 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 Functions435
    Lee Ratzlaff
  • Shelby
    First post 08/07/20,Last post 08/07/20
    For 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 Smartsheet85
    Shelby
  • Jamie Bedford
    Jamie Bedford 11 views 0 comments Started by Jamie Bedford Using Smartsheet
    First post 08/07/20,Last post 08/07/20
    Hi 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 Smartsheet110
    Jamie Bedford
  • Marc Lajoie
    First post 08/07/20,Last post 08/07/20
    I 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 Smartsheet80
    Marc Lajoie
  • Jamie Wisegerber
    Answered - Pending Review Jamie Wisegerber 14 views 7 comments Most recent by Jamie Wisegerber Formulas and Functions
    First post 07/31/20,Last post 08/07/20
    Hi 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 Functions147
    Jamie Wisegerber
  • Irina Iatco
    SUMIFS FormulaQuestion
    Answered - Pending Review Irina Iatco 16 views 3 comments Most recent by Irina Iatco Formulas and Functions
    First post 08/06/20,Last post 08/07/20
    Hi, 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 Functions163
    Irina Iatco
  • Sandra Dye
    Question Sandra Dye 7 views 0 comments Started by Sandra Dye Using Smartsheet
    First post 08/07/20,Last post 08/07/20
    Hi. 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 Smartsheet70
    Sandra Dye
  • Neil Fleming
    Answered - Pending Review Neil Fleming 12 views 13 comments Most recent by Neil Fleming Formulas and Functions
    First post 08/06/20,Last post 08/07/20
    Simple VLOOKUP based on text field returns #NO MATCH. Driving me crazy!: (Image) (Image) Ideas?
    Formulas and Functions1213
    Neil Fleming
  • Ken Hankoff
    Accepted Answer Ken Hankoff 11 views 3 comments Most recent by Ken Hankoff Using Smartsheet
    First post 08/07/20,Last post 08/07/20
    Hi 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 Smartsheet113
    Ken Hankoff
  • Sarah Lanahan
    Answered - Pending Review Sarah Lanahan 22 views 5 comments Most recent by Sarah Lanahan Formulas and Functions
    First post 07/30/20,Last post 08/07/20
    Hi 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 Functions225
    Sarah Lanahan
  • Carlos Yanes
    COUNTIFS HelpAccepted Answer
    Accepted Answer Carlos Yanes 8 views 4 comments Most recent by Carlos Yanes Using Smartsheet
    First post 08/07/20,Last post 08/07/20
    I'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 Smartsheet84
    Carlos Yanes
  • Carlos Yanes
    Answered - Pending Review Carlos Yanes 9 views 4 comments Most recent by Carlos Yanes Using Smartsheet
    First post 08/07/20,Last post 08/07/20
    Is 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 Smartsheet94
    Carlos Yanes
  • Nikki McIntosh
    First post 08/07/20,Last post 08/07/20
    Hello. 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 Functions90
    Nikki McIntosh
  • Anna Pelipas
    Answered - Pending Review Anna Pelipas 13 views 6 comments Most recent by Michael Heisler Formulas and Functions
    First post 08/06/20,Last post 08/07/20
    Please help, what's wrong? It couldn't be parsed... =IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));"ДА";"НЕТ") Thank you in …
    Formulas and Functions136
    Anna Pelipas
  • Cassie Sprague
    Date Range FormulaAccepted Answer
    Accepted Answer Cassie Sprague 9 views 2 comments Most recent by Cassie Sprague Formulas and Functions
    First post 08/07/20,Last post 08/07/20
    Hi, 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 Functions92
    Cassie Sprague
  • Alan Rappa
    Question Alan Rappa 8 views 0 comments Started by Alan Rappa Using Smartsheet
    First post 08/07/20,Last post 08/07/20
    Greetings 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 Smartsheet80
    Alan Rappa
  • vipa2000
    Answered - Pending Review vipa2000 11 views 5 comments Most recent by Michael Heisler Formulas and Functions
    First post 08/06/20,Last post 08/07/20
    In 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 Functions115
    vipa2000
  • Ray B
    Answered - Pending Review Ray B 9 views 4 comments Most recent by [email protected] Formulas and Functions
    First post 08/06/20,Last post 08/07/20
    Smartsheet 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 Functions94
    Ray B
  • Emerus CCC
    Auto RefreshQuestion
    Question Emerus CCC 6 views 0 comments Started by Emerus CCC Using Smartsheet
    First post 08/07/20,Last post 08/07/20
    Is 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 Smartsheet60
    Emerus CCC
  • Jason Jones
    Answered - Pending Review Jason Jones 18 views 2 comments Most recent by Jason Jones Formulas and Functions
    First post 08/07/20,Last post 08/07/20
    I 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 Functions182
    Jason Jones
  • Juston Oakes
    Juston Oakes 216 views 8 comments Most recent by Shelby Using Smartsheet
    First post 01/30/18,Last post 08/07/20
    Hi 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 Smartsheet2168
    Juston Oakes
  • Emerus CCC
    Question Emerus CCC 9 views 0 comments Started by Emerus CCC Formulas and Functions
    First post 08/07/20,Last post 08/07/20
    I 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 Functions90
    Emerus CCC
  • Emerus CCC
    Auto CheckboxQuestion
    Answered - Pending Review Emerus CCC 14 views 3 comments Most recent by Emerus CCC Formulas and Functions
    First post 08/05/20,Last post 08/07/20
    I 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 Functions143
    Emerus CCC
  • @daniel
    @daniel 423 views 16 comments Most recent by Shelby Using Smartsheet
    First post 03/24/18,Last post 08/07/20
    Is 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
  • SteveReed@WK
    Answered - Pending Review [email protected] 18 views 1 comment Most recent by [email protected] Formulas and Functions
    First post 08/05/20,Last post 08/07/20
    I 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]
  • Damon Lloyd
    COUNTIFS + ORAccepted Answer
    Accepted Answer Damon Lloyd 38 views 2 comments Most recent by Damon Lloyd Formulas and Functions
    First post 08/03/20,Last post 08/07/20
    Each 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 Functions382
    Damon Lloyd
  • Lindsey Cunningham
    Question Lindsey Cunningham 8 views 0 comments Started by Lindsey Cunningham Formulas and Functions
    First post 08/07/20,Last post 08/07/20
    I 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 Functions80
    Lindsey Cunningham