I have a sheet that we track data for on a monthly basis for the same items (example below). I would like to display a "top impressions" and "top clicks" widget on my dashboard, but cannot figure out …
I have a file that gets updated daily. There is a formula to identify unique items, in this case states. The file also has a formula to look for duplicate part numbers. The issue is that if the last r…
I currently have an inventory sheet I created myself (did not use a template in SmartSheets). It works well, but I'm trying to integrate a From that will automatically adjust inventory levels when sub…
Hello, thank you for taking the time to look at this and I appreciate any assistance anyone out there might be able to supply. I'm trying create a Rolling 12 Month Formula and running into an issue ge…
Hello, I have a spreadsheet with information populated from Jira. Unfortunately it does not contain information like start and finish date, but uses quarters instead. I am creating a dashboard with pu…
OK, so I have a report and it has several columns. One is serial number. I have all of the entries grouped by serial number. I now would like to view only the last entry for each serial number. Is the…
I am using this formula to count how many cells in a row have their checkbox checked, and it is working correctly. When the total = 0, I would like for the cell to appear blank instead of showing 0. I…
Hi all! I am trying to determine what formula to use when calculating Harvey Balls using two different column details. Harvey Balls are in the "Corrective Action" column. What I want to do: Harvey Bal…
Good Morning, I have a dashboard that displays information for a morning meeting, it is all numbers, percentages and charts. I have had no problem with it up until now, I have been asked to add a comm…
I have a summary sheet, pointing to another sheet where I'm gather median hours based on a specific criteria in a column formula. I have a Coordinator Column as the reference point. The other sheet sh…