-
IFSUMS using word and numbers
Hello, I am building a matrix sheet to pull data from a source sheet and trying to use an IFSUMS formula, but have received various outcomes #UNPAREBLE =SUMIFS(({Evt Support Level},[Event Support Levels]@row , {Event Month}, May1)+sumif({Event Year}, 2025)) #INCORRECT ARGUMENT SET - =SUMIFS({Evt Support Level}, [Event…
-
Pulling data from another sheet based on two criteria
Hello! I am having trouble getting this formula to work.. The goal is to pull the quantity of an item from a reference sheet to this sheet if the Spec #@row on this sheet matches an EAN on the reference sheet, and only if the Disposition value reads "Released". This is the formula I have cooked up, but get an…
-
Using sheet summary fields in an alert
Hi All, I have built a workflow where once certain conditions are met we send an alert to a few stakeholders where we give row details and reference some details stored in the sheet summary. At the moment I have not found a way to directly reference this information without adding a helper column to the row and using a…
-
In the case of DIVIDE by ZERO, I want cell to show "" nothing or hyphen.
I'm getting percentage for referrals that result in new business. For forward months (Aug-Dec) there are no referrals yet so the formula is dividing by 0. How can I adjust the formula to return nothing or a dash for those months? This is the formula that returns the right numbers if there are successful referrals in a…
-
Count per Day
Please assist- I have one grid and I have : 4 Coordinators Status is Completed and Completion Date I want to get the Daily count of Completed per Day. I have this table below.
-
Is there a formula for one sheet to recognize data from other sheets?
Apologies in advance because I'm not entirely certain how to ask what I am trying to ask. We use Smartsheet as part of our transfer course evaluation workflow at a four-year institution. We are having to change some things in our workflow, and in setting up new sheets, I am struggling to find out if I can automate a…
-
Count for multiple values in a range
Hello, I'm having some difficulty setting up a countif formula for my sheet. I have a long list of barcodes as a range, and I'm trying to count how many times specific barcodes show up in the list. I currently have it set up to count for two barcodes each in separate columns. =IFERROR(IF(ISBLANK(Barcode@row ), "",…
-
Invalid Data Type or Invalid Column Value on Helper column
I'm trying to create a helper column to evaluate multiple drop down column values. This one is to return a value if the tested columns have a specific value. (Once I get this one working I'll be adding a bunch more but, alas, ran into this issue out of the chute.) For simplicity here, I've trimmed down my formula to only…
-
Multiple IF formula over 2 columns
So I have a sheet with 2 columns that have numbers, text or blank. I want a 3rd column to do this, "If column 1 is blank, display A. If column 2 is blank, display B. If both columns 1 and 2 are blank, display C" How would I write a formula to make that happen?
-
Attempting to create a formula to find items assigned to a contact from a drop down.
I hope my title makes sense. I work in a veterinary Setting, I am working to make some metrics for a sheet dashboard and I am trying to get a cell formula to show me how many of a category is assigned to a person. I have been able to figure out the totals per category in my sheet but now I want to be able to see it at the…