-
Formula Help
Hello, Trying to get this formula to work and have tried every which way, but keep getting unparseable. I would like to add the outcome in the helper columns to equate to the CareKit Name. So CK Type Helper + Educational Language Helper + BP Cuff Size Helper = Blood Pressure Kit (English) OR Blood Pressure Kit (Spanish),…
-
How do you get a form to autofill the next set of numbers and repeat 1-50, 6 at a time?
We had a sheet that would automatically repeat numbers after a form submission (the form was just a checkmark box). The numbers were 1-50 and repeated 6 at a time. A user deleted some lines and now it has stopped working and I can't remember how to fix it.
-
If formula for multiple check boxes.
I have multiple columns with check boxes and I need a new column that validates if ALL are checked. I'm trying to create a formula that says: if column 2 is checked, AND column 3 is checked, AND column 4 is checked, 'yes' else 'no'. Any help is appreciated.
-
Release Scheduling - Create a Dynamic Release Drop Down
This use case allows business customers the ability to request support, based on a weekly release window. Future support may be reserved. The release day is every Tuesday. For reporting and counting purposes, I don't want to provide the user with a date picker. I want to drive the # of weeks per year and the corresponding…
-
Drop Down List not populating (Mobile Version)
Hello i have a quick question and was wondering if anyone was experiencing similar issues and have found a work around. I put together a checklist for our MHE and would like to post a QR code to the Smartsheet around our facility. The issue i am experiencing is one of my columns with a drop down box is not populating on a…
-
Formula IFS return values from other columns
Hi, i am trying to set a new column that should return EAS or ETS text depending of what it is in column named "ETS", but i want to add another if that return a value from column "Business Dropdown" if the column ETS is blank. This is the formula that i wrote now very simple and it is running well, but it is missing the…
-
Formula Help For Multiple Tags Within The Same Cell
Hey All! First time posting... so here goes... I am attempting to write a formula that references another sheet, looks at a specific column, and then 'finds and counts' all the instances of a specific tag. For example, the intake form allows multiple 'characteristics' to be chosen when describing a call. These…
-
Did I make it too difficult to calculate?
Hi, I am a rookie when it comes to formulas - and while I understand the basics, I feel stuck with one thing related to a sheet that will start coming data collection soon, and I want to ensure the formulas are all set before it starts. Here is where I am stumped: I have a column on my smartsheet where one option let's…
-
Hopefully a pretty easy question that I need help with.....
Hi all, I am newish to using formulas, and I am stuck. All I really need to do is have one column return as "true" based on the status. I am getting an error message. This will allow me to calculate my data in an Excel pivot table. =IF(CONTAINS("COLUMN NAME",@row), 1, 0) What am I missing? Thank you!
-
Count & Sum Distinct Values based on Criteria | COUNT(DISTINCT(COLLECT(...) | Returning 1 ???
In a ROLLUP sheet, referencing a source sheet, I'm trying to count (and sum) DISTINCT values that meet multiple criteria. My formula keeps returning "1", when in the shown scenario below has "80" distinct values. Hoping I'm just missing something simple. Rollup sheet purpose = count the distinct values rented within…
