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.

Pull a first and last name from an auto email cell
I'm looking to pull a first and last name from an auto populated email address from a form. I want to auto populate a "Requestor Name" column based on the email that was generated. For example: Email - Joe_Smith@gmailcom Requestor Name - Joe Smith
Report building
Can I build a report that shows all items due in last 7 days and next 7 days, AND all items due if they are late (even if more than 7 days due?) I can figure out how to condition my report on both those items,
Bring back result based on condition
Hi all, Hoping I can get some help with a formula. I have a date column that I want to bring back a "health result" depending on the 'finish' date. For example if the finish date is past today's date then it would be red and there would be different thresholds for each date range. Is this possible? The "health result" is a…
Count occurrences of each variable of a multi-dropdown list
Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage: Preliminary - 5; Negotiating - 3; At Lease - 7, etc... What would I…
Help with an IF OR function
Hi, I am trying to write a formula that says that the status indicator in a column should turn red if either a) answer in drop down column is "No," or b) second column is NOT left blank (i.e., if someone adds information to the column). I have been able to get formulas for either of the two functions to work independently…
Filter & Total YTD
Hello, I'm trying to filter how many YTD programs I've held of a specific program. There is a column with many program names, and a column with Start Dates. How do I find the YTD total of a specific program? This is what I've come up with so far, but it keeps giving me errors. =COUNTIFS({Program Name Column In reference…
Setting up the best formula
Hi all Can someone please help me. I am new to setting up formulas and have been successful in doing a number of them on my smartsheet already however for some reason my brain has gone dead and I cannot figure out a formula. I have a column which is a checkbox, I want a formula set up to notify me how many have been…
Saved Filters Issue Date Type Column
I'm running into a very odd issue with consistent filtering on a date column thats being generated from a formula: We have a column labeled "Filter date" that is set to Date (Restrict to dates only not checked) which has the following formula to trim off the date from a 2ndary column that is a drop down: =IF([Date…
Count Responses for the Same Answer, for Multiple Persons
I created a survey and used the following formula to count repsonses; =COUNTIFS({2020 IS Employee Engagement Survey Range 3}, "Vin Miliano", {2020 IS Employee Engagement Survey Range 1}, "4 - Agree") The formula works fine for Vin, as his number of responses is 2. I also have another user, Tim, and his response is 2. How…
Summing Mixed Text and Number Column
Greetings. New to Smartsheets. First time question. I have form entries that looks like this: 333 . 11111 - Parts 333 . 22222 - Service I want to sum all entries from the form that begin with "333" and I cant seem to make it work. I dont want to divide my columns. I'm currently using a SUMIF formula and playing with a FIND…

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

How to update certain cells in column based on one cell's input and other column's same ID #?
I have a very simple test script testing tracker located here: I want to be able to do one of the following: 1. Update the Status column for all testers with the same test ID to "Duplicate" once one person tests and puts "FAIL" in the PASS/FAIL column. 2. Do not copy defects to defect tracker sheet if one of the rows with…
Duplicate Formula
I have a Smartsheet which is fed from a form an Intake team is using to gather prospect information and we are having issues with duplicate entries. The sheet/form has a field for prospect first name and another for prospect last name which we would like to check for duplicate entries of. I created a column combining both…
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags