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.

=If Formulas
Hi! I am attempting to create an "=If" formula that has 21 "if_then" statements. When I get to the end my formula enters as "Unparsable." Is there a limit to criteria in a formula? Thanks!
Formulas to durations or equivalent
I am building a production scheduler with a built in calculator where by the operator can adjust the labour allocation to test the duration output. My problem is Smartsheet won't allow durations to be edited by way of a formula. Also I am wanting the variables to be as follows: Completion Date - Constant (fixed) Variable…
Children Formula
How can a change this formula to use children in a hierarchy instead of the cell references so when I add a row into the hierarchy it returns the correct value without re-setting the range? =SUMIF([CQA Status]41:[CQA Status]61, "Red", [No. Cols]41:[No. Cols]61)
Clock Hour Progress Management
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…
Round Up
I have a calculation for Total Hours that takes the DURATION (set to days) multiplied by UTILIZATION percent, then translates to hours by multiplying by 8 hrs. I want the result to always be a whole number: "round up" to the next whole number if the decimal is greater .25, otherwise round down. Currently, the formula in…
Printing cell history value
I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet. Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and…
SUMIF across a range
Hi All, I'm trying to use SUMIF to sum the total of all rows that meet a specific criteria * =SUMIF([SERVICE TYPE]:[SERVICE TYPE], "Monthly Charge", [2017-12]:[2018-01]) This however returns #INCORRECT ARGUMENT. Not sure what I am doing wrong. Any suggestions would be most appreciated. Regards Colin
How do I - formula ques
I have a formula =COUNTIF(Age8, >65) which is working, but I want it to only give me a count if a certain checkbox field is checked. Is there a formula for this?
SUMIFS Formula Needed for Multiple Calculations Summing from the Same Column
I am working on a budget sheet, and need to be able to calculate OPEX expenses per site, and CAPEX expenses per site. I've got 6 different sites, and need these totals for each quarter. The formula below seems to work, but I can't use it more than once within the same column without getting a circular reference error. This…
Turnaround time for the month of...
I have a sheet with thousands of projects. When a project is finished there is a cell that automatically calculates the turnaround time. There is also a column for the date the project was finished. The projects are not ordered by date. On another sheet I need to calculate the average turnaround time for a given month for…

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