Formulas and Functions

Archives for March 2021

Multiple IF Formulas Based off a Date
Hello Everyone, I'm trying to create a formula with multiple IF statements. So far, I have the following created: =IF([OH Date Qualified]@row < TODAY(-1080), "Designer 2"), IF([OH Date Qualified]@row < TODAY(-1800), "Designer 3"), IF([OH Date Qualified]@row < TODAY(-3600), "Designer 4") However, the above formula only…
ISBLANK Formula
Is there a limit to how many nested IF statements you can have in one formula? I have six columns and trying to pull data for dashboards based on the content in each column. Only one column will be populated with data depending on the project plan type. But I cant seem to get this formula right? Can anyone see my error??…
Pull a List into a Dashboard
I am creating a dashboard to summarize the work being done across multiple different projects. One metric I want to include is a list of the program officers. I have pulled a list of all the project lead names and identified the duplicate values (when a project lead is assigned to multiple different projects), but now I am…
Countif in multi select cell
Hi I would appreciae some help please I need a formula the will total the number of enquiries in a column named status that has several other options in the multi select box but from 31/12/20 as opposed to giving me the total for the last 5 years! Thanks
Subtracting Dates between 2 cells - #INVALID OPERATION
I am using the below formula to subtract 2 cells that contain dates. I have determined that the error is the the operation on the subtraction of the row date from a fixed / start date. =IF(AND([Column18]8 = "Day 1", $[Column22]$6 - [Column14]8 > 0), 1, 0) see pic
Quantity in cell to rows
Hello, I have a column named "Quantity" and the cells of that column, I have numbers (any number). Is there a formula or a function that can create new rows (specifically of the quantity) in that sheet or another sheet automatically? Is that something this is automate-able? Example: If cell A1 in Sheet 1, has a quantity of…
triggering a workflow by a system date
I'm trying to trigger a notification based on Creation Date (auto-date) + 30 days. I hope I'm just being thick since I would think this to be a fairly common type of workflow. Unfortunately system date columns cannot be used to trigger a workflow, unless I'm missing something. At this point I think I need to create a…
How to count a singular thing in a multi-drop down response list
Hello, I'm trying to count a response to the question community services a patient receives, there are multiple different choices as you can see here to the left. The problem that I'm having is when I'm trying to find the number of "Outpatient therapy" responses I'm only getting one. Here's my f-code. =COUNTIF({SOC…
I am trying make send weekly schedule from full planned schedule
Hi, I have full planned PM Schedule. I want to set automation for only next week schedule from the full schedule. How to do that. I am fairly new to the smartsheet.
Match Cell Content in New (Form Provided) Rows with Content in Previous Rows
Hello I am looking to use a formula to bring an entry from an existing cell into a new row when another column in that row matches. I will be deploying a Smartsheet webform, and when the last name of a respondent matches in a new response, I want that new row to automatically contain the Dropbox folder for recorded in the…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Upcoming Events

Brandfolder Collaborator User Guide
Get ready to seamlessly upload and organize content within your Brandfolder! This on-demand session is designed to help you become a confident contributor and collaborator, ensuring your team has the right assets at the right time. What You’ll Learn: Maximize Features in the Asset Modal: Learn to navigate the asset modal,…
Brandfolder Admin User Training
Managing digital assets doesn’t have to be complicated. Join us for this two-part, on-demand webinar series designed to give Brandfolder administrators the confidence and skills to create smooth, efficient workflows. Whether you’re just getting started or ready to optimize your setup, these sessions will help you unlock…
Smartsheet Customer Success Onboarding (Japan)
Smartsheet カスタマーサクセスオンボーディングは、Smartsheet についての基本を学びたい方向けに毎週開催しているインストラクター主導のトレーニングコースです。ウェビナーは、始めるための基本、共同作業、およびさまざまな方法での作業の視覚化の基本など、Smartsheet のご利用を開始するために必要なすべてを網羅しています。

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Help with a formula or formuals
I have 3 columns: Vic By plate number and model, Date Driven(Date Field), and mileage. I am trying to fina a formula or formuals to allow me to see the difference in milage since the last time the plate number has driven. Bonus: In 1 month. Trying to find an easy way to see priority of which vehicle needs to be driven next…
Stuck on a COUNTIF formula to use
Hi all I'm still trying to get my head around Smartsheet formulas with mixed success, many times i try to use the AI formula creator but it often fails for me… Im trying to create a formula that addresses the below AI query that keeps either returning an #Unparseable error or #Invalid Data Type. Basically, in my sheet i…
Is there a way to break out found Rows from a LInked Sheet into sequential rows in a new sheet?
Hi folks. Let's say I have a sheet with the following data: Then I make a second sheet that links to the first, looking for matches of both the Name and Date. What I want, in this second sheet, is to eventually show that on 12/25, Matt is Eating a Sandwich (first row of new sheet) and Using the Toilet (second row of new…

Formulas and Functions

Discussion List

Help Article Resources