ok almighty people..... I currently have =COUNTIFS({Depots1}, [Column1]23, {Product1}, FIND("Other", @cell) > 0) This counts cells that depot is = column 1 row 23, if the product column contains the w…
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each un…
I have a pivot table that I am attempting to use in order to collect a list of all jobs that our subcontractors have/are working on. Basically, I want a roll up of all jobs that each sub has worked on…
I have set up of customer survey that includes an NPS question. I am not too familiar with reporting and dashboards yet, so I am having a difficult time envisioning where I should do my NPS calculatio…
Hi all, I'm stumped on a formula (again!) I'm looking to ascertain a NPS and I've got the following going on: Promoters: =COUNTIF([How likely are you to recommend NCR to a colleague]:[How likely are y…
I need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is…
My goal is: if NCLEX is greater than 95% = Green If NCLEX is between 85%-94.99% = Blue If NCLEX is between 75-84.99 = Yellow If NCLEX is less than 74.99 = Red Below is the formula I am using and it is…
Hi all, I have a list of projects in a status update sheet. This list is automatically updated from a sheet that receives updates from a JIRA to Smartsheet connection. My issue is that the list of pro…
Hello! Im my sheet I have a formula in a helper column to pull the value of the parent task into each row - our parent task is our project deliverable name and it helps to have that in line for other …
Hi all, I asked another question in this thread. I now want to take a step further. I would like for the formula to sum the amounts in the SAR Loss column of my other sheet only if the Date Filed is b…