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.

Multiple Trigger Points Based on Date
Hi everyone, My organization has multiple directives across multiple departments. I would like to set up automatic notifications to people who are involved with a directive. I have set workflows based on the due date and it works. Some directives have different reporting frequencies (annually, monthly, quarterly, no…
Do an If statement only if a cell is not blank
Hi Community, I have a list of names and I'm trying to keep track of different Pension sources they may have and the amount of each pension. Being that everyone on my list has a different amount of pensions, the formula counts to see how many pension sources are filled in. If that count equals the count of "amounts" that…
vlookup with id and date range
Hello: I am super thrilled that I have mastered a formula that originated in Ecwid, used zapier to populate a smartsheets and then with a sumif in my smartsheets row I matched the participant id and date range to plug a payment in for a participant in our program. I want to pull the associated payment number/Ecwid Id into…
Nesting RIGHT and LEFT functions to parse characters from a string
Hello! I have a problem with parsing some characters from the URLs in one cell to another cell using the RIGHT and LEFT functions. I am not sure this is even the best way to do it, but it seems like I should be able to nest these in such a way that I get the result I need. Problem: I have one column that has URLs, and…
Multiple columns in a form
Hi all, I know this has been discussed in the past and I found the archived thread on this but I saw no actual resolution. My question - is there a way to have multiple columns in a row (in a form)? This would streamline the form greatly and it would ease up on the scrolling and discontent from the users' side. Best,
=[Date]@row + 7 is showing up as invalid column value
Hello Smartsheet Community! Can someone please help me with this formula? I'm trying to calculate 7 days after my Date column, however the most common way stated in previous discussions I'm getting an #invalid column value. Please help!
Getting "Field Sprint Name Not Set" when using Jira Connector to Jira Cloud
Hi, I am trying to pull all issues related to sprints in a Program Increment from Jira Cloud using the Jira Connector Workflow. It pulls some data, but fields like assignee, start and end date, and Sprint Name are blank. I get a message stating that the "Field Sprint Name Not Set" even though my JQL runs fine in Jira. I…
Cross Sheet Sumifs Formula
Is there a way to run a formula from a cross sheet, that would pull specific names that are in the same cell. To formulate a group that worked together total revenue by the accounts that have "closed won"? I have more than one account holder at times per account =SUMIFS({Sheet - Forecast Amount}, {MSS Sheet - MSS Account…
Counting and Averaging with Exclusions
Hello Smartsheet Community, My organization uses Smartsheet to track our recruiting efforts. Each of our divisions has its own sheet, and we have a metrics sheet to tie all of the divisional sheets together. I am having issues both at the divisional sheet-level and the metrics sheet-level. Problem 1) Sheet Summary…
What Formula to use for Sum of Hours within a Specific Date Range?
I want to sum up hours in my hours column to a specific cell, but I only want hours within a specific date range. What would be the best way to go about this?

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

Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags