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.

need help with a check box formula
This discussion was created from comments split from: Formula for a checkbox.
How to copy automatically copy a row to the top of a sheet?
Hi, I just created a sheet that has an automated workflow that copies a row when a box is checked. The problem is that my destination sheet is otherwise populated by a form that adds news rows at the top. When my automation copies a row it goes to the bottom- any way to change this?
Dynamic Sheet reference based on a cell value
Hi, I am new to Smartsheet and I have three sheets, Sheet 1 - Contains employee regular hours pay rate Sheet 2 - Contains employee overtime hours pay rate Sheet 3 - Calculates the overall pay of a employee per month including regular and overtime hours. I need help with a formula in Sheet 3, where the "Pay" column should…
Counting number of events (lines) within a time range
Hi, I looked at the past discussion but didn't find the answer. My sheet has a row for each events happening with the precise dates (ex: 8-Aug-2024). I would like to count any event that happened within a time frame (march 1rst to march 31rst of the next year). I tried various formulas but no luck at all…
Correct formula to return symbol from another sheet based on 2 criteria
Hi, I am trying to capture a monthly snapshot of project health. I created an automation to copy rows to a "Helper Sheet" 1x per month and record the snapshot date. I even translated the snapshot date to a numbered month to try to make the formula easier (no luck). I created "Monthly Snapshot" sheet where I am trying to…
Countifs forumla
Hi, I am looking at doing a countifs forumla across 7 different sheets. =countifs({spreadsheet 1}, "Green",{spreadsheet 2}, "Green",{spreadsheet 3}, "Green",{spreadsheet 4}, "Green",{spreadsheet 5}, "Green",{spreadsheet 6}, "Green",{spreadsheet 7}, "Green",) Is this the correct formula? As it is not picking up the right…
Counting Text Color
Hello, I am working on creating metrics in our Smartsheet milestones. Currently, if a milestone was completed on-time, the date completed is turned green. If the milestone was not completed on-time, the date completed is turned red. What I would like to do is create a formula for metrics that reads the text color for how…
Unique ID # generator
Hey there, I am fairly new to Smartsheet, sorry if this is answered elsewhere but I haven't found an answer that works for me. Unfortunately I do not have a good formula to share. I have a Smartsheet set up with different columns such as multiple company names and application Id #. Basically I want to combine them and…
Formula
Hi I am changing the formula below but it doesnt work as expected. Can someone show me the correct way. Thanks From: =IF(OR([Item Status]@row = "(LTB)", [Item Status]@row = "(BB)"), "esh@gmail.com", IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([MSI / EMS Site]@row, {Site1}, 0)), ""))) To:…
Nested Index Match Formula
What's wrong with my formula? It's showing #unparseable

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

NEED TO ADD DAYS TO THIS FORMULA IF ANOTHER CELL HAS SPECIFIC ITEMS OF A DROP DOWN.
I have this formula that works for this cell when information is missing from reference cell A. However now we want to be able to add additional days if reference cell B has specific items checked in a dropdown. I just can't seem to get it to work. Any suggestions. =IF(ISBLANK([ ENGINEER (tentative start date)]@row), "",…
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…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags