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 to show Latest Date @row
Hi, I have a column that has a list of customers and date column next to that, each client is there a few times because they have a few dates, Any formula to only see the latest dates, so I can delete the others? Thank you!
Sum range in another sheet if todays month = 7
Im trying to figure out a formula that would sum a range of cells in another sheet if todays month is 7 or July and am beating my head against the wall as this seems to me it should be easy. Thank you in advance for any help.
What is the best formula to generate expiration 14 days prior
I am trying to figure out a formula that can generate the Renew Date 14 days prior to the "expiration" date. I was along the path of something like this below, but it is not working. =DATE[Stop Date]@row - 14 I also would like to know how to add a conditional format that it would trigger the expiring date box to turn red.
Contact Column VLOOKUP Not Generating Contact
Hello Smartsheet community, I am having a small struggle with a contact column in one of my sheets. I have a formula: =IFERROR(IF(FDO@row < TODAY(), VLOOKUP([Store Number]@row, {Setup and IT Completed Range 1}, 14, false), VLOOKUP(Location@row, {Setup and IT Dates Range 1}, 13, false)), "") The column it is referencing for…
COUNTIF calculation when a condition is met
=COUNTIFS((Status@row,"DocuSign Approved"[Actual Completion]@row-[Target Completion]@row}) This is throwing an error. How do I calculate the Net work days between Actual Completion Date column and Target Completion Date column for only when the Status of the case is DocuSign Approved Please help
COUNTIF HELP.
Hello all. My question is in regards to a column of drop downs of yes or no. Currently I am able to do for no perfectly. But for “yes” they only success i have had so far is if one dropdown is yes, then the cell i need turns green. (Separate cell turns green or red) My end goal is to have a dropdown list that doesnt turn…
Returning a "blank cell" if fields are not populated
I have the formula below. What can I add to the formula to return a "blank cell" if either of these date fields are not populated? =NETDAYS([Issue Analysis - Start Date]@row, [Cherwell Ticket - Submitted Date]@row)
formula question
can i use countif to count rows that are colored?
How do I sum deliminated values?
How to Return Values from another sheet in deliminated format?
Hi Smartsheet community, I want to be able to return values in Sheet 2 in deliminated format. I have attached the diagram for reference. Please suggest the appropriate function or way to get the output? Thanks, Binika

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

Help with Countifs & Contains formula
I am trying to create a formula to count the number of orders that are on hold. However, we have several hold types, so I just need to count any order that says 'hold' in the field. Here is my current formula. Can you help me figure out why it is not working? =COUNTIFS({Copy of Copy of LATAM Backlog Range 2}, "40 DEALER…
Percent Complete Based on Checkboxes
I know this should be so simple and I have tried looking at the Help and Community channel but still getting hung up. All I want to do is based my % Complete on 4 checkboxes, if the checkbox is checked. Note, that I have columns hidden between these checkboxes. I've tried: =COUNTIF(([IDR 2 Completed]3, 1) + COUNTIF([G2…
Index/Match in different scenarios on same sheet
So far I've been successfully working with index/match to pull certain names (PM/Supervisor, Additional CC) when a certain requester is used on a sheet. Now I have a requester that is assigned to two (2) different clients, but the PM/Supervisor and Additional CC are different people per client. How can I incorporate that…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags