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.

Formula Question
Good Morning. I am attempting to create a forumula which references another sheet; however, I continue to receive error messages or it doesn't calculate correctly. Below is the outline of what I am looking to accomplish. Let me know if you can help. One column called Program with drop down options of Service Expansion,…
Formulas...CountIfs I believe
In process of creating a formula and I can't seem to get it to work correctly. Any feedback is welcome. I have two columns. Both are drop downs. Column Program: A, B, C Column Status: A, B, C, D, E Would like to create a formula that will count how many A's are in Program column WHEN Status column is b, c, or d All…
Check if a row is parent and starts with "abcde"
Hi, Please can someone help with a formula to find if a row is parent and at the same time has a text that starts with "abcde".
Help with fuzzy match formula
I have no idea how the program thinks that the number 2 even approximately resembles the word "Sparks Corp". I want to use fuzzy math to find the closest vendor name to the one that is typed in, and was hoping to use the approximate match, but am having a hard time understanding what the program believes is approximate. I…
Counting Projects that are 1 Week or More Behind Schedule
Hi Everyone, I got a great formula from Customer Success that I thought I would share. I wanted a way to know if a project was at least 1 week or more behind schedule. This is what Customer Success gave me: =COUNTIFS(Finish:Finish, TODAY() <= TODAY(-7), [% Complete]:[% Complete], <>1) This formula counts tasks that are 7…
IF statement formula needing help
I'm needing help completing a formula. The formula that is needed will look specific data in column "A" then specific data in column "B" with the result of these to coming from a different little grid. I've got the 1st (A & B) correct but can't seem to get the 3rd criteria to pull correctly. =IF(ISBLANK([column 1]3:[column…
Automatically Generate Decision Log from Action Item List
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…
Formula Counting Courses Required /Taken
All, Have a smartsheet that shows by student (each row is a student) what course they are required to take. The student updates the date they completed the course via update requests. Based on this smartsheet I am trying to find a formula that will show me when they have completed all courses that they are required. The…
COUNTIFS Question
I'm having an issue understanding COUNTIFS in my scenario. I'm trying to track billable hours, and I'd like to summarize the hours value listed if another column equals a specific value. So I can track how many hours go to which projects. I believe COUNTIFS is the right formula to use, but not sure how to apply it. Any…
RYG Automation based on "overall Score" Column
We do a customer follow up for every job we do. We ask 3 questions rated 1-10. If "Overall Score" column totals 26-30 points - green ball 20-25 points - yellow ball >20 points red ball. I can get the column to automatically put the word of the colour in, but not the actual ball. Is there a formula for such a thing? Thanks…

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

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day
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…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags