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.

Help with SUMIFS & INDEX/MATCH Formulas
I need to first find the column number where the number 1 resides on the "Lookup Value -->" row. Next, I need to shift two columns to the right, which would be "4/2019 C" and sum the values for Client B, I have tried various combinations of SUMIFS, INDEX(MATCH()), etc.,but with my last attempt, I received #INVALID VALUE…
Sum ifs 3 criteria
I'm looking for the sumifs= Status column is "green", The Trans Date column in January 2018 the reversed column is unchecked. So far I only have the first part of the formula working. I cannot figure out how to include the rest =SUMIF(@{Collections Range 3}, @cell = "Green", {Collections Range 1}) This information will be…
Is there a shorter way of writing this IF statement?
Here's the working statement: =IF(AND([Account Owner]191 = "JK", [SALES REP]191 = "JK", OR([BILLED BY]191 = "Merit Medical", [BILLED BY]191 = "Don Joy"), STATUS191 = "Paid"), CHARGES191 * 0.14, IF(AND([Account Owner]191 = "JK", [SALES REP]191 = "JK", OR([BILLED BY]191 = "Cerapedics", [BILLED BY]191 = "Surgentec", [BILLED…
Split-screen auto populate?
Hello all! I have a smartsheet that is always open in our warehouse to let the guys know when an item needs to be shipped; the line is added by our procurement team. After the warehouse personnel complete a shipment, they mark the status of that line as complete and save. The line then gets crossed out but stays in the…
Creating Summary on the Fly
This may be a dumb question but I have a sheet Orders that is auto-updated every morning via the Data Uploader. So the list of items changes on a daily basis... sometimes the same items are listed and sometimes new items are listed as well. Is there a way I can create a summary sheet or grouping of duplicate items and…
If forumula
I trying to write a formula if (Days)<=30 will display an Amount in column 0-30
Referencing other sheets
Ok I have one sheet that I have a formula in that references the data in another sheet. The name of the source sheet is "Drug Seizures" When I start my formula in the destination sheet, I click on reference other sheet, select "Drug Seizures" and then the data I want to reference. When I look at the formula in the…
Nested IF Formula Help
I have two Nested IF formulas that work separately, but keep given me an "incorrect argument set" error when I combine them. The two formulas are: =IF(OR([Current Status]1 = "Completed", [Current Status]1 = "Terminated"), "Blue", IF(AND(OR([Current Status]1 = "Planned", [Current Status]1 = "Allocated", [Current Status]1 =…
Method to update field automatically (based on other field updates)
I was looking to see if there was a way to make an update to a field based on the status of other fields in the sheet. In my example I have a review process that sends multiple emails at once for review and approval. The reviewers each have a field that the indicate approved or rejected in. Once all of them have approved I…
RYG Balls
For this formula, I would like the RYG balls to be the result. Instead, I’m getting the word “Green” or “Red”. So the formula is working, but would like the balls and not the word.

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

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags