Trending in Formulas and Functions
-
using a COUNTIFS formula and @row
Hi there, I need assistance with formatting this formula: =COUNTIFS({Program Name}, (@cell), {Program Name}, [Program Name]@row)) My goal is to count the number of attendees per program session in our dynamic list. Given that the list is regularly updated with new program names, I'm seeking to count the rows based on each…
-
Cross-linking cells to reports or summary sheets?
Hello SmartSheet Community! I'm trying to find a solution to a few problems, but if I could cross-link cells to summarized fields in a report or sheet summary, it would solve my problems, but it doesn't appear to be an option. So first question: Is there a way to cell link to a summarized field in a report or sheet…
-
Pull Data from Another Sheet based on Criteria
Hello, Below is my master file of projects. I've filtered to show all the values based on "Automation" in the Drop Down column. Each project is designated with a project #. I want this sheet to function as a way to automatically carry over all the project #s from the master file to my new file (see below) based on all the…
