IT & Operations
Discussion List
-
Using CountIfs to track a column will multiple optionsIn Formulas and FunctionsHi 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…
-
Formula for RYG status based on Drop down column marked: Complete, In Progress & Not StartedIn Formulas and FunctionsHi 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"…
-
Gantt Chart with multiple dates in one line?In Using SmartsheetHello 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 …
-
Quickbooks & SmartsheetIn API & DevelopersSo. 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…
-
Formula to count of items in a multi dropdown listIn Formulas and FunctionsHi 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 …
-
Data Mesh SyncIn Using SmartsheetI'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…
-
User Access Review and ApprovalIn Using SmartsheetHello, 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?
-
Can I hide predecessor lines in a gantt chart?In Using SmartsheetI 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…
-
Excel ImportIn Using SmartsheetWhat 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…