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.

5x5 Risk management formula
Can anyone figure out what's missing in this formula to set a rating from a 5x5 risk matrix. I copied the format from the risk assessment matrix template set that is a 4x3 matrix and modified. =IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible", Likelihood5 = "Likely"), Consequence5 =…
Sum children if a condition is met in another column
Hi, Im trying to count the children of column [Estimado Importe Total] but I just want to count the values if the condition in column [Estatus Factura] says "Pagada", if not I just want to skip that row and count the rest of the conditions that are met. Here is my example: Hope someone can help me. Thankyou!
Return Data based on two conditions being met
Hi, Please can you assist with a formula that checks data from two cells within a sheet that will then populate a matrix sheet. The data sheet is being populated via form currently. If Property Name is "Mykonos" and if Quarter 2, then return the % Score I keep getting "Incorrect Argument Set Errors" :( In the Matrix, I…
Log the date and time a cell changes to a specific value
Hello. I've got a sheet I've developed to track approval of purchase agreements. After an agreement makes its way through the approval process, I have the cell "Final Approval" display the words Agreement Final Approval, and the cell is conditionally formatted to red. The main users would like me to log the time and date…
Tracking date when a drop down value is selected
I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items are changed. I thought of using an IF statement where if "design" is selected, then…
Index and Match Vs Vlook up
Hi all, I was advised to use Index and Match as I am pulling dates from various schedules into one sheet. Last time Vlookup worked really well however there was a limit of 25000 links. Now I am using index and match and the limit is even low. It says I have reached a limit for cross reference. Kindly advise.
Automatically autopopulate a cell from a cell in the same column based off the date in its row?
I want data I enter to automatically input into my summary table if it is from the previous month. Can you automatically autopopulate a cell from a specific column into another cell based off of the date from its row? For example, can I have the Associate Healthcare number from last month automatically populate into the…
Column formula edit
I was able to convert a row formula to a column formula. However, now I need to edit it and am getting the message that only the sheet owner and admins can edit. I am the sheet owner. What do I need to do to edit the column formula? Thanks in advance!
Copy rows to another sheet with formules
Hello, Is there any way when I copy rows with formules from one sheet to another to keep the formules? Did not work for me so I doing the formules again. Best Rehards, Angela Formiga
Relative Dates
I am trying to duplicate the formulas in another app that uses dates like: every Tuesday, the 3rd Thursday of the month, etc as due dates instead of specific dates.

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