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
Hierarchy:Hierarchy Formula
This formula was present in a template built for us and is in the Summary section of a Project Plan, but it is not tallying up the total counts of the different Statuses. I was able to correct this with a different formula, (=COUNTIFS(Status:Status, "Not Started")) but I was asked what the pre-built formula was meant to…
COUNT DISTINCT Using Dates
I'm trying to count how many days in a set of data based on criteria of other columns, yet it's returning an answer for the entire sheet instead of the selected IF range. I've tried =COUNT(DISTINCT(Date:Date), IF([Year / Month]:[Year / Month] = [Date Field for Klipfolio]@row)) My aim is count unique dates from "Date"…
Count how many times a cell value changes across a row
Hi all, I'm stuck on a formula - I am trying to find a way to count how many times a cell value changes across a row e.g.: How many times does the adviser name change across all these rows, and calculate in the end column called"Count"? Would be grateful for any help. Thanks, Meg
Hello , how can get unique names
How can get just heading names like org and others
Date Calculation Formula
Hi I'm after some ideas on the best way to calculate a [Date of Next Review] based on either a [Start Date] or [Last Review Date]. If the Start Date is in the last 12 months of today and [No. of File Reviews] = 0, I need the [Date of Next Review] to be [Start Date] + 3 months If the Start Date is in the last 12 months of…
Add new row to Sheet A when Sheet B is created
Hello, I'm new to automation, so I have a lot to figure out. Currently, I've created a workspace with a single sheet acting as a template. When a new employee joins our organization, that template is copied manually. The template contains the onboarding task for new employees. Each task is assigned to a different member of…
Using SUMIFS with dates
Hi, I am trying to create a formula for summarizing data from a time log. I have a row with person's name, auto-generated row creation date and time spent in hours. I would like to make a formula that takes the sum of times spent only for a specific name and only if the created date was in the last 7 days. I am doing the…
Again:
I have this list i want make like this
AVGWIF
Hello, I am trying to create a formula which will calculate the average weight of a series of tasks associated with a specific category. Basically, a SUMIF but instead of a sum of the numbers, an average weight of the numbers. Here is a sample of my data. All numbers in green are manually entered as progress occurs. The…
Expanding Tasks when a Filter is On
Hi new to SmartSheet and I'm trying to expand my task when a filter is on, but it not allowing me to do so which defeats having a filter. Any one know what do I need to change in my Column to do this? Thanks in advance
Help Article Resources
Trending in Formulas and Functions