-
Autofill a column based on another column value
I have one column set up with a dropdown menu and want another column to autofill with a specific value tied to each dropdown menu selection. Is this possible?
-
Workflow- trigger and output inconsistencies
I've built out the following workflow to notify our PMs of any newly inserted row AND change cell value on two columns in added row. The workflow is not sending notifications during my testing, but has been populating the formulas as intended when I add rows to the sheet. When I manually run the workflow and notify myself,…
-
How to combine duplicate data and sum totals of those rows.
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 how to show this data without it being duplicated over the 12 times (once for each month). I know a report will need to be…
-
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…
