Formulas and Functions

Archives for August 2023

how to count the number of employees have Delta 320
I am wanting to count the number employees have delta in fleet and 320 in client. There are duplicate employee numbers in the emp_nbr column.
Creating a way to monitor trends using Forms, column formulas, automatic workflows, and dashboards
hi, I'm having issues with designing and getting a specific process automated. To be brief, I want to have a sheet that can be copied as part of a template that will automatically generate specific items in the column formula. This item is the URL to the form from this unique sheet. The form is automatically sent to…
Count how many cells are Delta 320
The formula I tried is : =COUNTIFS(Client:Client, @cell = "Delta", Fleet:Fleet, @cell = "320") but I got 0.
Filter COLLECT(RANGE) by IF Statement
Scenario: Trying to return a list of active record UIDs based on a common component ID reference value within the row. The following formula is doing 95% of what I need: =JOIN(COLLECT([Record ID]:[Record ID], [Component ID]:[Component ID], [Lookup ID]@row), CHAR(10)) Related community discussion - thanks to @Shanky Paul…
Countif Formula help!
I am looking to get totals for each employee (in the last 182 days) for each error type up in the master section but my formula isnt quite working =COUNTIFS(Staff:Staff, @cell = Staff@row, Date:Date, Error:Error, @cell >= TODAY(-182)) what am i missing?
How to set up a formula to get around timestamps?
I have the search send over as a csv, but it has the date field formatted differently than how Smartsheet sees date fields. I occasionally run into this issue when I use the date field from the system notes in NetSuite. Is there a formula that could be set up to get around this? I have the column set up as a date field…
Counting number of tasks per Assigned To contact
Hello- I have a sheet that includes a column of assigned personnel per each task of each project. Some tasks have multiple personnel, and I am hoping to be able to get a format where I can visibly see each individual team member and the total number of tasks they have. I went through past discussions, but could not find a…
How do I calculate an overdue date?
I have three potential approval date columns. How do I calculate the true overdue time in days? My current formula doesn't account for approval dates 1, 2, or 3 being populated to signal completion... =IF([Due Date]@row <= TODAY(), NETWORKDAYS([Due Date]@row, TODAY()) - 1, "")
Receiving Parsing error using NETWORKDAY formula
Hi, I would like to get the average working days between when a request is opened and approved. I am starting off with the following formula to calculate the net working days for each requests. Then I will add the Average formula to get the average of all requests. Here is the formula which is giving me unparseable error.…
Lead Time (Months) driven dates
Greetings, I'm working on a project plan template that uses lead-time (in months) for each task that leads to a recurring annual event. I'd like to have the actual start dates for each task driven by the actual date of the event when it's entered into a field. So for instance, if the event is scheduled a year from now on…

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

IF(AND formula
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
Formula with date column weirdness
Hi all! Happy Thursday. I have a formula that I created that is looking to calculate a number of cells that meet the specified criteria on a particular cell that inputs a date when a box is checked through an automation. What I am noticing however is that the formula is calculating items that are earlier than the specified…
Can I Reference Another Sheet in Table View?
I am trying to move more of my Grids over to Table View, but am not able to find a way to reference another sheet in Table View, aside from using the Dynamic Dropdown option, which is not what I need, since I'm working with formulas. Is this available in Table View? I haven't been able to find anything on it.

Formulas and Functions

Discussion List

Help Article Resources