Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.

Product questions?
Ask it here! The community's got your back.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Weekly Report
Hello Smartsheet folks, Does anyone know how I can create a report that only show data results every week? I have a data sheet/report that shows what store was complete, their unique information and the date their installation was complete, for the entire month. From this data sheet/report, I want a weekly report that only…
IF formula with multiple options
Good morning- Wondering if someone might be able to help me with this. I have a dropdown list column that has three options. If option A is selected, I want to automatically populate another column in the sheet with a specific message, but if option B is selected, I want to populate that same column but with a different…
IF formula
Hi Folks looking for simple formula hoping someone can help Trying to add in sheet summary Total cost [ sum of all amounts in last column] if Purchase order status [ first column] is 1.1 Any suggestions welcome is it better in sheet summary , reports etc Thanks in advance
#invalid data type
Hi, I'm using formulas in my sheet summaries of multiple files. All work perfectly well, except on 1 more complex sheet, which contains the same columns. Example: =COUNTIFS([Activity type]:[Activity type], "Partner event", [Budget FY]:[Budget FY], "FY25") The activity type & budget FY columns are both list of values. The…
Does locking a column stop the formula calculating?
This discussion was created from comments split from: Locking and unlocking a Column with a Formula.
RANKEQ formula returning 1 for all rows
This discussion was created from comments split from: Help with ranking based on criteria (RANKEQ, COLLECT).
If Match Check Box
How do I write a formula to check a box next to an ID Number if that same ID Number is also present in another column? So Column 1 is ID Number to complete and Column 2 is ID Number completed list. Thanks in advance!
Copying rows from one sheet to another after checkbox trigger - copying whole sheet
Hi, I have 2 sheets that I am setting up for inventory and ordering for my team. Sheet 'A' has a full inventory list, including a checkbox that will be checked when the inventory item needs to be ordered. After a row is checked, I want it to copy over to my Sheet 'B'. I will use sheet B then to track the order process. I…
Find if any string from a list of strings is present in a cell
Hi I have a sheet with a column "List of Tests" that has a list of test codes, e.g. row 1 = T101, row 2 = T102, row 3 = T103; this same sheet has another column "Selected" that has a check mark to show whether or not the test was selected. A second sheet has a column that has one or more tests listed called "Applicable…
Column Formula for only Parent Rows
We have a few sheets that use different formulas for both Parent & Children rows. Is there currently anyway reference whether a row is a parent or a child row so that we can run different formulas in the same column while using the column formula functionality? Thank you!

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags