-
Count IF as a Column Formula
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 row is a duplicate and the end users deletes the row, then the unique items formula disappears and no longer calculates on…
-
Multiple Selection in Forms that Adjust Inventory Levels in Another Sheet
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 submitted/completed. Doing this for 1 item on the inventory sheet is fine, but sometimes users will need to submit for more…
-
Help with a Rolling 12 Month Formula
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 getting it to work. I have multiple programs on a sheet that have metrics and are nested under a blue header row. The data…
-
Formula to Capture Previous, Current, & Next Quarter
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 pulling reports for Previous, Current, & Next quarter, which I would like to automate. I've tried a few formulas, but haven't…
-
Last entry in a group
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 there a way of doing this? I do have a column for date.
-
When COUNTIF returns a "0" qty. show cell as blank
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 have tried nesting with an IF but I can't seem to get it to work. =COUNTIF(Manufacturer@row:[Asset Tag #]@row, 0) Any help…
-
Harvey Balls Using Formulas & Multiple Columns
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 Ball to be Full when all children rows are checked in "done" column AND there is text in the "Response" column Harvey ball to…
-
Displaying the most recent Comment
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 comment function. Where the meeting head can click, then type a comment to display onto the dashboard before he prints it and…
-
MEDIAN on another sheet, sometimes throwing #INCORRECT ARGUMENT SET
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 should use the Coordinator and get the median of my Days column based on other criteria. =IFERROR(IF(OR([Total NEW Tasks]@row…
-
COUNTIF/AND/NOT Formula
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 cancelled or whatever, so I don't want those in the total. My thought was to COUNTIF everything in the [Current Status] column,…
