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.
Discussion List
Formula Question
I need to create a count formula that counts an item from a multi-dropdown column in another sheet. Not related to a string of information. Can anyone help? Thanks.
How to Create a Chart Line from Multiple Years Data
I'm trying to create chart line in Smartsheet that shows the total cost for the last 6 months which includes August through December of 2023. How can I format my data so the information I'm trying to select can be reflected in my chart without getting an error message like the one show on my screenshot? ( Please select a…
How to setup conditional formatting comparing dates between two cells
I'm looking for a way to setup a conditional formatting (I assume) comparing the dates in two columns in the same row. Specifically, I'm working with "planned material receive dates" and "planned work dates". If the "planned work date" is before the "material receive date" in the same row, I would like the "planned work…
What is a system Column ?
What does this mean?
Pull data in an column from master sheet if a check box is checked
Hi, I have a master sheet called "a_Portfolio Master" and a new sheet called "Country". The portfolio master has many lines. Column 3 of the master sheet contains a checkbox. When the checkbox in column 3 of the master sheet is checked, I would like to copy what is in column 2 of the master sheet into column 2 of the new…
Total Price for multiple selections
I have an order form that has a drop-down column. Within that drop-down, you can select multiple things. I have a total of 35 items. How can I have Smartsheet total the cost for the selected items? I have another sheet with all the tooling and cost.
Automatically add a due date from a creation date
Hello I am currently using a smartsheet as a job tracker, where team members can fill out a form with their requests. I have a column labeled urgency that has, Low, Medium, High and on hold, the different urgency dictates the due date. What I have at the moment is the date is saved when a new row is created, and I want the…
Broken SUMIF Formula - Sum of column based on info in another column
Hello everyone! I am currently attempting a SUMIF equation that initially worked and is now broken. Here are the parameters. I would like the sum of the dollar amount in this column "FY24 Adopted Budget" to show in a cell in this column, "July Expenditure" based on the information in these columns "Cost Center" (Dropdown…
Formula for cell Link
Hi SS Community, There is a single cell with a hyperlink in our project metrics (metadata) sheet that we want to display in every cell in a column in another sheet. The idea is that we can create a dynamic report across all of our projects and include the column for the respective hyperlink so it will be right there on any…
Using automation to update a date field
I know you can use the record a date automation to record the current date in a field, but is there any way to update a date field to a chosen value? We have a date field for the finishing of a task - date finished. If the user selects a Release value from an other drop down column, we want the date finished field to…
Help Article Resources
Trending in Formulas and Functions