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.

Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

SUMIFS with ISBLANK, something is wrong
=SUMIFS(Amount:Amount, Unit:Unit, "Facilities Devel & Mgmt", ISBLANK(COVIDSpendingCategory:COVIDSpendingCategory), "Cell isn't blank"])
Copy Columns - Automated Workflow
Is it possible to create automation that copies select columns to another sheet when a new row is added to the parent sheet? I know I can make this happen with cell linking but I would prefer a more streamlined method similar to copying a row.
Formula inquiry: Tally the count of empty cells in a column
Is there a formula that simply tallies the count of empty cells in a column? I use the COUNTIF all the time to tally the count of cells with certain information and that's easy, however the same function doesn't seem to work in capturing the count of empty cells. I have scoured Google and Smartsheet the last few days and…
Creating a Master Project List and Dashboard
Hello, I would like some help in designing a Master Project List, and a Master Project Executive Summary Dashboard. We have a Roadmap that contains each functional area's main projects/initiatives. Is there a way I can build a formula to have all the information from each road map combined into one Master Roadmap... Which…
Reference Number of Contacts In Cell
Greetings Is there a way to reference the number of contacts in a given cell within a formula? For instance, I have a column titled "hours per person", and a column which is a contact list where I enter contacts. I would like to construct a formula for the "total hours worked" which would be the hours per person multiplied…
Automations to include today and in past do not work. Am I doing something wrong?
I am wanting to have a reminder email sent each morning to include today's tasks and ones in the past. I have my workflow set up to be today or in the past but it only sends me the rows for today. Am I able to have both sent to me or is it only one or the other? I have tried this on all tasks lists and have the same issue.
Parent Children IF CONTAINS query
Hello! I've tried multiple versions of formulas that work for this at the parent level only, but I'm looking for a column formula that will not change the value of the children. I have a timesheet that has the period end date as the parent and the days within that period as the children. The last child includes a timecard…
IF and Statement for Color Statuses.
I'm trying to format rows to a yellow color when ‘Date Sent for Review’ and ‘Sent’ status are greater than 10 business days. How do I do this??
Math formulas across multiple cells
Hello all, Any help on the following issue would be very much appreciated. I have a scoring matrix built in to Smartsheet (See below). I would like to multiply the score of each cell for each criteria (Strategic Init Impact Score, Business Impact, etc.) by the corresponding weight (and divide each by 100) and then add…
Formula need to separate mixed text from a single column into separate columns
Using the LEFT or RIGHT formula currently as a means to separate the [Sales Rep Info] column. Problem is I can only figure out how to do it by number of characters. I need the formula to separate first and last name into a new column and a second formula to capture the information in the parenthesis. Same for the [Customer…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

COUNTIF with AND
I've written the statement but am getting a #INCORRECT ARGUMENT SET error. I'm new to SS, any help is appreciated. =COUNTIF(AND([Opportunity Risk Path]:[Opportunity Risk Path], [Module Approval Status]:[Module Approval Status], ="Conventional", "Not Started"))
IF CONTAINS Formula to return different text values in second column
Hi! I am looking for some help in creating a formula where if a certain word is found in one column, another word is returned in a second column. For example if "Head", "Nasal", or "Spine" is contained in the Procedure column, "Neuro" is returned in the Clinical Specialty column. I've tried different variations of this and…
I need to result the column's name when using a JOIN(COLLECT) or INDEX(MATCH) formula
Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that row. That worked until we applied column formulas to some of the rows. Now Row 1 can't be the column's name because of the…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags