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.

Countifs Formula Help
I've used this formula a few different times on various sheets, but I can't figure out why it's returning an in correct argument error: This is the formula: =COUNTIFS({call_history_from_08_31_2020_to_10_31_2020 Range 1}, Day153, {call_history_from_08_31_2020_to_10_31_2020 Range 2}, "incoming") Any help is greatly…
folder colors & organization
Maybe this exists, but I haven't figured it out... I'd love to be able to color code or otherwise visually organize the folders and files within a folder.
COUNTIFS Formula based on Dates
I'm trying to use the COUNTIFS Formula to count a range that has to be greater than 0 as well as within a certain month. I've gotten a formula to work but it would be cumbersome to implement in any way. Has anyone done this with success?? It would look something like this: =(COUNTIFS({Kettle 1}, AND({Month}, DATE(2020, 10,…
Count
How do I write a formula to count rows in a dynamic sheet that sheet that keeps growing? How do I reference a column when we don't know where the end will be? Thank you
Can someone supply the proper syntax for calculating both budget and schedule variance?
Need to determine the budget percentage variance bewteen estimated and actual costs. In addition, need to do someting similiar for project schedule variance. Need the exact syntax for a column formula, apparently I am doing something wrong.
Alerting Someone
Hi We are using the PTO & Project Staffing Template set and I would like to know if I'm able to set up an alert if someone exceeds their hours for the week? Currently it only shows as red on the Master Resource Roll up so, users are having to constantly flick between the two sheets to see the week they have over allocated…
Is there an alternative to =SUBTOTAL in Smartsheet
Hi Guys, Trying to to find a formula that will allow me to sum a row based on the filter that I have setup on the sheet. I've included a screen shot of the filters I have on the sheet as an example. I have created a summary formula to count the column but I need this to change count based on the filter options I choose.…
Automation
Is it possible to include functions in workflows??? For example, everyday @ 11pmEST, I want any rows that have "Completed" checked AND that are 60 days old or more from that days date, to move to another smart sheet. Please advise if able.
Formula to match Payment Terms to a number (Nested If Formula)
Hello, I am trying to match a number based on the value of Payment Terms. For example if Payment Terms if NET 30, NET 45, or NET 60 I want to make a formula in a separate column that match the number portion. For example Net 45 should become 45 in a separate column. My formula only seems to work if the Payment Terms is NET…
Mutiple If Statements
I have looked through this thread and can't figure out what I am doing wrong... In quiz results, for scoring, I want column 1A to flip the numbers of Column 1. 1=5, 2=4, 3=3, 4=2, 5=1 =IF([1]@row = 1, 5, IF([1]@row = 3, 3), IF([1]@row = 2, 4), IF([1]@row = 4, 2), IF[1]@row = 5, 1) How do I get this to work?

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