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 determine duration based on a certain status
Fairly new the smartsheet, so bear with me. I spend a lot of time in these forums learning, but have not quite been able to figure this one out. We have an intake sheet for project requests. We are tracking the date the request comes in and the date that we Close out a request, so Open and Closed statuses. However, there…
Using a Form and having it auto child to an existing Parent
Hi there, We use a form to input training files. For example Bob C- Analogs passed - Date If Bob C already exists due to previous training, if there a way to have Smartsheet automatically child the next Bob to the existing Bob C after it is entered? Additionally will Smartsheet also recognize that if Jake S had 2 entries…
confusing formula results.
I'm working in a smartsheet that combines data from other smartsheets using vlookup formulae. I've written a column formula to add the values in two of these vlookup columns and in some of the cells I get the expected result, and in some I get a #NO MATCH error. I can't figure out what is wrong here. I've reviewed the data…
COUNTIFS when Referencing another Sheet
I am making a dashboard and have created a Calculation Sheet that will link to the Dashboard. All of my calculations reference other sheets. Most of the formulas have been simple thus far. All I have been doing is counting when a certain symbol shows up in a column using COUNTIF. For a specific sheet, I have multiple…
How to use Countifs and AND and Ors
I am trying to make a chart that will count how many projects an employee is on given a certain criteria. Based off of my master project list sheet, I want to know how many projects my team members have each quarter (active and upcoming) I would like it to say count if employee name is employee@row AND Project Status is…
Index Match for Multiple Options
I want to set a formula that will index match the value(s) of a cell with a reference list of group name and associated contact information. Is this even possible? I have Sheet 1: list where each row has an entry that states in one cell, multiple group names I have Sheet 2: list of contacts by group name I want to have…
Limit Dropdown Options Based on Cell
If there is a quality answer to this someone can point me to, feel free to link it. I've searched but find none other than that this has been requested for some time. Here is the setup: I have a dropdown with "Stage"; It has the following Values and is limited to one of these values. I have another Column for "Status";…
EOMONTH similar
I am trying to automate the Month/Year field to add one from the pervious cell. Excel formula: =EOMONTH(E13,1) Is there any work around in smartsheet?
Updating Date column with Date Column in another sheet with a condition
I have two sheets with a lot of columns. Both sheets contain a Docket No. and a Hearing Date Column. I am trying to have the Sheet 2 look at the Docket No. in Sheet 1 and if the Docket No. is the same to update the Hearing Date Column in Sheet 2 with what is entered in Sheet 1 and always stay updating should there be a…
Moving children rows under a different parent row
Is there a way to set up a formula that will move project status "completed" from under one parent row to another parent row named "Completed project" once the project status has been selected as completed?

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

Is there a way to stop automations when the person being notified is the person that trig
Is there a way to stop automations when the person being notified is the person that triggered said automation?
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,…
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