-
Using CountIfs to track a column will multiple options
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 all instances? Formula below for example =COUNTIFS({Training Project Task List Range…
-
Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started
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(Status@row = "Completed", "Green", IF(AND(Status@row = "In Progress", "Yellow", IF(AND(Status@row = "Not Started"), "Red"))))
-
404 Error - Event data - Smartsheet API
Hi, I am attempting to get event data from the smartsheet api. First, I tried the new api documentation method which suggests a request to the event api url. Traditionally, you don't pass both a parameters variable AND parameters in the url which is being suggested in the documentation. I tried a few different ways and…
-
Card View for Reports
All, Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to view user stories across multiple products/sheets. Although there are other benefits I…
-
Data Mesh Sync
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 removed from the source, I need to have it removed from my target sheet. Data Mesh…
-
User Access Review and Approval
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?
-
Excel Import
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 characters long. Is this regarding the primary column only or is this for all columns?
-
COUNTIFS
I want the formula to count how many risks there are that are open. =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open"))) I can't seem to get it to work. Can anyone help? Thanks
-
Auto copy primary column
Hello, I have inherited a smartsheet used for asset tracking. Asset ID number is currently the primary column but I am changing that to an auto generating column to prevent any human errors that I have noticed. Since the primary column can only be numbers/text I have created a new column that is auto numbering. What I…