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.

INDEX/MATCH works in one sheet, same formula gives #INVALID OPERATION in another
Hi all I have a Project Info section of my schedule sheet that I pull into columns so that the info can be used in automated emails about tasks. The sheet that's giving me problems is a copy of another sheet, where the formula works. =INDEX([Task Description]:[Task Description], MATCH("Portfolio", Task:Task, 0)) It works…
Trying to gather cell info from 2 different unique id's on different sheets
The following sheets in my description are in 3 different workspaces if that makes a difference. We also do not have the licensing for control center if that is an easier solution, so im working with what Ive got. I have a sheet called "Project Intake" where most projects source from. There is an auto number column called…
Is there a way to automatic indent rows by number? in my case with level column?
How to add a new row using Index/Match
Hi - I am using Index/Match to align a project intake sheet with a project scope sheet so that the same information (Project ID, Project, Project Description) show up on the scope sheet from the intake sheet. My primary is Project on both and I have the cell linked from the intake sheet to the scope sheet and then I am…
Stop autoformat to a percent
Hello, I have a form that collects information on a person's effort on a certain project. The field is left open & not restricted to a certain value as it depend on the person/project what is best to enter. The issue is that Smartsheet takes some of the values & multiples by 100 so that I get 100% to 500% showing often,…
Formula to Calculate Percentage Change from Baseline
Hi, We capture scores between 1-5 each month. I'm looking to create a formula to calculate the percentage change from the baseline based on the most recent month's entry in that row. For example, baseline (starting) score was 3 in June (captured in the column "June"). Let's say it's now August and the score is 4 (captured…
Countif a name from a list of multiple names
Greetings- I need formula help to count a name EMMA that is selected from a drop-down that has other names selected as well. Basically I need to county if Emma's name is listed in the Education Naturalist column that has other names included in the same cell. If I use =COUNTIF({Program Survey Range 1}, "Emma") it will only…
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
How to dynamically sum two different rows, same shet.
I can't view my post so i'm posting again sorry smartsheet's!…anyways, HELLO INTERWEBS HUMANS!!!, thank you for taking the time to read my word salad. What i'm creating: Time tracking workspace for around 60 employees. Has a lander page that accepts form submissions (clock-in /clock-out) (separate rows). User accepts…
Unable to Convert to Column Formula
Using this formula Smartsheet isn't letting me convert to a column formula: =[Material Received]@row - [Purchase Date]@row - [Lead Time (days)]@row

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