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.

Using References to pull info across sheets
I'm new to Smartsheet, so I expect this to be an easy question. I'm using References to pull info across sheets and I need a cell count from the Category Column with an input of "Category 1" only if the Status Column in that row has an input of "Not Started". Here's a copy of my unsuccessful attempt. =COUNTIFS({Project…
Formula Help Needed - Return "50" if date is within a range AND another field is not blank
Hello! I've been working on this formula for hours now and could use some help. I have a column called "Program Date" and a column called "TR". If Program Date is between 12/1/24 and 4/30/25 AND TR is not blank - then I need it to return the value "50" in my "Cost" column. This is where I am at so far: =IF(AND([Program…
Updating threat level based on percent complete
Hi, Could someone help guide me with what is wrong with my formula? What I am looking for the formula to output: If the Percent complete is less than 30% within 30 days of the Current milestone date, Threat level is a yellow symbol. If the Percent complete does not equal 30%, today is after Current milestone date, the…
Add a checkbox to an email for follow up
Is there a way to add a check a box in an email allowing the reader to advise they are ready to proceed to the next step. This will then trigger an alert on the smartsheet to the admin who will then follow up?
PMO- Automating the Intake Sheet
I recently started assisting with our team's SM and need direction in understanding setting up PMO. Presently, it's manual, but we need to create a better process, including an intake form to branch the projects out to their respective reports and tracking. The basis of our projects stem from an item report we receive…
Multi-select dropdown into multiple rows
I have multi-select dropdown column. (Data will be entered via form and there will some approval automation.) I have two questions. Is it possible to select individual items within the multi-select options. I was planning to use some kind of delimiter within the options and use index but wondering if there is a more…
Sheet Summary Formulas
Afternoon All! I'm trying to figure out how to organize a formula for my sheet summary page. I need it to collect data from a column and tell me how many different numbers there are. It is for purchase orders, there are many numbers that are the same for each PO, but I need to track how many unique PO numbers I have in…
Clocking In / Out
I am trying to create a formula where if a Green Circle symbol drop down is chosen, then it records the time from the Date Modified Column. I keep getting invalid data type. Can someone tell me where the error is in this formula? =IF([Clock In ]@row, "Yes", TIME(RIGHT([Date Modified]@row, 8)))
obtain score based on dropdown list values
Hello - I'd like to obtain a score based on weighted items from a dropdown list. For example, "Apple" = +1, "Orange" = -1, "Grape" = +1. So if I have Apple and orange I get 0, but apple and grape will produce 2. Can someone help me with a formula, please? thank you.
formula question
I have a formula that is working fine, but i want to squeeze in one more logic variable. I am looking at thousands of rows of data. I want the formula to count any row with column value of [stay level] of "medical" or "emergency medical", then for the five facilities listed i also want the formula to also bring in all rows…

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

Netdays calculation with optionnal date column
Hi i'm looking for a formula to calculate the netdays between 2 dates. but i have 3 dates in the equation. a date column (date 1) whit references from another sheet and a manual one (date 2) to overwrite the first one. the third date is the "today" date (date 3). so i'm looking for something like: netdays between date 1…
Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
Formula to count in progress child tasks using % complete
Hello, I am trying to obtain the count for in progress tasks using my % complete column and excluding parent rows. The criteria I want to use: Count if Children = 0 (no parent rows) If % complete <1 and >0 I have the formula working for one value: if % complete <1. But I'm stuck on trying to get the formula to work with…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags