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.

Searching for a value in a multiselect column
I probably should be going to bed, but I'm going nuts trying to figure out one last formula. I have a sheet with a multiselect column named "Project Type". The column has the following values: Revenue Opportunity Revenue Loss Avoidance Risk Compliance Cost Saving I am trying to create a formula along the lines of: IF…
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…

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

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…
IF Statement to Display Symbols
Formula variable question for an IF Statement. Ok I have 5 columns (see screenshot below). This formula will be added to the one on the far right (Certification Complete). Now I would like to assign a value to each to trigger the symbol that will display. Basically the way it works is that all 5 columns are required, if…
Formula help needed - if/then
Is there a way to make my formula (below) that if the "type of CPG" says "priority" in it that it can be - 21 days and all other types would be - 14 days? hopefully that makes sense!

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags