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.

Computed/Automatic Population of Date?
Hi Everyone! Is there any way to get a date automatically in a cell when a certain cell in a column changes? Not using the System-Generated property because I do not want the date to change when ANY column changes only one. Thank you :) -Jenna
Formula for dividing 2 columns then multiply by 12
I am trying to get the average for a specific category (Column 1), by dividing YTD Terms (Column 2) by YTD Headcount (Column 3) then multiply by 12 for my Column 1? Here is the formula I am trying and I get Unparseable. =COUNTIFS({Turnover ratio by Dept July 2020_YTD Term}, /{Turnover ratio by Dept July 2020_Average…
COUNTIF Only if System Generated Date Column is Current Year
I am trying to create a formula in a Sheet Summary field that displays the total number of rows I have in the sheet that were created in the CURRENT YEAR. I have a system-generated date column - the column is titled "Created". The only criteria is that the Created column has a date and that the date is in the current year.…
More options for RAG Status
Hi, We have a requirement for additional Status options than Red, Amber, Green - I also need Blue to mark complete and Grey for not applicable. Currently, I have to choose either Blue or Grey - just wondered if this came up as a requirement for anyone else and what did you do? I still want to see the circles - so, adding…
Duration to a specific task from project start / counting the number of project days
Hello, I'm wondering if there is a function in Smartsheet by which I can create a column that displays the total number of project days from the beginning of the project ("Project Day 1") up to the beginning of each task. For example, the first task would start on "project day 1," the last task of the project would start…
What is the formula to find a criterio (Yes or Not) in a report on specific date wit rule (Today)?
I used the formula =COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 2", {LAYOUT CHECK FOR DAL Range 6}, "Sí") to found discrepancy for all days but I want to lear how to find in a specific day "Today ever" Please help me.
SUMIFS - Multiple Columns & Status Selections
I need to sum the rows in "Loan Amounts" column when it meets the following criteria: Division = HB and Status = In Process, or On Hold, or Approved. I can get he formula to work when only having one status such as "In Process", but when I try to add the other 2 options I get an error. Can someone help me with this?
How to use Countif when the cell is hyperlink to a url
I need to do a count of cell value which is a hyperlink to a url (the cell display a number that refers to the url) e.g. 285555 which links to (http://blahblahbla.com/285555). How do I use COUNTIF for this type of data in the cell? Thanks, Aye
Color Coding Formula
Hey all, Need some help with putting together a formula that will display color coding in a symbol column based on conditions being met in two other columns. Under status there are the following options - Completed, In Progress, Not Started, On Hold. I'm trying to get the color coding to function as follows - If Completed…
Countifs and Contains (Name & Date)
Hello All! A bit of a tricky one here - I am trying to COUNT the amount of times a person has an item for each month. The problem is when I use CONTAINS and select the month it shows anywhere that number shows. For example, I am trying to find each time a person has something with a date of anytime in August (8).. when I…

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