Formulas and Functions

Archives for October 2022

Could anyone help with solve this issue
I have 12 questions in a call audit smartsheet so the formula is as follows =((COUNTIF([Question1]@row:[Question12]@row, "poor") * 0.25) + (COUNTIF([Question1]@row:[Question12]@row, "fair") * 0.5) + (COUNTIF([Question1]@row:[Question12]@row, "good") * 0.75) + COUNTIF([Question1]@row:[Question12]@row, "Excellent")) / 12…
IF(AND Formula + substraction
Hello! I have the % Burn Rate of my project and the % Complete, I want to subtract and according to the difference in them I want Harvey Balls to display different colors. If the difference between the % Burn Rate and the % Complete is => 6% I want it to be "Red" If the difference is From 1% to 5% I want to be "Yellow" And…
I need a check box in a parent row to populate the same value in the same column in the child row
Counting # of Overdue
Hi, I am trying to count the number of Overdue rows using two deadline columns (Due Date 1, Due Date 2) and a Status column, so using both of these criteria: Determine if the deadline has passed from the earlier of the two deadlines Eliminate from the count any past due rows also marked as Completed in the Status column…
I have a parent row that needs to populate with appropriate 'Status' based on it's children
I have many parent rows with many children, in some cased grandchildren. Each child (or grandchild) has a status. Status choices are; Not Applicable Not Started In Progress Complete I have to account for the following possibilities; I have been able to write a formula for the first 4; I am having great difficulty writing…
If blank then...
=IF([Customer (Project Master Log)]@row, "", [Customer (Service Ticket Log)]@row, [Customer (Project Master Log)]@row) The cell should equal project master unless its blnk then it should equal service ticket. Need help with the formula
Formula for CountIf One column has a value and another column is not blank
Hello, I'm reaching out to the community for help with creating two separate sheet summary formulas (see example in image below), to: Count the "red" values in the "ryg" column ONLY IF the "New Target Finish" column value is NOT blank Count the number of blank cells in the "New Target Finish" column Thank you, in advance,…
Why does the column 'Most Recent Date' returns blank when I use the formula Max?
I am trying to get the most recent update date using Max but it shows blank (no value) upon entering.
COUNTIFS COUNTM to count the number of instances in multi-select columns, based on several criteria?
Hello, I have been trying to create a formula that would count the total number of instances in multi-select columns, based on criteria in cross-referenced sheets, but sadly with no success. To illustrate what I'm trying to do please see the example below: From my reference data in Sheet1 - I would like to receive a sum of…
Sum of Parent row
Hello, I am trying to sum the totals of my parent rows and not include my children rows. Any help is appreciated.

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

JOIN + ACCOUNTING
Hello, SmartFam! I'm trying to join text with accounting numbers. but the join will not keep the financial formatting (removing the $ and correct , placements) Can you please help me get this right? VENDOR AMOUNT JOIN RESULT DESIRED RESULT AMAZON $435,678.90 AMAZON - 435678.90 AMAZON - $435,678.90
Unable to Count Blank/Empty Cells in a Column
I'm trying to count open/active events that have not been Resolved. Each event is on a separate row with a column called Resolved. Resolved Cells will either be empty/blank or contain a date & time as alphanumeric free text. Example below shows date on top of time in cell (I forced with ALT Enter after date) 3DEC 0859 ET…
CountIFS
I am having a problem with a formula. Does the COUNTIFS have a limit on the number of "logical expressions" used in a formula? My formula below: =COUNTIFS({Opportunity and task orders}, <>"", {2025 Opportunity Status}, OR(@cell = "8.0 - Lost", @cell = "9.0 - Client Not Selected", @cell = "5.0 Awarded Contract Vehicle",…

Formulas and Functions

Discussion List

Help Article Resources