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.

formula to populate due dates
basically I want my due date to be based of off the status below: Bar layout needed – 2 days Concept – 5 days Design changes – 3 days Assembly reviews – 1 day Concept – 5 days so I was trying something like this: =IF([Status] = “Bar Layout Needed”, =TODAY()+2 workday I am just trying to get one of them to work first then i…
Average Formula
If I am wanting to find the average of wage rates that are referenced on another sheet, how would I create that formula? I have tried several different things and nothing appears to be working.
referencing another sheet I need all clients in the client column, I need All Clients
My formula is as follows for 1 client: AFR =COUNTIFS({LPSC tickets Range 1}, "Production", {LPSC tickets Range 2}, "S2 - Urgent", {LPSC tickets Range 3}, "AFR") There are 10 different clients in {LPSC tickets Range 3} - these clients are used various times throughout the data. Question: How do I find out the number of…
What am I missing....
Some Background: I have been running these sheets for over 6 months and the formulas have never been a problem. It is a SUMIFS where the criterion is being searched for in a different sheet. I added a new column and wanted to do the same formula but searching in a different sheet. Column "Funds Spent MASTER DUMP" is…
My Count If formula doesn't work with a < in the field i need to count
I want to count the number of rows which have the <50sqm in the Implementation stage column, i don't get an error with the below formula but this also doesn't give me the correct number, it just returns a 0. =COUNTIFS([IMPLEMENTATION STAGE]:[IMPLEMENTATION STAGE], "<50sqm", [BUILD START DATE]:[BUILD START DATE],…
Form Submission Start of Shift
I have a form for the start of shift for operators. Safety inspection, 3s inspection, and other things they are supposed to do prior to starting their shift. For the location that I am attempting to implement this solution, we are running a 3 shift model.6am-2pm 2pm-10pm 10pm-6am I want to show a RYG for each shift if they…
Simple IF function not working
Hello, I have an issue with a simple IF formula. Here's the formula: =IF(Completion1 = "100%", "Closed", "Open") for Overall Progress Column. It's not working. Even if the value is NOT equals to "100%", the value showing is the false one (Open). I don't know why it's not working. A note: The logical expression (Completion…
Sum of multi select dropdown items with assigned values
I have a column (Design Software) formatted as Dropdown (multi select). The dropdown values are names of software products. I want to give a value to each software reflecting the respective cost (e.g., Adobe Substance = 3000, Browzwear vStitcher = 19000, etc.). I added the formula below in another column (Software Cost) to…
Adding Checkbox
Hello! I'm trying to figure out a formula that will allow me to add all the checked boxes in a column. I have created a form asking about race, ethnicity, etc. and need to know the totals of each at the top of the column. I have searched around in the forums to try to figure what to do, but seem to be having a hard time.…
is it possible to list in the sheet the date of updating the sheet automatically?
is it possible to list in the sheet the date of updating the sheet automatically, is there any formula for it?

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