Formulas and Functions

Archives for October 2021

How can I hyperlink more than one sheet to a cell?
I have the desire to attach more than one reference sheet within smartsheet to an individual cell. Is there a way of doing that?
Adding a COUNTIF to a COUNTIFS formula?
I have a COUNTIFS formula... =COUNTIFS(Status:Status, CONTAINS("In Progress - On Track", @cell)). I have another formula that I need to add to the =COUNTIFS forumula... it's =COUNTIF(Level:Level, =0) . How would I combine the two?
Using IF and CONTAINS in one formula
I am trying to create a formula that returns: Tolerable if the answer is Low Tolerable if the answer is Medium Acceptable if the answer is High Acceptible if the answer contains Urgent. I need to figure out how to use "CONTAINS" because some answers have dashes and other things that mess up the formulas. =IF(Answer@row =…
Date Formula Issue: #Invalid Value
I am a complete novice and I have been tasked with fixing someone else's formula. I have seen a number of responses to similar problems with other people but their solutions are not working for me. My formula is supposed to calculate a date 3 months later. For example, in column 1 the date is 10/01/2021. In column 2, the…
Trouble filtering 'old' rows based on an AND condition
Hello, I have a sheet with a Modified (Date) column and another column with a status indicator in the form of a dropdown menu. I am trying to make a filter that shows all rows where the Modified (Date) date is 100 days in the past AND a specific option (stand-by) in the dropdown menu has been selected. I have tried using:…
Security Measures
I am looking for direction on how to best control access to sheets once an employee is no longer with the company. I plan to have over 100 employee's with access to a dashboard that contains information that if they are no longer employed should really not have access to. Aside from trying to ensure I am notified at each…
Smartsheet Limits
Is there a page where I can see all of the limitation in one place? I created a large program using this application and I keep stumbling upon issue after issue and keep patching each issue individually. If I can see all limitations, it would allow me to be a bit more strategic in my approach to refactoring. For example,…
#circular reference
Hi everyone, I am still learning the way of smartsheet but I do feel that I have a good general understanding of how it works. I am currently struggling with a circular reference that just wont go away. Well sometimes it does. Here is what happens: I have 2 sheets one sheet is called controls and the other sheet is a…
How to calculating the age of a cell in hours
Background - I have a Form, which outputs as a row in a Grid, an extract of which is as follows - The 'Date Raised' column contains a System-generated - Create (Date) value, and the 'Current Date/Time' column contains today's date (using the =TODAY() function). Problem - I am trying to find a formula-driven solution, which…
How to exclude weekends
how to exclude weekends for duration column if in project settings weekends is allowed?

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

IF statement help
Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error. It's important to note that both columns are numbers. My original formula was: =IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0) However,…
SUMIFS using Dropdown
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
Date format issued from date formula not recognized as date : message #DATE EXPECTED
Hello, I face one difficulty trying to transform text in date using DATE formula I want to find the first day of a week based on the week number & year number put in a cell For instance in a cell I find "25-45" FOR Year= 2025 & Week= 45, so I look for the monday of this week that should be the 3rd of nov Step 1 find first…

Formulas and Functions

Discussion List

Help Article Resources