Discussion List

  • Form Submission Issues
    In Using Smartsheet
    Hello! 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…
    466 8
    466 views 8 comments Most recent by Deborah Force Using Smartsheet
  • Center of Excellence
    In Using Smartsheet
    If someone wants to subscribe to the Center of Excellence, can he/she do that without being a paid Smartsheet user, or does the person need to upgrade?
    491 5
    491 views 5 comments Most recent by Genevieve P. Using Smartsheet
  • Would like to create a filter that hides completed tasks BUT only when parent row is checked
    In Using Smartsheet
    Hi there, Ultimately I would prefer that tasks that are completed are archived, however in lieu of functionality, I am looking to create a filter view where tasks marked as "done" are hidden. The problem is right now the filter h…
    12 4
    Accepted Answer 12 views 4 comments Most recent by Paul Newcome Using Smartsheet
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1348 5
    1.3K views 5 comments Most recent by L_123 Formulas and Functions
  • Kanban View - printing or saving to PDF
    In Using Smartsheet
    In the Kanban sheet, can this be saved to PDF in card view or printed in card view ? currently it shifts to list view when printing.
    437 8
    437 views 8 comments Most recent by Alberto Ferrari Using Smartsheet
  • #UNPARSEABLE using COUNTIF and cross-sheet Reference
    In Formulas and Functions
    This feels like a dumb question. I'm trying to get a count of total "To Do" items in the entire Status column from the Team SCRUM: Communications sheet. This function is working fine without the cross-sheet reference, but nothin…
    12 3
    Accepted Answer 12 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Creating a technology device loaning process
    In Formulas and Functions
    Good day everyone. I am new to the community but not new to Smartsheet. Have been using at my company for a number of years now. My team has acquired a quite a few pieces of equipment and it seems that we are constantly loaning them out t…
    23 2
    23 views 2 comments Most recent by Susie Wachowski Formulas and Functions
  • Adding months onto a date
    In Formulas and Functions
    Hi sorry I have seen this posted multiple times before but I can't get mine to work. I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date…
    12 2
    Accepted Answer 12 views 2 comments Most recent by JPFORDTE Formulas and Functions
  • nesting properly?
    In Using Smartsheet
    Hi all and good afternoon, im working on a sheet that seems to be giving me an issue and I am aware its my lack of knowledge. Hopefully someone from the forums can give me some insight as to how to achieve my desired result. I have a cell…
    53 2
    Accepted Answer 53 views 2 comments Most recent by jpetraccoro Using Smartsheet
  • Reference Predecessor Cell / INDIRECT Function
    In Formulas and Functions
    I'm using a formula to automate a status column that updates based on dates and/or a "Complete" checkbox. The formula has to reference the task before and I've gotten that to work just fine if it's the literal task before. My …
    Answered - Pending Review
    91 8
    Answered - Pending Review 91 views 8 comments Most recent by Paul Newcome Formulas and Functions