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 - I would like info in column b on sheet A to appear in column Y on sheet Z
Column Y on sheet Z has no data in it. Many of the cells in column b on sheet A are blank. I've tried =IF(NOT(ISBLANK({column b on sheet A}), 1, 0)) =({column b on sheet A}) =INDEX({column b on sheet A}, MATCH([column Y]@row, 0)) =INDEX({column b on sheet A}) I would also like it to update when changes are made. I feel…
Sheet formula Error Message
I have a column titled "Current Month", this column is comprised of checkboxes, I have the following formula automatically checking the box if it is one month prior (for auditing purposes); for example if the Date is 10/08/2024, I need to check all boxes where the date starts with 09. =IF(AND(MONTH([Date of…
Automate formula based on dropdown
So I have a sheet with multiple columns. Rows automatically appear based upon a Power Automate flow from other sources and rules. It works great, but now I need to auto populate a calculated formula in one column based on a drop down selection in another. The two things I thought of don’t seem to be working. Example: I…
Join row data formula
I have two sheets for a traning evaluation form. They both have a common column, TrainingID. Based on that column I want to bring in data from one sheet to another. Example: For all rows that have BLS05 as a Training ID, I want the data columns from Facilitator Information to merge with the Evaluation sheet Facilitator…
Automatically linking cells when a new row is added to a sheet
I have two sheets. Sheet 1 contains primary data, the other secondary. When a new row is added to sheet 1 I want to be to create a new row in sheet 2 that contains the information in specific cells from sheet 1. I want that link to work such that if Sheet 1 is updated that is reflected in sheet 2 - the sheets stay in sync…
Countif - Not!
All, I may have gone next Lv here but the following basic counts results in 0. I've written first 2 then tried the new AI feature to confirm and same result, 0 count.. ? Ultimately I want to count how many orders Dale took in 2024 to current date Sales Rep column is a drop down with up to 9 reps no multiples. Date of order…
Formula issue
Hi Brain Trust We have a formula set up to report when two columns don't have the same drop-downs selected. =IF([Candidate Compliance & Training Check]@row = [Job Compliance & Training Requirements]@row, "Low", "High") The team now want to use the following symbols What or how can I set up a formula that will give me :-…
Trying to set up options to fill cell itself or from a formula in another column.
To track staff attendance, one column (Call Out Type) we have is a drop-down with 5 options. We want to have a separate column (Call Out) that would be included in the form the staff fill out when calling out that would include 3 of the 5 options. I set up a formula that would copy the value in the Call Out column into the…
Make a checkbox that is used on 2 sheets show the same value.
I have a checkbox called "Pause" that is located on a sheet called "Schedule Sheet" that needs to be the checked/unchecked based on a "Pause" checkbox located on a sheet called "Periscope Request Tracker". if the checkbox is checked on the Periscope Request tracker then I need the checkbox to be checked on the Schedule…
Report includes the Latest Comment field, updates from report do not flow to source sheet.
Created report for our RAID log. The report includes the Latest Comment. If updates are made to the source sheet the report correctly updates the Latest Comment field. However, if an update is made to the report field Latest Comment, that update will not pass back to the source sheet. Before the Latest Comment was released…

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

Question about copying a sheet
I use Smartsheet to track my yearly activities. I have a sheet that is connected to this sheet for calculations that feeds into a dashboard. Hopefully that makes sense. My question is, I want to copy this entire thing and start new for 2025, however when I copy, the calculation sheet is still pulling from the 2024 sheet.…
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags