Discussion List

  • Remove Primary Column From Report
    In Using Smartsheet
    I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it.   Thanks!  
    1600 10
    1.6K views 10 comments Most recent by Genevieve P. Using Smartsheet
  • Countif and HAS for multiselect for Quiz answers
    In Formulas and Functions
    I am using Countif and HAS to count a cell if a person has selected the correct quiz answers in a multiselect field. =COUNTIF([Q2]@row, HAS("a", "b", "c", "e")) This is returning 0 and I am not sure …
    RAC Profile Photo RAC
    24 3
    Answered ✓ 24 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Formula to count of items in a multi dropdown list
    In Formulas and Functions
    Hi The drop-down multi select is very nice and useful.  I started to use it yesterday, but I need to use the formula =countif(range, criterion).  I want to count how many times a value is repeated in a range that has multi values. I use …
    30846 44
    Answered ✓ 30.8K views 44 comments Most recent by Paul Newcome Formulas and Functions
  • Can this excel formula be created in smartsheet?
    In Formulas and Functions
    =IFS(A5>B5+C5,"RED",B5>A5+C5,"Green",C5>B5+A5,"Yellow") If anyone can help me I<d be very appreciative :)
    33 2
    Answered ✓ 33 views 2 comments Most recent by JoAnneA Formulas and Functions
  • Automated Workflows Limit
    In Using Smartsheet
    Hi  Is there any limit to how many "automated workflows" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it.  
    881 6
    881 views 6 comments Most recent by Paul Newcome Using Smartsheet
  • Flagging a Date and Time Overlap
    In Formulas and Functions
    Hello,   I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as…
    1236 29
    1.2K views 29 comments Most recent by Paul Newcome Formulas and Functions
  • Smartsheet University Is Here!
    In General Announcements
    Hi Community,  We are excited to introduce Smartsheet University, a single platform for eLearning, live instructor-led training, in-person training, and custom training. Smartsheet University offers unique learning paths and meaningful con…
    944 13
    944 views 13 comments Most recent by Debbie Smith General Announcements
  • CountIf with Date range
    In Formulas and Functions
    I am trying to count the number of requests types between a date range.  This is what I thought would work:   =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 0…
    7105 42
    7.1K views 42 comments Most recent by Paul Newcome Formulas and Functions
  • Line chart with multiple date-numbers traces
    In Using Smartsheet
    Hello everyone!   I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are re…
    Answered - Pending Review
    2444 25
    Answered - Pending Review 2.4K views 25 comments Most recent by James Vandezande Using Smartsheet
  • Free Webinar: Intro to Data Shuttle
    In General Announcements
    Join us on January 19th for our webinar Intro to Data Shuttle where we will be discussing how we can leverage Data Shuttle to automatically and seamlessly upload or offload data between Smartsheet and other tools you use. We will be hostin…
    81 1
    81 views 1 comment Most recent by Victor Agudelo General Announcements