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.

N/A Column leads to #DIVIDE BY ZERO
I'm working on an onboarding tracker where I'm using an "N/A" checkbox in order not to count the modules that individuals aren't required to take. I'm using another checkbox to represent "Done" and the percentage complete - =COUNTIF(CHILDREN(Done16), 1) / COUNTIF(CHILDREN([N/A]16), 0) If an entire module is chosen as "N/A"…
Issue with CountIf not correctly calculating
Hello, I am using the formula =COUNTIF(CHILDREN(), 1) + "" to count the total number of checked check boxes. However, The number displayed is 0 when I can clearly see the box is checked in that column. For other columns it displays a number but not an accurate count of checked boxes within the column. Is there a different…
Using COUNTIF and SUMIF with dates
Hi everyone, I need help understanding how I can use dates in COUNTIF and SUMIF formulas. I have all other parts of the formula working but as soon as I try and add a date condition at all it fails. What I need is something that makes it include all rows where the date in the column Date Closed is the current month. My…
Simple formula to show if two cells match- what am I doing wrong?
Hey everyone, I am having trouble with what I thought would be a simple formula: I have a sheet that is drawing information from two different sheets via cell linking and a SumIf formula: Total Order Cost, which is linked to one sheet and Invoice Total, which is summing all cells that match my primary column, which is…
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…
If/Or formula wit a Checkbox.
I need to color a ball yellow if the value in a column is between .05 and .15. If the value in the same column is greater than .15 OR a checkbox is selected, I need the ball to be red. Not sure how to accomplish this. Appreciate your help.
Checking Some Children Rows but Not All
Hi everyone, I'm somewhat new to Smartsheet and I'm still learning about formulas and functions. I have a parent row and 4 children row. If all 4 children rows are checked, that's great but it's most important that the last 3 are checked in order for the parent row to automatically be checked. I set up a function.…
Search Projects as Per RYG status
Hi, I looking for solution or moreover a formula to get a project name back as per RYG status. But i am getting problem, i have a same RYG for more then one projects. For example: i want a list of projects As RYG "RED", the selection has to show me 2 projects in retuen Project 1 Red Project 2 Green Project 3 Yellow Project…
Scientific Notation
Is there away to get smartsheet to recognize scientific notation in order to add, subtract, multiply, divide, etc.. Thanks
Total Sum By Month selected on Dropdown
I need to be able to select to view the total cost of children by a certain month. Currently, I have the dropdown values of all 12 months. I have the formula to the right of the dropdown calculating the total cost recorded for each child. But based on a different month, I want the value to change based on the date recorded…

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