Formulas
Discussion List
- 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…
- Good afternoon; So, I'm trying to create a Summary field for a sheet that counts the number of active projects therein. Some projects are completed (we're not archiving these yet), or on hold, or canc…
- Hello Smartsheets Community! I have possibly a complicated question. I have two sheets, one is essentially a "job log" while the other is an "order sheet" with items for several different jobs. Is it …
