Formulas and Functions

Archives for March 2021

No of CVs sent by role and month
Hi all I’m trying to create a formula to show the number of CVs sent by month and role So number of CVs for Delivery Managers for October (pic below) is 18 but how I do I get this from a formula? I can get the number of CVs for all of October using a simple =SUMIF formula but when I trying adding in the role, it breaks!…
Formulas | Green, Yellow, Red Health via Due Date
Howdy all! Long time researcher, first-time hair puller-outer :-) I'm hoping to create an automated RBY Health Column in my sheet based on the due date. I tried modifying some formulas based on what I've seen in other threads, but I'm really struggling and hoping to get some help from this community :-) Long and short, I'd…
how to set the timestamp in a cell if another cell (status) has changed
Hi all, cell "status" is set to "open", "work" and than "finished". I would like to set cells "open status date", "work status date", "finished status date" with the timestamp of the change of "status". How could this be done? Workflow is not able to set the value of a cell :-(. Thank you
Nested CountIf function
Hi there. Is there a such thing as a nested countif function?? I'm aware of how to use the countif in smartsheet... =COUNTIF({ Test Sheet Range 3}, "Approved") Suppose I want to count records with more than 1 criterion? Status = Approved Stage = Stage 1 How would I craft that out? Is it a nested CountIF function?? Thanks,…
Countifs OR
I'm trying to count how many match the first (Location) and second (Status) criteria, and then match one of the third (Position) criteria: =COUNTIFS({Location}, "Wisconsin VAC", {Status}, "Offer in Progress", OR({Position} = "Applicator", {Position} = "Registered Nurse", {Position} = "EMT", {Position} = "PA/NP")) Thoughts?
How could I lookup for two column data and return the other column info?
For example, I want to look up lot number and QC test ID in the table below and return test results and final disposition ready?
Current Year Month in a count formula
I'm having problems finding the right syntax to count the number of records for the current year month. My sheet may have records from several past years but I just need to count the number of records by month for JUST for the current year - even if I must update the formula each January - that's ok. My basic formula for…
Link cell within same smartsheet
Can one link cell(s) within the same smartsheet? Looks like I can only link from another sheet but not within the same sheet? I was trying to link cell within the text/number column.
Index/Match with duplicate data
I have having difficulty with my formula. I am trying to create a formula that will decipher between the different name of data with the same usage numbers. You can see on my attached pictures that 3 stations have utilized our program 30 times, however, it only identifies the name of the first station rather than…
Invalid Data Type Due to blanks
Could someone please assist me with writing the following function? I have tried plugging in IFERROR but it keeps throwing back an error, likely because I am not writing it correctly. The Start Date will sometimes be blank, and I am tracking the frequency of each Request Type for a month over month report, (eventually year…

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

SUMIFS keeps returning 0
I'm trying to display a sum of the column Total Funds Available when Status = Apps Open, and Value Score = 5. Here is the formula I have: =SUMIFS([Total Funds Available]:[Total Funds Available], Status:Status, ="Apps Open", [Value Score]:[Value Score], ="5") There are rows that meet these conditions and should display a…
Create Sequential, Unique ID for certain rows as column formula
I need a column formula that can add sequential, unique IDs to data like this coming in from a form: Task Type Task ID Manual M001 Automated Manual M002 Manual M003 Manual M004 Automated Manual M005 Task IDs that aren’t the manual type need sequential numbering within their type (i.e. A001, A002, etc). Here’s the kicker:…
Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…

Formulas and Functions

Discussion List

Help Article Resources