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 statement based on date
I am trying to create a formula within my "Academic Year" field so that if the "Date" is more than August 25, 2019, the Academic Year field contents will be "2019-20" -- otherwise, the field contents will be "2018-19". =IF([Date]1 > (2019, 8, 25), "2019-20", "2018-19" I am using the date format (2019, 8, 25) based on what…
COUNT by Manager and by Product
I have a column called "Manager" and Product columns called Product1, Product2, Product3, etc and these are all checkboxes How can I do a count by Manager of Product? Example: Joe Smith * Product1 - 3 * Product2 - 10 Jennifer Johnson * Product2 - 12 * Product3 - 5 * Product5 - 10
Formula counting State
I have a column called "State". How can I do a count by all "State" and produce a chart? I want to avoid doing a formula for each State. Suggestion?
Value between dates
Hi Everyone, New smartsheet user here, I am trying to get a total cost between dates on a running construction schedule. I have different row-categories (Land acquisition, permitting, site work, construction, & selling) with columns showing start date, end date, and cost. All costs are positive, revenue (selling) is…
SUMIF formula with range
=SUMIF([Total Sales of Goods and Services]@row :[Total Sales of Goods and Services]@row, [Payments in Quarter]@row = "Q.3.18")) The purpose of this formula is to sum all totals of Total Sales of Good and Services if the Payments were made in Quarter 3, 2018; I'd like to make this formula workable per selected quarter for…
COUNTIF between Dates
I have a formula (see below) where I'm trying to get a count where multiple criteria apply. The first date range renders a correct count but fails once the second one is added. I've tried multiple iterations of the formula, this is my current one. If it is not clear from the formula, I'm trying to count tasks assigned to…
Using MONTH formula with a blank date cell
I have been using the month formula to create a month number from an 'Actual close date' column. however i get error when the source column 'Actual close date' is blank I can get the month number to work when dates are included with =MONTH([Actual Close date]4) and I can clear away error message if source is blank with…
Rollup Formula
I have a rollup sheet. I am needing a cross sheet formula to calculate total quote for a specific sales rep. See screen shots below. Thanks so much your help. I really do appreciate it!
Formula Help - Completed Projects Within FY
Hi there, I am looking to include a metrics widget on my portfolio dashboard for all completed projects in FY20. Our fiscal year runs 2/1/19 through 1/31/20 (or alternately, this could just be completed projects in Feb 2019 and after, then I will start a new count next Feb). My current baseline formula…
Monthly Turnover Time
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by finding the month and year but I'm not sure how to attach the turnover time days with its corresponding month/year . . .…

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