Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.

Product questions?
Ask it here! The community's got your back.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Formula Help
Hello- I am trying to subtract the most recent # of vaccines on hand from the sum of the total vaccines delivered- any suggestions? Tried this but it did not work: =(SUM([If you got a shipment, how many doses were in it?]2:[If you got a shipment, how many doses were in it?]61)) - (INDEX([# of vaccine doses on hand today…
Help counting duplicaes in a column but not blanks
Hello, I want to count duplicates in a column but not count blanks. Any assistance appreciated. Az This formula works but it counts the blank cells =COUNTIF([Name (Last, First)]:[Name (Last, First)], [Name (Last, First)]@row) This formula results in all '1's but doesn't count blanks. =IF(COUNTIFS([Name (Last, First)]:[Name…
Formula to show text next to sum amount
Good day, Our Currency ( BHD for Bahrain Kingdom ) is not one of listed currencies and I wish to show it to amount numbers , how to have Currency BHD seen next tp total sum in below formula ? =SUM([Service Charge]4:[Service Charge]13) Also , is there a way or formula to show text ( BHD ) or any other text next to number…
Help! Not sure what formula to use???
I have one column labeled, "Earn "C" or Better?" which is a checkbox column. If the student earns a C or better, our financial aid department awards them the money in the column labeled, "How much is the student receiving?" I need to summarize my sheet to show the total amount of dollars dispersed to students receiving a C…
Workflow - Copy Rows
Hi all, I'm creating a workflow that copies rows to a different sheet, however anytime the row is updated at the source, it creates a new row in the other sheet it's copying to instead of updating it. Is there a way to fix this?
Formula for Project Health
Hi All, I'm a newer user and trying to create a few formulas to support the Health of Projects Due. First, I'd like to use simple logic to provide row health. If Status: Not Started AND is greater than 14 days out from Due Date = Gray On Track to Deliver AND is 2 days out from Due Date - Green Delayed OR 2 days out from…
Support for Formula if ISBLANK
Hi All, I am stuck and need some help. I am unable to figure out how to return a blank if the Due Date is blank or the Status is COmplete. Can anyone help me adjust the formula I am using? =IF(Status@row = "Complete", "", IF([Due Date]@row < TODAY() + 7, "Due in Next Week", IF([Due Date]@row < TODAY() + 15, "Due in Next 15…
IF/AND, OR
Hi All, Smartsheet newbie here 👋 trying to figure out what seems to be a basic formula with no luck... I would like my "At Risk" column flag to get checked if the "Due" column date is past today OR if the "At Risk" dropdown is selected on the "Status" column. Here's my started formula that doesn't include the OR:…
Column references keep changing
For some reason my {Range} reference keep changing after I set my formula. Formula: =SUMIFS({Civic 2021 Range 6}, {Civic 2021 Range 4}, " RFP Submitted", {Civic 2021 Range 3}, MONTH(@cell) = 1) I select the column below, test the formula everything fine, then I go it messes up another formula, so I go fix the other range…
Can you display a full sheet on a dashboard without having to duplicate the sheet in a report?
I have creating a dashboard with metrics. I also want to include the full sheet at the bottom. Can you do this without having to create a report that also includes everything on your sheet?

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
Netdays calculation with optionnal date column
Hi i'm looking for a formula to calculate the netdays between 2 dates. but i have 3 dates in the equation. a date column (date 1) whit references from another sheet and a manual one (date 2) to overwrite the first one. the third date is the "today" date (date 3). so i'm looking for something like: netdays between date 1…
Formula to count in progress child tasks using % complete
Hello, I am trying to obtain the count for in progress tasks using my % complete column and excluding parent rows. The criteria I want to use: Count if Children = 0 (no parent rows) If % complete <1 and >0 I have the formula working for one value: if % complete <1. But I'm stuck on trying to get the formula to work with…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags