Formulas and Functions
Archives for September 2023
Discussion List
- 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 …
- 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…
- 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 colum…
- 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 p…
- 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 S…
- 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" i…
- 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…
- 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 fo…
- 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 m…
- 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" dist…
Help Article Resources
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hey friends, I'm finally figuring out a complex system to have a first sheet with a Dropdown data row, matched to a column with a helper row that only highlights the MAX (most recent) dropdown. I'm do…
- Expected CPM is generated using three columns from another sheet. Column 1: OSM SKU Column 2: OSM TF Column 3: OSM CPM I have tried IF/ IF AND / INDEX(Collect), all I get are errors. IF OSM SKU is xxx…
- Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1. Columns: National_l…