Formulas and Functions

Archives for June 2021

Formula is not Generating the correct value
So we have a formula in column labeled "Section 1 ended" - =IF([Column A]@row > 20000000, "10", IF([Column A]@row < 1000000, "2.5", IF([Column A)]@row > 10000000 < 20000000, "7.5"))) and it generates correctly. However, when I try to then use the value from that formula in Column B to multiply by 8 in another formula, it…
Counting how many sales were made this week, starting the count from Monday
Hi! I would like to count number of sales , depending on the date that the sale was made. Also the week should update every week, and I've found this formula: =COUNTIF({Sales Data}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY())), and it works, but is there something else I could add to it so that it will start…
Count when multiple drop-down selections are chosen
I have a "Project Type" column that allows for multiple drop-down selections: Manufacturing Site Change, Process Change, Vendor Change, etc. I am trying to count each individual project type even if multiple selections have been made in a single cell; e.g., if I've got Manufacturing Site Change and Process Change both…
Daily/Weekly Count Formula Needed
Is there a formula to create daily/weekly views to appear in the dashboard? I need assistance with the following: Daily views for the last week of File Status Weekly view for the last four weeks of File Status Daily view for the last week of View Files Weekly view for the last four weeks of View Files Individual yellow…
SUMIF failure
I'm trying to improve a labor intensive process (40+ spreadsheets that do not interact) to calculate a a weekly production metric by Examiner. Basic workflow is that Examiners enter time worked in various categories daily, then once a week production numbers are added and the metric will be calculated. I created the sheet…
COUNTIF formula to count how many projects the past 2 years? The date is listed as 02/03/19
and I would like to go back the past 2 years.
How do Match another cell
=MATCH([Purchase Order No.]@row, [Invoice Review Status]@row, "Approved")
If, And, Star Help
Hi SS Community! I wrote a formula that is not intending as I wanted it to. Looking for some help. Here is my formula: =IF(AND(ISBLANK([Entered in WD]@row), TODAY() > [Assigned To OSU]@row + 4), 1, 0 Here are my sheet columns: I want to STAR if a PEP was assigned to the OSU but not entered in WD after five days of it being…
Formula to collect information based on year and month
Hello! We have a sheet where we put down information from all the invoices we send. There are two collumns I want to collect data from. Date and "hours spent". I used: =SUMIF({Service - Fakturering Range 4}; MONTH(@cell) = 3; {Service - Fakturering Range 5}) to get out how many hours we´ve spend in Mars. The problem occurs…
Bug in the system? formula from system column (created date)
I have created a workflow automation in the following sheet that is based on the hour of when this is created - this is taken from Created date column (system column) Column is called “Hour of creation” The problem is, every time anyone makes any change in the sheet, the hour of creation gets changed. This happens for all…

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:…
Issues with IF formula
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…

Formulas and Functions

Discussion List

Help Article Resources