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 のご利用を開始するために必要なすべてを網羅しています。
Smartsheet In Person User Group | Raleigh
Connect with fellow Smartsheet mobilizers and advocates! Join us at our in person user group in Raleigh, NC on Jan. 15. This is a great opportunity to discover how other local users are optimizing their use of Smartsheet. *Get inspired: We'll learn from local users, who will share success stories on how they use Smartsheet…

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Symbol Return Formula
When I use a formula to return a symbol for example =IF([INC/DEC]@row = "INCREASE", "RED", "GREEN") It just returns the word RED I have the column set to symbol but still can't get it to work…
IF Formula Not Working As Intended
Hi everyone! The below formula is not populating a 0 in cells that are new, as intended. The AI tool even says this formula should work, but it's not. After staring at it for hours, I can't figure out where I'm going wrong. Your help would be greatly appreciated!! Thanks! :) =IFERROR([Date Logged]@row - MAX(COLLECT([Date…
Cross Sheet Reference
Trying to create a cross sheet reference that counts #s from a specific column in another sheet. =countif({Am-Van: Vehicle List Range 1},[Type of Service]:[Type of Service], "BLS") Comes back as #UNPARSEABLE The COUNTIF statement works in the referenced sheet but not when it is cross referenced. Is there a comma or bracket…

Formulas and Functions

Discussion List

Help Article Resources