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.

How to check parent row checkbox if at least one of the children row checkbokx is checked?
Hello, i am trying to find out how to check parent row checkbox if at least one of the children row checkbox is checked? Thanks in advance!
Nested IF function using negative percent values & RYG balls
I'm using a nested IF statement to determine the colour of RYG balls in Column 'YTD Health', using data from an adjacent column of percentages. The percentages listed are a combination of negative and positive values. What I want to happen is this: Values 0 to -40% = Yellow Values less than -41% = Red Values 0 and greater…
Counting only if conditions are fullfilled
Hi everyone, I was wondering if someone can help me with a formula for counting stuff? I've got let's say 4 stages of study progress - start-up, active, LTFU and completed. Now I've got a helper column to help me identify if the project code is unique as multiple resources may work on the same project. If it says "1" the…
Save Dashboard Chart as an Image
My boss wants to use some of the charts from a dashboard I created in a PPT. Is there a way to save the charts as an image ? If not, is there a work-around ? Thank you!
COUNTIFS one OR another criteria
Hello, I am trying to find the number of cells in a column that are blank OR do not contain a specific word. I believe the way that I have it right now would be AND rather than OR. Any suggestions? Need: If Accounting column is checked and Bio Status is blank OR does not contain "Posted" I'm currently getting 1 as the…
Unable to delete content of a column
Hi, Has there been a feature change? I used to be able to click on the column header and hit delete and the contents would be deleted leaving the column blank Now when i do it it only deletes the top cell? Any help or comments would be appreciated Thanks Dave
SUMIFS with Multi-Select Criteria
Trying to correct my SUMIFS formula include two criteria from a multi-select column. I'm currently getting UNPARSABLE every time try OR, AND, or HAS. Here's what I have so far with my current criteria, I just need to add an additional option for "CXL - COVID19" in addition to "Approved": =SUMIFS({FY Amount}, {FY}, FY 20 ,…
Help w/adding up formula totals
Hi team - I created a test sheet that I'm experimenting with various drop down menus creating scores. The drop down to score is working fine, where I have a problem is getting the "Total score" column to add all 5 scores. What am I missing? Total score formula: =VALUE([Impact score]@row + VALUE([SLO score]@row +…
Help w/nested IF statements with numbers that are between certain criteria
Hi team - I'm trying to create a nested IF statement that shows the following in the Status column: Green status is Total score 450 or above Yellow status is Total score between 449-350 Red status is Total score between 349-1 Gray status is Total score of 0 The Total score column is a formula that sums up specific columns…
Cell linking and updating a column
I have a master sheet that contains a column called "Product Family." This master sheet is updated weekly, and some of the Product Family rows change - added or deleted. The cells in the Product Family column on the master sheet are linked to another worksheet (called "Curation Audit") - also in a "Product Family" column.…

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

Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags