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.
Discussion List
IF formula to outline Status in RED when 2 dates collide from the same variant/task
For example I need RED Status when HBM collides with another HBM from a different task and start at the same date. Basically need to avoid date clashed from the same task HBM with HBM, Excavating with Excavating clashes to be advised in RED of the clashes , however without automatically changing the dates. Picture for…
Formula Help
Hello Just wondering if someone could help me update this column formula. I need it to exclude the N/A status. It is currently a column formula column that flags any items that are past due from the End Date column. =IF(AND([End Date]@row < TODAY(), NOT(ISBLANK([Program Status Type]@row)), NOT(Status@row = "Complete")), 1,…
IF, AND, OR Function
Hello.... I trying to figure out how to write a IF statement that would allow me to match the value in one cell to a value in another cell on a reference sheet. If that value is true it needs to check that the date issued column on that row and make sure it is 1 year within today's date. If all that matches i need the cell…
Trying to copy a multi select cell data into another cell once criteria is met
If X is true, copy cells in Y What formula should I use for this? Keep in mind, cell Y is a multi select cell.
Ignore duplicate child rows and show data of only the latest date effective and lowest price
Hi guys, I'm pulling my hair out trying to solve this one. I have created a price file of items in smartsheet. Each Item can be purchased from multiple service providers and I am keeping a history of what the item cost per service provider at different times. I would like to be able to summarise each item at the parent…
Calculating Networkdays within certain criteria
Okay, Smartsheet Community! I need you! I have been tasked to create a process where we track content creators drafts and the number of days between. Below is a screenshot of part of my set up. I need to know the number of networkdays between PCD Draft 1 Start Date and SME Draft 1 Review Start Date when PCD Status Draft 1…
Notification Workflow
I have a workflow that is to send a notification to three sets of contacts when a new project request is entered from a form. The contacts are loaded into the sheet by formula depending on what department is submitting the request. The workflow triggers when rows are added and any field changes and has a condition that…
Calculate Aging "in buckets" for Open Records (on a Metrics Sheet)
I am doing aging, but my numbers are off by one. I have exported the file, but I cannot find where the issue is. But that is when I noticed that my formulas were NOT correct (How I wanted them). The formulas are all based on a Status = Open. I realized for my middle formulas, I should have used AND and included the max…
I have a formula that does not work now because of the new year.
This formula has been working just fine until the month of December and now returns #invalid Data Type" I assume it is because it is looking for dates within this calendar year and not next calendar year? Does anyone have any suggestions on how I can fix this problem? The formula looks at the Determination Date and then…
using OR and multiple expressions
I created this statement using OR and CONTAINS to select a value between 2 expressions - Stage 1 or Stage 2: =IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row)), IF([Example Result]@row >= -30, 1)) This works fine for recognizing and providing results for Stage 1 & 2 logical expressions. I want to…
Help Article Resources
Trending in Formulas and Functions