-
Don’t know why this formula is returning #UNPARSEABLE
Hi, This is probably really basic and I’m sorry if it is, but I’ve been tearing my hair out over WHY SmartSheet is complaining about this formula: =IF(AND([Raised by]@row<>”My Name”,[Raised by]@row<>”my.name@mycompany.com”),[Raised by]@row) So - return the column “Raised by” in this row, if it’s not “My Name” and not the…
-
Countif and Sums
I am a beginner in Smartsheet and have formula phobia but have been tasked with generating metrics etc. I have an ongoing intake sheet that collects details from volunteers on how much they get paid. Some volunteers donate money back so there are several metrics I have to report on. Here are the columns I have set up. I…
-
Linking Sheets in Workspace, Cell Pull through based on conditions
I am creating a series of sheets in a workspace. The idea is that there is one master log that feeds other logs as it is updated. The child logs would be fed once a condition on the master log is met, the kicker is that I don't want a line for line transfer leaving me with blank lines if a line on the master log has not…
-
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…