IT & Operations

Discussion List

  • Using CountIfs to track a column will multiple options
    In Formulas and Functions
    Hi everyone I have a multi select column that I am trying to use a countifs statement to count of instances of a name. However it only returns cells where only the name exist and nothing else. Does anyone know how to make it that it counts…
    Accepted
    26 4
    Answered ✓ 26 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started
    In Formulas and Functions
    Hi there! I am looking for help creating an IF formula to produce the RYG based on another column that has a dropdown (Complete, In Progress & Not Started). This is what I had: =IF([email protected] = "Completed", "Green"…
    Accepted
    21 2
    Answered ✓ 21 views 2 comments Most recent by M.Q. Formulas and Functions
  • Gantt Chart with multiple dates in one line?
    In Using Smartsheet
    Hello SmartSheet community! I'd like to double check with you if Smartsheets gantt charts has the posibility of displaying multiple dates in one row, I know there's been several posts regarding this topic, but I was hoping maybe the tool …
    3349 7
    3.3K views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Quickbooks & Smartsheet
    In API & Developers
    So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.  It has many application & the proof of concept exists and we use it.  We use it for an approval process (for in…
    5897 33
    5.9K views 33 comments Most recent by JeremiahHorstick API & Developers
  • 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 …
    Accepted
    30606 44
    Answered ✓ 30.6K views 44 comments Most recent by Paul Newcome Formulas and Functions
  • Data Mesh Sync
    In Using Smartsheet
    I'm using Data Mesh to try to keep the records in a report synchronized with a target sheet.  It seems to be working for adding new records to the target sheet and for updating existing records in the target sheet.  However, if a record is…
    531 6
    531 views 6 comments Most recent by Hannah Ellis Using Smartsheet
  • User Access Review and Approval
    In Using Smartsheet
    Hello, I am trying to create a workflow for role owners to review and approve their user access. Role Owners have multiple users- so I don't want to have an email go out for each user. Has anyone created a report like this?
    Accepted
    67 3
    Answered ✓ 67 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Can I hide predecessor lines in a gantt chart?
    In Using Smartsheet
    I have a complicated project with tons of predecessors.  The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use.  Is there are way to hide or turn off not the predecessors, but…
    1925 15
    1.9K views 15 comments Most recent by Romain L. Using Smartsheet
  • Excel Import
    In Using Smartsheet
    What are the prerequisites for importing an Excel spreadsheet into a new sheet.  I read number of columns, size and row constraints, which my Excel spreadsheet meets.  I am getting a warning regarding fields cannot be more than 50 characte…
    Answered - Pending Review
    546 5
    Answered - Pending Review 546 views 5 comments Most recent by Oana A. Using Smartsheet