Formulas and Functions
Archives for January 2022
Discussion List
- Hi, I have a sheet that gives a "score" of Pass or Fail. Multiple rows per user. I originally had percentages as the score and we created a metric sheet that gathered the scores and gave an average pe…
- I have a grid with Order data, one order per row. Each order has an order date. In the Orders grid Sheet Summary, I have the following formula for Weekly Total to capture the last full week of data: =…
- I tried to create a formula with a structure like COUNTIF(column:column, YEAR(@cell)=2021) and was getting an error. I realized that if I changed to COUNTIF(column1:column23, YEAR(@cell)=2021), the fo…
- I want my query to look up the Finish column to determine what month it should display, 1 = January, 2 = February, etc... but if its blank, I want a blank to appear. Right now it says "Invalid Data Ty…
- I have a reporting use case where the project managers have to enter a reporting code so that reporting roll up occurs in the correct fiscal quarter. I want to automate the assignment of the reporting…
- I'm working with SmartSheet to make a spreadsheet and I've noticed that the column formatting controls do not consistently apply formatting such as centering cell content. Please see the attached imag…
- Is there a way to auto copy selected columns to a single budgeting sheet without manual cell linking? We use multiple sheets to plan and track our ongoing projects but need key pieces of information b…
- First, this community is GREAT, and has really helped me with understanding formulas, so I'm hoping someone can help with a frustrating error. I have a list of projects where I want to designate "Y" i…
- I am looking to create a sheet that moves through our 5 stages of work and how much time is spent in each phase. What is the best way to go about this?
- Hello, I'm having difficulty including in a IF(OR formula that is looking for a not blank column. This column is intended to be a helper to build a report which incorporates both AND and OR statements…
Help Article Resources
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hey friends, I'm finally figuring out a complex system to have a first sheet with a Dropdown data row, matched to a column with a helper row that only highlights the MAX (most recent) dropdown. I'm do…
- Expected CPM is generated using three columns from another sheet. Column 1: OSM SKU Column 2: OSM TF Column 3: OSM CPM I have tried IF/ IF AND / INDEX(Collect), all I get are errors. IF OSM SKU is xxx…
- Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1. Columns: National_l…