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.

Smartsheet Metric Sheets Historical Reporting Help!
Hello! I have a use case I need some help with. I have a user who needs to create some reporting which basically takes a 'snapshot' of data at a given time, and then uses that for historical reporting in the future (e.g. total number of employees for a given week, then tracking that over time) See Screenshot for example…
Date Sequencing
Hello. Can someone please help? I'm trying to auto insert/sequence a series of dates between two different dates in two different cells. If Date1 is 1/15/24 and Date2 is 2/8/24 Id like a third cell list the two dates and all dates in between on individual consecutive rows.
Organize =Join(Collect formula Output
I have successfully pulled all of the Task IDs into one cell, but the information is not pleasing to look at. Is it possible to organize the output into separate cells?
Formula to Automatically Update Red, Yellow or Green Symbols
I am having a difficult time getting the right formula for this. I would like to make it so if any of the dropdown options are selected that contain the word "Dead" then a red symbol auto populates in the column to the right. Any help would be greatly appreciated!
Help setting up a daily tracker
Hello! My team is attempting to create a sheet and form that counts the amount of inventory of a product we are overselling per day. We essentially would have the inventory start with 15 units per day, we are going to request the number they sold for each entry. The goal is to have the number they enter in the form will be…
Error after clicking ¨Convert to Column Formula¨
This discussion was created from comments split from: Applying a formula for the whole column.
Continue to get an #Incorrect Argument Set for a column formula but intermittent
I have a formula shown below that checks a product ID from that row against another sheet first to see if it was terminated and return the date listed. If that is good then it checks to see if on that second sheet a final process is recorded with operator information and returns the date: =IFERROR(IF(COUNT(COLLECT({Product…
Tying a COUNTIFS formula on two sheets
Let me start by saying this is a bit complicated, and formulas are not my strength. With that, here we go, I built a template for tracking warranty tickets which consists of several sheets, reports, and dashboards. I'm trying to write a formula to calculate certain action dates (see table below) This formula for the…
Daily Task Recurrence
Many of the articles I have seen are showing the idea of new tasks showing up every time a person resolves them. In my example below, I am more looking to block a person's time "permanently" for 2 hours on every Monday and every Wednesday. DBA1 has server maintenance tasks every Monday and Wednesday, therefore they are…
Why Won't This AI-Generated Formula Work?
I used the AI formula generator tool to create a formula to count the cells in a referenced column in another sheet if the due date is in the next 5 days. This is what was created, but I keep getting the #INCORRECT ARGUMENT SET message. I can't seem to figure out what needs to be adjusted. Anyone have any ideas?…

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

Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags