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.

Using Trend Arrows
I have a formula which works out the Net Days since an event occurred. I have the following: [Event Type], [Days Since Last Event], [Day Before], [Trend] The [Event Type] is the event I am searching for the number of days since the last one occurred. The Number of days appears in [Days Since Last Event], is a formula which…
Help Needed: Creating more efficient ways to update sheets
Hello, I am working on providing dashboards for my seniors. Here is the premise: I have multiple project managers (PMs) that work with four different agencies. Each PM has their own assigned sheet and assign an agency to the project. To create a dynamic dashboard, I am using a separate sheet (a table sheet) that pulls info…
Direction symbol in formula
I would like to use the direction symbol (up,down,sideways) in a formula if =IF([ISS-Backlog]1 < [ISS-Backlog]2,“Down”) but it is not working. Any help would be greatly appreciated
Count Ifs Dates in the future with multiple conditions
I am trying to create a formula will return a count of dates 21 days from the current date, but also sorted by an Assigned persons name and multiple statuses of the request. Here is a formula that I have so far: =COUNTIFS([Assigned To]:[Assigned To], "Name", [Status]:[Status], "Scheduled", [Start Date]:[Start Date],…
Formulas COUNTIF between to numbers
Hello, I am new to the Community. I am having such trouble with designing a formula that will use two past due days for which to count. Here is what I have for the 30 to 59 days count of past dues. =COUNTIF({Audit CAP Summary Range 1}, ">=30") + COUNTIF({Audit CAP Summary Range 1}, "<= 59") It returns a number but the…
Average Value Errors
Hello, Was hoping someone could see what i am doing wrong here; i am attempting to take the value of two cells and average them. Both are percentages. i use the formula =AVG([average calc]33, [average calc]34) and i get the "DIVIDE BY ZERO" error. From what i read this may be due to the particular column is a dropdown list…
Need Super Simple Formula (7 days before "Due Date")
I want a new column to reflect the date 7 days before an existing due date column. What's the formula?
Formula -- If next 4 Columns say Yes/No say something
Hello, I have a sheet with six columns. They are: Name | Current Step | Step 1 | Step 2 | Step 3 | Step 4 Step 1 - 4 have Yes/No written in them for completion status. Can I have a formula in Current Step to count how many "Yes" there are and print the Step? Can someone direct me to where I can find out how to code this? I…
Countif using Dates and another Range
I'm trying to use CountIf using the my auto filled date column and another column. The 2 parts of the formula I have come up with work independent of each other, but when I try to put them together I recieve the #INCORRECT ARGUMENT reply. Not sure what is wrong. Below is a copy of my Formula. =COUNTIF([Request Create…
Cross sheet sum if
I'm creating a sheet to record the use of agency/contracting staff across a site (once the proof of concept is done it'll be expanded to cover multiple sites), where entries will be added to the sheet below via form. The "within budget" column on the 1st sheet should be picking up any entry from the Month Total Spend (MTD)…

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