-
How to count the number of times a value appears based on multiple criteria in another column?
Hello, I am trying to create a formula that counts the number of times an email appears based on a number of selections made from a drop-down menu. The process is for counting the number of trainings completed per quarter per employee. The trainings are submitted through a form and only one training title can be submitted…
-
Using Index Match for Multiple Value Dropdowns
Hello, I'm trying to utilize index matching for some metadata sheets and using the formula I am currently utilizing, the data appears blank. The formula currently being used is: =IFERROR(INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Impact/Benefits]$1, {Portfolio Summary Header Row},…
-
Column IF AND Function Help
Hi all! I cannot seem to get my IF AND statement to work and would sincerely appreciate some guidance! I am attempting to alter/update a cell on one sheet that acts as a matrix for employee training which is based upon information from a reference sheet. Essentially, a row in the reference sheet is populated every time a…
-
Automation Error
Not sure if this is the right place for an automation error or not. I have previously asked about returning a value once (not sure if my link would work for everyone or not). I was able to get it to work with a metrics sheet, a helper column, and a copy rows automation. However, the ID I used for that one, is only valid…
-
Embed charts and/or graphs from another database
Hello, Is it possible to embed pictographs, charts, graphs, tables, etc. from another database into a dashboard or report?
-
Use Conditional formatting to mark cells that contain formulas
Good Afternoon Smartsheet wizards, While I am relatively new to Smartsheet and have purchased some of the learning, the Conditional Formatting is entertaining. I'd like to prove that certain cells have formulas, or not. Thank you in advance for your help. Cheers, Bill
-
Need formula to pull in names associated with RACI roles.
I have a Project Plan template that I would like my team members to save as new for each client and customize the information. Within the Project Plan, there's a RACI matrix with different roles. Please see below for an example: When a new client is assigned and team members save the project template as new, I'd like to be…
-
Trying to Flag Overlapped Participants in Meetings
So I am trying to find a way to flag if there are the same people in multiple meetings. I am working with a drop down type format for the list of participants, so I am not sure how or if there is a way to compare the individual entries of the drop down to other elements in the column to test for potential conflicts.
-
How to separate multi select values and collect distinct values?
Each period (P1,P2,P3 etc) we collect KPIs for our projects. In some new KPIs we have been asked to collect the answers involve multi select drop downs. What we would like to be able to do is to each period have a list of only the unique values. I have tried using a formula which uses JOIN, DISTINCT and COLLECT and it…
-
IF Function Resulting in Specific Symbol Given Specific Inputs from other Columns
Hi all, Wondering if I could get some help on writing out a function. I know that it will probably be some sort of advanced and lengthy IF function but am confused on how to write it out. I have a Smartsheet that is used to track data inputs from a form. This data is related to a specific order coming in. I would like to…