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.

Report or formula that shows rows not modified for MORE than 30 days?
I understand that a report can show rows modified in the LAST 30 days, but is there a report function or formula that shows if a row has not been modified for MORE than 30 days? Thank you!
Column Formulas and Summary Block
I'm loving the new column formula feature. However, is there a recommended best practice for how this impacts Summary Blocks for which the column formulas to not apply?
Auto Populate dates
Good Morning, Is there a formula that can be used to auto populate dates? For example, I have a date for first visit created, but want a date to populate for "send reminder" 30 days prior to visit and 30 days after. I have created the other columns.
Formula for transferring information between columns
Hello, I am looking to transfer the numeric value from the column named Dept name to the Dept # using a formula. The Dept Name information is autofilled from a form. I would like when a single dept name is selected for the numeric value to autofill in the Dept #. If multiple Department Names are selected I would like it to…
COUNTIF WITH MULTIPLE CHECKBOXES
I have a column called Systems. This allows users to thick multiple checkboxes example "Lighting","CCTV","Intruder".... I would like to issue reports using the COUNTIF formula if the value of Systems has for example "Lighting" ticked in the checkbox. When using COUNTIF it will only count the row if "Lighting" is the only…
Please help with lookup / index formula where there are multiple instances of the search value
Hi All, I am new Smartsheeter and having difficulty in finding the correct lookup / index formula where there are multiple instances of the search value. I have tried a formula which works in excel (Index / Small / Row), but "ROW" is not recognized in Smartsheet. In a nutshell, I have a master sheet with a list of clients,…
Excluding Zeros from an Average Formula
Hello, I am creating a simple dashboard showing the average percent complete for a portfolio of projects. We have now decided to carve out those projects not yet started (0% complete). How do I edit my formula to carve out those projects that are at 0% complete? =AVERAGEIF({Information Technology Business Plan Range 2},…
Counting days worked over a specified date range?
Is there a way to count the number days spent on a task within a specified date range? For example, in the first line of this image, I want to count 3 days spent in the week of August 30, and 1 day spent in the week of September 6. I'm trying to create a summary of how many days were spent on a task over any given week.
Resource management
I was trying to use the resource management function of Smartsheets, but that really is not giving me what I want and it is pulling from sheets the Assigned To is on, but I do not want to include in my resources. So I thought I might be able to create a formula. My Assigned to person has 40 estimated hours of work Actual…
Creating a COUNTIFS Formula within Multi-Select drop down column to get a % figure
Hi, I've created a tracker that captures information on the make ups of Boards. One column is called 'Diversity' and has the option to multi select either "BAME" or "Disability" What i'd like to be able to do is to Count the number of times either BAME or Disability is chosen and then divide that by the number of entries…

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 the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags