Formulas and Functions

Archives for October 2022

Total Number of Times a Company Responds a Certain Way
I have two columns--"Company Name" and "Bid Decision." The "Bid Decision" column has the option to select "Bid" or "No-Bid." I want to create a formula that counts the number of time a specific company enters "Bid" and a formula that counts the number of times a company enters "No-Bid". See image below. Can anyone help?
Formulas for + Days Date with Multiple Conditions and Date Countdown
I need some help creating a couple of formulas for + Days Date based on a couple of conditions and Date Countdown as would be greatly appreciated: In the SLA Due Date column if the SMCC Action column (has 2 drop down selections of NIR & LI) is NIR to populate a date + 45 days and if LI is selected to populate a date + 7…
how do I return a blank cell if source is empty
I have the formula: =([projected cost]@row - [Fedex Charged]@row) / MAX([projected cost]@row:[Fedex Charged]@row) I can not wrap my head around having the formula return a blank answer and leaving the cell empty if one of the source cells are empty. Not quite understanding how to use either COUNTIF and/or the ISBLANK…
Looking for Formula where count of distinct PO #s in a given PO month
I'm looking for a formula, where need count of unique PO # falls in a month. In this formula, I used specefic PO # i.,e "123" but I need count of all PO # falls in a given month (See the screen shot attached) =COUNTIFS([PO Date]:[PO Date], IFERROR(MONTH(@cell), 0) = MONTH(Date12), [PO Date]:[PO Date], IFERROR(YEAR(@cell),…
IF [Task] less than 3 days than Conditional formatting
Hi everyone, I want to do a condition that uses conditional formatting If Task date is less than 3 days:
Trying to get this cross sheet formula to work, pro desk and 24/7 support haven't got back
Please Help! Sheet 1 (Equipment Inspection Sheet) Column 1 (Unit # multidropdown), Column 2 (Employee contact), Column 3 (Competency and Ticket check checkbox) Sheet 2 (Equipment Log) Column 1 (Unit # multidropdown), Column 2 (Req. Competency multidropdown) Sheet 3 (Competency Log) Column 1 (Employee contact), Column 2…
EDATE Substitute
Hi there , can anyone help me figure out a formula on this ? Need to add the "Contract term" in months, to the "Effective date", to get the "End date",
Assigning a count to each dropdown category
Hi, Recently with the help of this community and customer support, I have created this reference table of categories and sub-categories (see screenshot 1): However, I would like to also track the amount of times the sub-categories are entered. Say for example, A was found 5 times. In the dropdown menu from the solution,…
FTE Calculation - Partial Month
OK Smartsheet Formula Nerds... I know you're out there.... I am working on a staffing model. I need to calculate the number of FTEs per month based on FTE Start and Term dates. I have all of the FTEs listed in a team sheet that looks like this: Right now, I'm doing a COUNTIFS that is matching based on the Team Name (which…

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

% Expected formula
How is best get % expected formula? I'd like to show for example that by original plan we should have completed 30% but actually have only completed 10%. I have separate column for % completed (reality) and added manually the % expected. Any tips? Thanks
How do I run this report?
I have a sheet where there are several different "Assigned To" columns and then a "Project Status" column. I need to create an employee workload report. Each report should only show that employee's assigned to tasks that are in their current status. For example: Deron's report should show the row Project Name and Project…
Older than 3 years and Status set to Closed
I'm hoping I'm missing something obvious but, I haven't had luck doing this on my own so far and I'm hoping someone can help. I have a sheet I'd like to create a workflow on that when a status changes to 9 - Close Job as Complete and any of 3 date columns is older than 3 years to move the row to an archive sheet I set up.…

Formulas and Functions

Discussion List

Help Article Resources