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.

Notifications
Hi Brain Trust I have an automation that when the status is changed to onboarding a notification is sent to xx@xx.com.au. HOWEVER - when several rows are updated in quick succession and then saved, the notification sends out a combined notification instead of individual notifications We tried changing to update the status,…
(AED) currency is not listed in the currencies
Dear Community, Can we have (AED) United Arab Emirates as one of the currencies to be used in Smartsheet? I would like to use it in my budget sheets Thank you Sara Hamam
Index Match with multiple Parent/Child rows in a sheet.
Hello all, I'm looking for some advice on a tiered IF statement using index/match and CHILDREN formulas. My case: I receive numerical data from another metric sheet that copies it snapshots into this archive once a month. There may be times where we need to edit the historical data. To ensure the % columns are updated I…
Join(collect()) - the collect column has multiple values.
I want to filter what is collected (in the collect range, each cell may have multiple years : e.g. 2020,2021,2022,2023,2024). 2 criteria are separate columns. Criteria range 1 vs criteria 1 (wood species), criteria range 2 vs criteria 2 (specified in product). Both criteria 1 and criteria 2 match, so I get all the years…
Is there a formula I can use for flagging outstanding equipment?
Hi everyone, I've bulit a sheet for tracking equipment shipments for my company. This is a centralized grid that shows when equipment was sent to an end user, and when that equipment was received back from the user. I have a drop-down select column in which we can select the asset ID. I've also got a checkbox column to…
If formula for checkboxes
Hi, I am having trouble with the correct formula sequence for check boxes to stay checked through out the workflow process? I want the check boxes to stay check as it moves along its stages. current formula I am using is: 100% Rec'd column =IF([Workflow Status - BitRip]@row = "Received", 1) Shop Installed column…
How to delete/move a row from the final sheet and not mess up the formulas.
This discussion was created from comments split from: Copy one column to new sheet as rows are added.
How can I quickly create multiple checkbox columns?
I have imported an Excel file with 147 columns that will be a checklist for various systems with various points. I need each of these columns to be a checkbox column. Is there any way to make each column a checkbox column quickly, rather than updating each column one-by-one?
COLLECT function to reference another sheet
Hello, this formula works great within the same sheet: ="January" + " " + JOIN(DISTINCT(COLLECT(Helper5:Helper35, Helper5:Helper35, <>"")), ",") and produces this output: I need to make it work in another sheet referencing the original one to produce exactly the same output in the new sheet (I just need to separate it for…
Countifs with two conditions
I was having a hard time with this formula - Not sure why I am getting it wrong. What I am trying to do is - If Column A is Student and if Column C has Enrolled or Enrolled - Incompleted, Count. The formula I have is follows: =COUNTIFS({Courses Projects}, "Student", {Courses Status},OR(@cell =…

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

Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
How to Automatically Checkmark a Column for entries that are created within a time-based timeframe
I'm trying to write a formula that will automatically place a checkmark in a checkbox column titled "Today Entry" whenever entries meet the "Created" column criteria of being submitted after 1100 AM the day prior and 0800 AM today on a rolling basis: I've been trying to use the below column, but honestly I have no idea. I…
Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags