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.

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…
Automated Emails are not coming from the Owner of the Sheet
Hello, I have a formula set up to identify when a target completion date is today's date. The Automation then checks to see whether or not the formula is displaying true or false and sends an Automated email to the assigned user. Normally these emails show me as the person that has sent the update because I am the owner of…
Conditional Logic in Forms
Hi @Andrée Starå I was trying to replicate your two-form solution, however I could not access the back end. I am trying to create a Parent / Children in the sheet where in the user could provide # of lines when " Total value of order lines to be released" is selected. Would you help me on this? Thank you and appreciate…
Lookup formula instead of value
I am trying to use vlookup to use a formula based on the lookup value, instead of used nested if statements.. is there a way to return the formula instead of the value on the lookup tablet?

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