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?
Sign in and 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.

How to count number of rows where a date in a column is equal to a specific date?
Hi all, I am trying to create a time series line chart to show the progress of issues put in a specific status every day. On our Issue log, we have date column which captures the date on which an issue was set to either Rejected, Closed or Acceptable Difference. Created a supporting sheet to map the data for the chart…
Countifs With Multiple Criteria
I am trying to count the totals if a certain criterias are met. Per example below I am trying to count if client is A and B where "Initiative" is NOT "N/A" and Progress for both "Waiting for Pricing". I tried the formula below and not correct syntax and logic. Any help would be much appreciated. =IF(COUNTIFS({Client}, ="A,…
How do I add days to an existing date?
I have read through this community about the same question, however, the solutions haven't seemed to work for me. I'm working on a Debt Snowball sheet to calculate and estimate when my bills will be paid off. I can use EITHER the Months or Days column from the DATE column. For example - need the formula to add 8 months (or…
COUNTIF with multi select dropdown
I'm having trouble with the multi select dropdown option. I have a sheet with the data/responses. I'm creating another reference sheet trying to count the responses. So example, here's my test data. There are multiple options for fruit. In a difference sheet, I'm trying to count the total responses. So Grapes should be…
Assistance with COUNTIFS and dates
Hi, I am trying to count the status of a tasks that have range of Start Dates for that week and keep receiving "Unparse" error message.
Searching from one sheet's range & search/match to another sheet's range for a unique identifier?
Hello, Is it possible to search from a range in one sheet and search/match it in a different range/another sheet? This has plagued me all day and therefore I can no longer remain clear headed about what the best course of action should be. I have two trackers in completely different departments; QC and PROD. I want to…
Formula Help
I am using an index & match formula to cross reference another sheet for data plugins. My problem is some of the data that I need is coming back as a #NO MATCH which is understandable because some of the information is not available. There are other sheets that do have the same criteria available that I can match too but…
Formula Question - If not blank, return cell value
Would like to concatenate several cells and have that formula: =[Product Codes]@row + "-" + [Unique ID]@row + "-" + [Deliverable Code]@row Would like to add a cell only if the cell has content along with a dash preceding. Keeps coming back as unparseable. What am I doing wrong?? =[Product Codes]@row + "-" + [Unique ID]@row…
Pre Fill a form with a formula?
Hi I have a a sheet with contract numbers, the vendor, contract dates etc. What I want to do is have a form where there is a contract number field and once it is populated with a number the other fields would pre fill. So the person puts in the contract number then , Vendor, Contract amount , dates and type fill in, is…
I need help with a formula or direction if a formula isn't the best way to go
In my sheet I have 4 different dates , requested, procurement, legal and council, and I want the status to change when each date is filled. So if status has a date I want the one quarter symbol, procurement the half symbol, legal 3/4 symbol and council full. can someone help?

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Tour Tracking Formula Issue
Hello, I am currently using a formula to track how many tours each tour guide has led. I have their names on a sheet next to each tour they have been assigned to. I am using =COUNTIF({Tour Database Range 1}, "Name") and inserting each person's name into the "name" portion of the function to get the count. I noticed that…
Unparseable error sumifs with cross sheet reference
Hi team, I cannot get rid of the unparseable error for the following formula. I think the issue is the =[Month]@row and =[Country]@row. I have tried also without the brackets []. =SUMIFS({EMEA KPI Issues No of EE},{EMEA KPI Issues Category},"vendor missed data",{EMEA KPI Issues Country}, =[Country]@row,{EMEA KPI Issues…
Extract 10-digit string based on consistent lead-in digits
I have a number I'm trying to extract from a column and I can't figure out how. The number is *always* 10 digits, *always* starts with 50000, and can appear *anywhere* in the cell in Column A (start, middle or end). Column A has a mock-up of the type of data I'm working with. The Result column shows what I want to achieve:…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags