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.
Discussion List
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 with Countifs formula
Hello, I need help with the last part of the below formula( {Region}, "US" OR "CAN) ). I am referencing a column called Region on a sheet and I need the count to include if it has US or CAN listed. Please help in how I can make this formula work because I am getting an #unparsable error right now. =SUMIFS({Project Intake…
Formulas and functions in forms
Hi, When building a form I am wondering if there is any way to include formulas or other ways to use logic to solve the case described below: I have two input fields that the user will populate with numbers. Is there a way to compare the content of these two fields and then use logic to prompt new fields if content does…
Help Article Resources
Trending in Formulas and Functions