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.

Latest Score Given
I am trying to return a score based on the date and contact. what I am looking to do is search my list of names and show what the last score each person was given. I can easily come up with the last date a score was given but I am stuck on how to get the score that is related to that person and date.
how to define who the approval is from multiples
I have migrated our Engineering change to smartsheets which is working fine. I now want to progress this by adding approval requests. We can get changes approved by 3 different people, so I have created an approval request which gets sent out once a box is checked to declare the change is ready for approval. At present…
Finding preceding dates
I've created a productivity dashboard for myself and need to find a formula that returns the previous months so I can reference them in a COUNTIFS statement. I have a formula which works fine BUT it doesn't cope when the date crosses a year boundary, ie if the month is September (month 8) my formula will get August's stats…
Single-Use Checkbox (or dropdown) - Can it be done?
Hi all! I looked in the forums and I didn't come upon any which matched this - but if you're aware of a similar thread, please link to it here! We are looking to find a way to make a checkbox or dropdown option a single-use type thing. Basically - we track travel in a large sheet - and part of the information we collect…
Auto-populating formula when pasting multiple rows
Is there a way to populate formula in columns if multiple rows of data when pasting several rows to the columns next to formula column? I would be willing to use CTRL +D, but it does not work in either of three browsers I have.
Formula for Sum of # amount and Dollar Amount
I am trying to create a Dashboard to show two things: #1- To show how many (#) of each industry that are “wins” and how many (#) of each industry that are “forecasted”. The columns are titled "Industry" and the "Stage" column has the information for Wins and Forecasted. Wins= "5 - Win" and Forecasted = "0 - Lead", "1 -…
Display multiple Values depending on selection
Hi guys (1st post!) I'm trying to display different numerical values in a cell depending on what selection is in another cell's text dropdown. Example Dropdown choices.. Bob, Bill, Ben.. Cell A1 In Cell A2 I want to show '1', '2' or '3', depending on the A1 selection. I've been trying to use IF statements, but can only get…
How do I use a countif formula to count the number of various priorities?
I have a column for priority which returns symbols. Exclamation = high, dash = medium, and down arrow = low. I have tried various formulas and nothing is working. I basically want to know the amount of highs, mediums, and lows in my sheet. Help please! Thanks, Dacey
Need help for a formula
Hello everyone, I am pretty new to smartsheet so thanks in advance for your help. I am creating budget template sheet, and I have a BUDGET COST column, an ACTUAL COST column and a DIFFERENCE column. When my actual cost column is blank, the difference automatically calculated like if it's at 0. Let's say I have an estimated…
Using Addition and Multiplication in the Same Formula?
Hello everyone, I am trying to calculate an amount based upon the sum of two numbers. If you look at my screenshot, the highlighted Hotel and Transportation budget amounts are based upon the # of Days Onsite plus # of Travel Days. I need the system to be able to add those two numbers together and then multiply it by the…

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

Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags