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.

Cross-sheet reference cells limited
hi all Is anyone have the same issue like this, one sheet reference other sheets and more than 100,000 cells will cause some problem? Thanks, Sherman
Struggling with multiple IF Statements
I am new to Smartsheet and struggling a bit to get Multiple IF Statements to work. I'm trying to get a number/score to render to an adjacent cell when an item is selected in the cell beside it. Having absolutely no luck here. (Attempted) Syntax below. Thanks in advance for your expertise. IF([Strategic Alignment]1 =…
Copying Row to New Sheet with Only Certain Columns
Hi! I have two sheets, and one you can think of as being the master sheet. This master sheet has different columns of data, some of which we would like to auto populate onto a second sheet which would include said data and more. How would I be able to bring the columns we want over to the second sheet using automation?…
Checkbox & Pulling back values in a cell
Hi, I've done my research and it looks like people have had to use Zapier for this specific use, but want to throw it out there again before i go that route! I am looking to pull back a value from a row where a box was checked. So i am thinking that in my formula sheet i can create a formula that basically says 'if the box…
Automation to help with Daily Medical Intake Forms
I am having one hell of a time with the automation to help our school with being alerted to different issues facing out compliance with the Daily Medical Intake Forms. What I am trying to do is have a couple of reports sent but something is not making it run. Students' parents fill out the med form daily. Some of the old…
Duplicate rows
Hello. I need to create a sheet that will store committee names that will continuously be updated and needing to be approved by multiple colleagues. Every time I need to have the committee names approved, I would like to be able to dump the entire list that originates from a different source into smartsheets, including the…
Date Grouping for Gantt Dashboard
Hi Everyone, I'm trying to automate a sheet into a Gantt Dashboard, however I am having issues finding a work around to show the child and parent dates, as all the information is stored in one row, rather than 3 rows for example. Sample Column Names: Project Name, Task 1 Start Date, Task 1 End Date, Task 2 Start Date, Task…
SUM by month
Hi guys, I'm trying to total income by month, and my formula is not working. Can someone please advise where I am going wrong? =SUMIFS({Fee}, {Date Received}, MONTH(@cell) = 10, {Date Received}, YEAR(@cell) = 2020) Where {Fee} is what I need to sum. I'm then trying to sum in November 2020 in the above example... Feel like…
Averaging numbers that meet a defined criteria
I'm creating a metrics sheet to feed a dashboard. On this sheet I am referencing a different sheet with the data. The formula I need to create would do the following: 1) AVERAGE the numerical values in one column. 2) IF the data was collected in a certain month, which is identified in a different column. So for example, I…
Regrouping Delimited Data
I pull data from an internal system and add it to Smartsheet via Data Uploader. When it comes in, it looks like the above, with Biz Entity, Sub Business Entity and Product Family grouped as delimited data. However, I want to regroup it so that each Biz Entity/Sub Business Entity/Product Family group is together in a single…

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