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.

Is there a way to restrict duplicate value input from dropdown in a Column?
Hello Experts, I have a lease document with list of gears. This a record of what is on lease. Once a gear is on lease, we cannot lease that gear to another person until it is returned. So I will have to select different gear from the dropdown for next lease. Is it possible to restrict duplicate value selection form the…
COUNTIFS when value falls between X and Y
Hello! So, my summary field for 00-30 days (using Days Open) works fine. I'm running into issues though on 31-60, 61-90 and 91-180...not sure the syntax for the range. Help, please :)!!
COUNTIFS
I know this should be easy but I just can't get it right. Trying to count instances of 2 different values in the same column. There are 6 options within the dropdown in the column but I only want to capture the amount of 2 specific values, "Seller Rep" and "Fee" Tried every variation I can imagine of this:…
Indexing Help with Children rows.
I have a sheet that is using parent and children rows. I want the parent cell to always show the value of the top most row in its child section . The formula I am using is =Index([Sample]31,1,1) . When I add a new row to this section the formula changes to =index([sample]32,1,1). I need the reference row to remain 31. I…
Using Index/Match with Two Values in Another Sheet
In Sheet 1, I like the prices for services for different vendors: Vendor 1 | Category 1 Service | $10 Vendor 1 | Category 2 Service | $20 Vendor 1 | Category 3 Service | $50 Vendor 2 | Category 1 Service | $70 Vendor 2 | Category 2 Service | $90 Vendor 3 | Category 1 Service | $30 Vendor 3 | Category 2 Service | $60 In…
Countifs with Column Formulas
I need a formula that will count if a course is completed and the month, for example =COUNTIFS(Month:Month, ="October", Status:Status, ="completed") This is returning the correct information. But, I am using a column formula for the Month and the COUNTIFS formula only works if the column formula is removed. Once I convert…
Can I convert seconds into mm:ss?
I am trying to convert my seconds into min/sec and can't seem to get any formula to work. Any help would be so great, thanks!
Date Range Formula Help
Can someone please help me to create a formula that returns the number of items with a "Permit Expiration Date" between 7/1/20 and 7/31/20 AND has the "360 Photos Have Been Submitted" unchecked? I've tried several "if and" formulas and they didn't work :( Thank you!!
Rank Function
Hi, How do I create a rank formula for the field, that only includes certain values from a row that meets certain criteria. For example the below image is the example. I only want to rank and include in the range active expenses. Can someone please help me.
Populate Q1, Q2, Q3 etc as per Start date and End Date
Hi Team, I have below 2 requirements - 1) Populate Q1, Q2 Q3 etc as per Start date and End Date, I am using the below formula but it is giving error =IF(AND([Quarter Start Date]@row >= DATE(2020, 8, 1), [Quarter Start Date]@row <= DATE(2020, 10, 31), "Q1'21", IF(AND([Quarter Start Date]@row >= DATE(2020, 11, 1), [Quarter…

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

I have a formula that I cannot get right
Hi, I am taking Justin Orazio's Smartsheet made Simple course. I am in the cross-sheet referencing class. I have watched him create the formula over and over but mine just doesn't work. It doesn't give me an error, but it also doesn't count up the number of sales by the month per project manager. Can someone help me? Below…
#Invaldi Operation when a date dell is blank
Trying to analyze multiple date columns against a current date to ensure the training has occurred within the last year and if not then flag as needing to be trained. But when I incorporate the various date cells for reference I get the #invalid operation error for the blanks. Formula: =IF(OR([DTMC & Trainer Training…
LookUp Results then Automate Resonse
Haven't had to much experience with smartsheet, other than setting up some connections and sheets. Trying to accomplish this automation though; I have a connection adding rows/updating rows when source changes. I want to make a form or dynamic view (if possible) that allows a viewer/user to enter a PurchaseOrderNo…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags