Welcome!

Upcoming free webinar on 3/12: Introductions to Formulas!

Join us for an introduction to formulas. In this webinar, you will learn how to:

Additionally, we will be hosting our Advanced Formulas webinar on 3/19!

Learn more and register HERE.

View upcoming webinars HERE.

There are no comments yet

I cannot seem to cross reference a sheet to another sheet and im going insane
Hello I know this might be very simple but I have tried everything to cross post a value from one sheet to another and I always get the wrong ref error or the unparseable one, this is the formula I'm trying to use, please help. =COUNTIFS({RE Projects Range1}, "Counter", {RE Projects Range2}, "Complete")
Cross Sheet Formula For Averaging Total Turn Around Time
I’m looking for a cross-sheet formula in Smartsheet to calculate the average Turn Around Time (TAT) by specific Site Numbers. Source sheet details: Site Number (text/number) Turn Around Time (number; measured in days) Target sheet details: I have a row per site and want a formula in the Avg TAT column that returns the…
Counting Distinct Items in Sheet1 from Sheet2
I have a counting formula that's working in Sheet1. When I try to use that same formula in Sheet2 to pull the data from Sheet1, I get an UNPARSABLE error. What am I doing wrong? Original formula (in Sheet1): =COUNT(DISTINCT(COLLECT([Department]:[Department], [StartDate]:[StartDate], >=DATE(2025, 7, 1), [Status]:[Status],…