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…

  Earl P

  04/21/22

  Accepted

  26 4

  Answered ✓ 26 views 4 comments 0 points Most recent by Paul Newcome 04/21/22Formulas 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"…

  M.Q.

  04/18/22

  Accepted

  21 2

  Answered ✓ 21 views 2 comments 0 points Most recent by M.Q. 04/18/22Formulas 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 …

  Silvia C Rodriguez

  04/12/22

  3349 7

  3.3K views 7 comments 1 point Most recent by Andrée Starå 04/12/22Using 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…

  JeremiahHorstick

  04/12/22

  5897 33

  5.9K views 33 comments 2 points Most recent by JeremiahHorstick 04/12/22API & 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 …

  lcamacho19911

  04/01/22

  Accepted

  30606 44

  Answered ✓ 30.6K views 44 comments 0 points Most recent by Paul Newcome 04/01/22Formulas 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…

  Jeremy Davis

  03/24/22

  531 6

  531 views 6 comments 0 points Most recent by Hannah Ellis 03/24/22Using 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?

  Tanya P

  03/16/22

  Accepted

  67 3

  Answered ✓ 67 views 3 comments 0 points Most recent by Genevieve P. 03/16/22Using 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…

  Project User

  03/15/22

  1925 15

  1.9K views 15 comments 5 points Most recent by Romain L. 03/15/22Using 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…

  kim.wade56346

  03/15/22

  Answered - Pending Review

  546 5

  Answered - Pending Review 546 views 5 comments 0 points Most recent by Oana A. 03/15/22Using Smartsheet