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.
Discussion List
Adding Names from Sheet 1 to Sheet 2 with Counter update and handling duplicates
Good afternoon, I'm trying to achieve the following without success: I have Sheet 1 that as forms are submitted a Names column is filled. I have Sheet 2 with a Names and Counter columns When a new submission occurs, I would like to get that name from Sheet 1 and add it to the Name column in Sheet 2 if it doesn't exist…
COUNTIF for Metric Sheet with Multiple Cell Values
Hello, We have 4 primary locations but several staff who work remotely and enter their various city or state in a non-restricted drop-down column. I am trying to create a metric sheet for a chart that counts the total staff in each of the 4 primary locations and everyone else into a "Remote" bucket. I figured out a…
Counting cell with dates
Hello all! I'm trying to count the number of cells that have a date that falls within a date range so I can get the count of how many times an incident occurred each month. In the image below I have a list of dates. I need a formula that counts all of the January dates and so on. Any assistance will be greatly appreciated.…
SUMIF when one column is blank
I want to SUM autototal # only when customer exclusive is blank and the studio = xyz and the market year is 2024 These formulas below don't work. I can't get the formula to exclude the rows that are customer exclusives from my total. I get incorrect argument or unparseable anyway I try to write it.…
Not giving up on trying to get this to work!!
3rd time lucky... Is it possible/how can i link a helper cell from one sheet to the selected date on another? Once a date is entered here ..... I need the primary column info to go to...a cell on the same date here There must be a way!
using OR function with long formula
I have a "ledger" sheet that I use to calculate real-time budgets based on any changes and shifts that come through a request system. Currently, it's built for F24, however as we move towards F25, I want to add in options to include F25 budget change requests/shifts. In order for my sheet to calculate correctly, I need to…
How to pull data from another sheet
Hello, I am populating the first two columns (Course Number and FSS Support) from another sheet where the data is already housed. I can't figure out how to set the formulas up. Thank you!
Return a value from a cell based on today's date
Hello everyone, I am creating a metric sheet to track the total hours, attendees, and person hours of meetings and would like to track it based on today's date. In the example above, I would like to use TODAY() in the top row under the "Date" column. Then if the date in the rows below are in the past, return the…
COUNTIF returning #NO MATCH
I have some sheet formulas that were working but once I made a few updates, not all return the #NO MATCH error. It's a simple COUNTIF formula that references a cell that populates from a VLOOKUP. When I recreated the formula on another blank sheet, it works fine but, as you can see below, the sheet formula will not work.…
How to count reference stored daily to a sheet storing weekly.
I have a sheet that stores records daily (several per day) of installations categorized as either "Res" or "Com". I'm trying to count the "Res" category above based on week ending dates (Sat) below in "Meters Installs Actuals (RES)". So for Week Ending 01/14/24 the formula would count all Res from 01/08/24 to 01/14/24.…
Help Article Resources
Trending in Formulas and Functions