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.

Dynamic Drop Down in Forms
Hi, I've tried googling and searching the forum but cannot find an answer for my use case. As part of a 2 stage project approval process I want to create a form that has a dropdown option to select project ID numbers from a list of projects that have passed the first stage. e.g. If I have 3 projects PROJ01, PROJ02, PROJ03…
Formula for Payment Terms "Net 10 EOM"
I'm trying to write a formula to calculate a payment due date using the payment terms "Net 10 EOM". Meaning if invoice is submitted by the end of the month, its due by the 10th of the following month.
Easy Way to Link Multiple Cells to Different Sheets?
I currently use a 'summary sheet' which is used to track different dates from different smartsheets. Basically, we have it written horizontally so each sheet/job has it's own row within this sheet and the columns are used to track different milestone dates from these different sheets. Typically, we just have to link cells…
SUMFIS btwn dates
I am scratching my head because this is a simple formula I have used in the past, but I cannot figure out why this is returning 0 when there are 2 values that should be summed in this period: =SUMIFS(Amount:Amount, Date:Date, <=DATE(2024, 6, 30), Date:Date, >DATE(2024, 3, 31))
Copy or Move rows to another sheet do not copy formulas
At the end of every sprint, I want to move data for this sprint to an archive sheet. When I move or copy rows to another sheet, the cell formulas are not getting copied. Only the values (without formulas and cross-sheet references) are getting copied. I tried the automation option and manual copy/move. But none of these…
How to Assign Contacts in Rotation?
Hi! I'm currently creating a ticketing system where different types of tickets will be assigned to different technicians. I have automations set up for most of the ticketing types, but two types (Radios and Support Request) need to be rotated between two technicians. How can I accomplish this?
Sending to contacts in a cell - How to limit who is contacted
I have an automated workflow that triggers an approval request once a form is submitted. The workflow is set up to alert contacts in a cell when the request is submitted. The contact list that would be alerted is the request approver. The approver is just one person from a list of approvers; I have another workflow set up…
Link from a cell-reference and make the answer a column formula
When we set up a sheet we did not add an 'industry' column. I can link to a metadata sheet to get that information and link it to a single cell on my sheet . . . however, I need to have that value appear on every line of a column (so that reports across with the info across industries can be sliced differently). I created…
Formula and Response Question
I need a formula based off of two columns. Date Created and the Date Reported. I am trying to determine if individuals are submitting documents within 24 hours. If they are in another column it should populate "Compliant". But it seems to be working for some but not others and the dates are sometimes the exact same date.…
Formula
Hi all, I am trying to combine the following two formulas, only one works at a time. =IF([Variance (Target End date)]@row = 0, "Green", IF([Variance (Target End date)]@row <= -4, "Red", IF(OR([Variance (Target End date)]@row = -1, [Variance (Target End date)]@row = -2, [Variance (Target End date)]@row = -3), "Yellow",…

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

Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…
Question about copying a sheet
I use Smartsheet to track my yearly activities. I have a sheet that is connected to this sheet for calculations that feeds into a dashboard. Hopefully that makes sense. My question is, I want to copy this entire thing and start new for 2025, however when I copy, the calculation sheet is still pulling from the 2024 sheet.…
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags