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 Text
I am using this formula and everything looks okay but the text that shows up for "Delivered Early" is showing up in the field as 0Delivered Early. I don't know why. =IF([Days Late / Early]3 > 0, "Delivered Late") + IF([Days Late / Early]3 = 0, "Delivered On Time") + IF([Days Late / Early]3 < 0, "Delivered Early")
Random discontinuation of formulas in sheets
HI all! I have a several sheets with formulas. Normal, as almost every user of Smartsheet. I wonder if anyone else has the same issues with formulas as me. Sometimes, for long time my formulas are copied automatically from row to row without any problems, but randomly, without any reason system stops doing this and I have…
Cell amended date
Is it possible to write a formula using the date that a cell was last amended?
IF Function and Checkboxes
Hi, I am currently working on a project where I will have multiple check boxes on a row where each checkbox is going to of different values (true/false). I need a formula that will look over the checkboxes and only give me the value of the selected checkbox and then with this the value of that cell with be presented at the…
Nested IF/AND formula
I am new to smartsheets and I am having a hard time with a formula, hopefully someone can help me. I am trying to create a formula that will indicate the status of a task based on the following condition: * whether the task is completed or action is required * whether the task is at risk or not To conclude this is what I…
IF(AND) Function: Invalid Operation Response
Hi All, I'm trying to implement an IF(AND) function within my sheet that is dependent on a number of other conditions on sisters sheets being true to display a string and if false, a separate string. My formula is this: =IF(AND({Experiment Tracker Range 3} = "MEMS 1", {Experiment Tracker Range 4} = "1", {Experiment Tracker…
Conditional Weighted Averages
Hello, I want to use the AVGW function to get the weighted average of the column "Cost" against the column "Probability of Cost" but only if the column "Status" is Approved. The column "Status" can also be Pending. The function SUMIFS works great if you don't need to do the weighted average. Is there a preset function or…
Please help with an a SUMIF formula
I have a spread sheet with a column (with a formula) that counts how many days it took for each project to get from one department to the next. I am trying to figure out a formula to add all those days together but just from a specific month in 2018... I will eventually have to do this for each month for the next couple…
Project Team Resource Allocation
Hi, Can anyone share how they're tracking their teams resources? The resource allocation is great however, it only allows me to show one team member not multiple per task. In addition, I'd need this information for executive reporting to support my teams concerns of being over allocated across projects. Thanks!
Auto changing status based on due date
Hi, i am hoping this is possible and someone can help? We have created a sheet which is populated from a form and is working really well. We populate the "Required completion date" base on the type of issue and this is automated and again working very well. What i would like to achieve is an automatic change to the status…

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