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 COLLECT / MATCH COLLECT / INDEX COLLECT / VLOOKUP ?
Dear Community, I am trying to have an automatic filling of the column [Budget Max] while changing the column [Level] based on 2 other columns references: [Level attribution] and [Max Budget Range] with matching ROWS. If [Level]value = [Level attribution]value return [Max Budget Range]value of the same ROW of [Level…
Using SUMIFS, on a column that displays a $, based of a formula
I am looking at tieing 2 sheets together. My data sheet has a Column A, that is a check mark or not. Column B has a formula of "=IF([Column A]1 = 1, "$2"); therefore, it displays "$2" Column C has a month number, "01" I want a sumifs to sum all column B. But it display $0, and am assuming its because the formula in column…
IF/AND Statement with CountIf
I'm trying to create a formula that will look at my "Measurement" column for the text "PBI" at the beginning of this formula: =IF([Rank/Actual PTR]434 > [Score/Goal PTR]434, "PTR Exceeded", IF([Rank/Actual PTR]434 = [Score/Goal PTR]434, "PTR Met", IF([Rank/Actual PTR]434 < [Score/Goal PTR]434, "PTR Not Met", ""))). So, I…
Formlua Help
I need some help with creating a formula in smartsheet that works in excel. I'm created a formula in excel that split apart the employees year and month of employment. When I import it into smartsheet I get an error and not sure how to fix it. I also would like to create a formula that pulls over the correct accrual based…
If Checkbox is not needed, show blank
Hello Smartsheet Gurus, I have a spreadsheet that has a few columns as checkboxes, but when the checkbox is not needed, I want the cell to show nothing. Is there a way to do that? Thanks, Arryn
Create a Formula that compares Dates in 2 Columns and Counts a Total
Hi all, I am trying to write a COUNTIFS formula that compares multiple criteria. I need to Count all items in a column that have a status of "Completed" (column A), IF the items also have an Actual End Date within 2019 (column B) , and the Actual End Date is less than or equal to the Scheduled End Date (column C). I cannot…
IF / THEN Formula help
Hello, Im quite new to Smartsheets and was hoping for some code assistance. What i am trying to do is as follows: 1) Search a column (column1) in another sheet for a value, say 5. 2) When it finds that value, count how many checkbox's in column2 has been ticked Im trying to use an IF([column1]=5, COUNTIF(column2),1),0)…
IF/AND Formula
I am trying to create a formula to track invoices that are completed under 30 days. If the number in the "Invoice Duration" is less than 30 I'd like the next column "<30 Days" to populate with "Yes" If the number in "Invoice Duration" is more than 30 I'd like it to populate "No" Thank you for all the help!
Calculating time
Hello Does anyone know if there is a way to calculate Time in smartsheet without using a 3rd party program? Thank you.
SUMIFS criteria headache
Hello all, Typically, building a formula through Smartsheet doesn't give me any issues but the SUMIFS formula specifically within Smartsheet is making me pull my hair out. I have 3 columns that I need to use in the formula. -Job Code -Needed Position Headcount -Building Status I need to add the total headcount of each job…

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

Index/Collect while meeting specific criteria and doing math
Good afternoon community, I'm in need of help with a formula that I feel has come close, but still just off of the mark. I have three sheets: The first is holding static data (Inventory Cost sheet). The second sheet (Tool Inventory) is where data comes into the sheet from a form and some math formulas do calculations based…
Issue with Highlighting Columns that have different values
I have a sheet where I am tracking values from one month to the next (values imported using DataShuttle). I want to highlight the columns where the values are different, using a helper column: =IF(Bananas@row = [Previous Bananas]@row, 1, 0) However, I am having the formulas return 0s when the formulas are NOT DIFFERENT.…
Net Days between a previous day and today.
I have the following columns Comments Date of Last Attendance Weeks Not Submitted Under "Comments", you might see something like "Last Attendance Day: 11/01/2024." I used =RIGHT(Comments@row, 10) to get the Date of Last Attendance. I need to determine how many days it has been since that date using today's date, and divide…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags