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.

Can you bulk link columns?
I know you can bulk link multiple rows by selecting them all during the linking process. Does this not work the same way with columns? Thank you, Cam
% Complete Auto-fill / Default value 0%
Hello community :) Is it not possible for % Complete to default/autofill to 0% when inserting a new row? When I insert a new row (between 2 other rows) and enter text in the Primary Column, everything from the previous row gets auto-filled on the newly inserted row as expected (ex: At Risk flag, Project, other columns…
What do I need to enter for my 2nd criterion range in an index-collect formula?
Hi all, I'm looking for help with an index-collect formula. I want to collect the venue name from an existing sheet using the project name as my criterion. The problem I'm running into is I'm not sure what value to enter for the second criterion range. Below is the formula I currently have, which I know is incorrect. Any…
Does reordering columns impact any other existing logic? The column title would remain unchanged
Does reordering columns impact any other existing logic (datamesh, formula, workflow, helper columns)? The column title would remain unchanged. Specifically, is there any reason this could impact a helper column using a formula that references the column being reordered?
CHALLENGE: Unpivot financial data (reverse pivot)
I have a challenge for this awesome community.... has anyone successfully found a way to unpivot data? I need to take columnar data ($ per month with each month in a column) to become row data (each project and month on a row). I need to do this in order to mesh user-entered horizontal forecasts, with Oracle-sourced…
Help to create a "3 Dimensional Reference" Formula
I am trying to create a sum of the same cell in four different Metrics Sheets. I have created the following formula and I get the Unparseable error. Would appreciate help, please.
IFERROR and MATCH Formula not pulling in formation - Prodactive S-Curve
hello, i came across a Video by Prodactive about S-Curves in smartsheet and so far everything has been working exactly as expected with one major exception; the "Actual" baseline. From the video and the downloaded examples, i used the exact same formula and referenced my sheet name versus what he had in his example. But…
HELP: What formula should I use?
I have a data set and one of the columns is a drop down where you can choose more than one option. I am using the Countifs formula because I have multiple owners and i am looking to capture the number of goods that owner has sold. Lets say the one column is Joe, Bill, Tim, Alice and the dropdown options are Apple, Banana,…
Row height problem
Hello! I have looked through a lot of searches, and cannot seem to see a resolution to this problem. Sorry in advance if I'm missing something easy! I have a sheet that allows an input word in the yellow box to search another sheet. Looks like this before entry: As soon as you enter a word, and hit enter, it uses a formula…
Automation and/or formula in one sheet to change cell in another sheet?
I have ten sheets in our workspace, one is the master sheet that leadership uses to approve department requests, the others are department specific spreadsheets that are populated by a request form for each department to manage their requests. Each department specific spreadsheet has a status field to track where their…

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

I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags