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.

Select a Value in Dropdown Cell Using IF Formula
I want the LabWare User Status cell value to be Pending if the checkbox in the Request LabWare Account cell is Checked. I've tried IF ([Request LabWare Account]@row = "Checked", "Pending") and a few other formula variations inside the LabWare User Status cell but it looks like formula's cannot be used to select or apply a…
Numbers won’t add up on construction template?
It has to be easy? Or the way I copied and pasted? It’s the template for construction estimate? Some of my numbers won’t total-and the very top number for total for entire estimate won’t populate?
Leveraging Forms for Auditing
Help! I'm looking to use Forms as an auditing tool for our team. Here's the use case: When we're working with providers, we need to track when they meet all of the necessary criteria. We've been using a Google form with radio buttons: How do I replicate this type of form in Smartsheet? The biggest issue is when we have…
Add date to formula
Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date" with dates (2/20/2021) in them. I want the total number of slides in the next 30 days. Could you please…
IF formula from multiple cell information
I've been tasked to show the approval status of a row. Due to how I created the automation, depending on the level of an award (same sheet as referred to recently) the Manager signer may show status in 1 of 3 different columns. I want to do the colored circles at the beginning of the row. Would do gray if the column is…
I am trying to determine how many cells fall within 60 - 90 days
=COUNTIF([Expiration Date]:[Expiration Date], <=TODAY(90)) I need it to bring back the results that are 61-90 days from today. I'm sure it's something simple, I just can't seem to get it to work. Thanks!
Manpower Projections w/ Multiple Schedules
I have several projects and we are inserting the schedules into Smartsheet and linking those with various sheets. One thing I would like to create is a sheet that pulls in Crew Size from each job and for each date range display the labor needed. In each schedule, I placed a column for estimated hours and then used a…
Finding the biggest date
Hello All, Have no clue on how to approach this. I have 2 smartsheets as follows: Main SmartSheet: List of main projects and associated ID number. Sub SmartSheet: List of sub projects linked to the main project through the ID number with status and due dates. Hence I have multiple sub-project for each project with due…
How to add a sum based on an array formula ?
Hello everyone, I am new to the forum and I am French so please be indulgent when reading it. 😉 I allow myself to contact you because I cannot transform a formula that works in Excel: =SUMPRODUCT((ISNUMBRE(SERACH(D3;TEST!AE:AE)))*1) So can you help me solve my problem? Cordialy, azerty64
Is it possible to create a VLookUp Dropdown list in a Smartsheet?
We are trying to map categories to specific subcategories, and would prefer to only have the subcategories that apply to each category appear in the dropdown list, rather than all subcategories as is appearing right now. Is there a way to create some kind of VLookUp dropdown list or something similar, so that only the…

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

Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
NEED TO ADD DAYS TO THIS FORMULA IF ANOTHER CELL HAS SPECIFIC ITEMS OF A DROP DOWN.
I have this formula that works for this cell when information is missing from reference cell A. However now we want to be able to add additional days if reference cell B has specific items checked in a dropdown. I just can't seem to get it to work. Any suggestions. =IF(ISBLANK([ ENGINEER (tentative start date)]@row), "",…
Help with Average Formula
Hi there - I'd like to ask for a hand to calculate an average formula. This is a cross sheet formula where I want to aggregate an average time duration by Assigned To, by quarter. (I also have instances where my time duration is zero - I think that was causing me a divide by zero error). Metrics sheet/destination: Source…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags