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.

Sheet Summary SUMIF Function Problem
I have a sheet called Order Execution with many columns for data. [As Ordered Dealer Net Amount] is a text column for inputting sales financials [Pierce Fiscal year Sold] is a single select list column with FY2021 etc. for choices. I want to add a sheet summary formula that will SUM all As Ordered Dealer Net Amounts where…
COUNTIF Formula
Need assistance with the following formula: Column labeled "CA Tier" has four categories, on the Excel spreadsheet that I'm mirroring, the formula is for CA is =COUNTIF($F:$F,S7), what is the formula that I would use on the Smartsheet?
Is it possible to color code the Empty, Quarter, Half, Three Quarter, and Full Harvey balls?
I'd like to combine 2 input columns into a single color coded harvey ball. For simplicity lets say 1 column is ProgressInput (Empty, Quarter, Half, etc) and the other is StatusInput (Red,Yellow, Green). For the output column on a dashboard report I would want to see a quarter-full ball with either red, yellow, green or a…
How to auto update gridline entries?
I'm creating a database for users to upload documents to share with the work group and I was approached with a concern on how will the documents will be updated once a new version is created. I created a Form to ease the upload and categorizing process for the user but I don't know if there is an option to be able to pull…
End of Year Rollover
Good afternoon, I have been given the task to do a year end rollover. This has me duplicating each sheet, but then having to go in and change formulas for the additional sheets I'm creating. This is a very time consuming task, and I'm sure there has to be an easier way. After googling and trial and error, I have yet to…
Trying to change a logo/color scheme to existing worksheets and forms
Hi, I've had a change in logo and colors and can change it on my account, but can't seem to change it on existing workspaces or worksheets and their forms. I became the admin for the account and all its documents when other people left, so I should have rights to do what is needed. Thanks, Sarah
Sum Column Divided by Two Summed Columns
This is the formula I'm using, but I'm getting unparseable: =(SUM([Actual final door count]:[Actual final door count])) / SUM([Inspection & minor repair labor hours]:[Inspection & minor repair labor hours] + [Repair labor hours (return trip)]:[Repair labor hours (return trip)])) Here is what the data looks like: I need the…
Report on a Grouping
I have a source sheet which has STATUS, ACTIVITY and LEAD names. I am trying to get a summary report or report or anything to be honest where i can report on the number of activities by Lead and Status. Here is the sample data: What i would like to be able to produce is a table which shows each lead the number of…
Formula's won't work together
Hi! I need to get the below formula to capture both project stages but when I add them together it gives me zero which is incorrect. I need the metric to match the report on the dashboard, any help is appreciated! =COUNTIFS({HR Projects - PMO Range 4}, >=TODAY(1), {HR Projects - PMO Range 4}, <=TODAY((30)), {HR Projects -…
Deleting all Sheet Information
When I make a sheet into a template - is there anyway to remove all of the current data (besides manual selection) so that the template information is blank?

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

Calculating the total duration from a date & military time start and end
I have been looking at a lot of information on this site and this is the closest one I have found, however it does not calculate the minutes correctly. For example instead of 8hrs and 45 min it gives me 9hrs and -15min. Formula: =(([On-Site Date]@row - [Notification Date]@row) * 24) + VALUE(LEFT([Time of Crew arrival]@row,…
VLookup help
HI. I need to look up a # based on the entry entered in one column. I have established a look up table, but having a difficult time with the formula. example - I enter ACME Supplies and I want it to look up the vendor number in the table and return the value into the corresponding field.
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags