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

Need help with Index formula across sheets
I have a Master sheet that I would like to source information to subsheets for Project columns, of which then the % complete and date complete on each subsheet gets Indexed back to the Master sheet. However, I am needing to add 2 lines on the Master sheet to populate on all of the subsheets, but when I assign them unique…
Adding cells with IFERROR blanks
I'm having an issue with this sheet: Smartsheet - Quote The COST / PC column is where the issue is happening. On line 4, I'm testing out using a different material that doesn't conform exactly to the sheet's setup but I'm trying to build in functionality to make it possible. When the columns being added by COST / PC are…
Formula check: select drop down option based on other columns
Hi everyone, I'm looking to use a formula that will select one of my drop-down statuses (Rejected) IF the Avg Score is below 50% OR one of the other columns has the selection of "Red Flag (quality/ethical/concern: cursing, condescension, etc)." Otherwise, I want the field to populate the other status (Acceptable). I'm…

Formulas and Functions

Discussion List

Help Article Resources