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
Populate Column From Another Sheet's Dropdown Menu
Hi all! I was wondering, is it possible to populate an entire column based on the dropdown menu from another sheet? I have one sheet where all tasks are listed, and are assigned to people via a dropdown menu. I am trying to create another sheet as a cross sheet reference that summarizes hours of every individual. What I…
Counting number of rows that each have their own count
I would like to create a summary field in the following situation. We have a sheet where users log hours. They can have multiple rows for different days. We want to keep track of how many users log hours greater than a certain number in a 90 day period. For example, we want to count the number of individuals with hours…
Need help with cross sheet SUMIFS syntax
I have one sheet that is a master inventory sheet, and another with a bunch of formulas pulling data so I can build a report. I have been trying to specifically set up a formula that sums up all cells in the "Stock" column, only if it matches a specific keyword in the "Location" column. I have cross sheet references set up…
Flagging a duplicate reference across 2 sheets
I have an intake sheet for users to submit a New Supplier Request. This generates a New Supplier Document. Once created, this entry moves to an archive sheet There will be scenarios where someone will submit a request for a New Supplier, of which a document already exists: I want to eliminate this issue as I cant have two…
How to sum children rows and exclude parent/grandparent?
I am trying to pull a report from my sheet to sum the children rows, and exclude the parent and grandparent. I am tracking budget expenses and have the totals summed on multiple parent rows (light blue), which rolls up to the main grandparent row (dark blue). I'd like to summarize the children based on status of the task…
Count IF Question
Hello all, just me again with another Count IF question!!! I was curious if anyone could assist with a question of mine. I am using 2 Sheets. On Sheet A I have Audience Names that I am trying to match back to another sheet and see how many different campaigns are tied to the Audiences. I currently am using a count if…
Column Adding up to a certain number
Hello, we are using Smartsheet to process our annual merit for all employees. We have a column for Increase Amount - which will be a number value that the employees salary is being increased by. Since each manager will have a budget for their area, is there a way to set a trigger that if the values in that column go over a…
Creating a Formula where there is multiple selections needed.
Good Morning Smartsheet Community. I have been struggling with these formulas for a few weeks now and decided to finally reach out for some help. I am trying to make 2 formulas but there is a part of the formula where I need to reference 2 options in the same drop down. I think I am tripping myself up when it is having to…
MAX COLLECT across a range
I am a bit stumped and looking for a little help. I have a forecast sheet with a form where the user has to submit their monthly forecasts for the quarters across five subject areas. I have a column for each quarter and each subject area, 20 columns is my range, Forecast worksheet: Quarters For example purposes please…
If(Contains) issue
I am trying to look at a column on one sheet and if it contains a certain value or multiple of the values that I am searching for, return a sum of value(s) from one or more specific cells that are contained in a separate sheet, otherwise return as 0 or as if nothing has happened. This is the formula I have come up with but…
Help Article Resources
Trending in Formulas and Functions
COUNTIFS formula for any future date?
Hi all, I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date. I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working. Any advice would be appreciated! Thank you.
Sheet Summary Field - Count Value from Dropdown
What's wrong with this Formula? Getting an Invalid Ref
I am trying to get a unit count between a date range.
I am trying to get a unit count between a date range. I have two difference columns from one sheet and two difference columns on my main sheet I am referencing. I keep getting unparseable. Is there a way to to get the number I want with using the countifs formula? Or should I be using a different formula? This is the…