Austen · Director of Analytics · ✭✭

Overview

Overview

Roles	Member
Badges	3

About Me

About Me

Title	Director of Analytics
How I Use Smartsheet	Manage intake systems and track candidate progress.

Analytics

7

Posts

11

Visits

35

Points

Oct 10, 2023

Join Date

Jan 16, 2024

Last Active

Reactions

No reactions yet.

• Discussions3
• Comments4

Discussions

• How to count total number of times a value appears in cells with multiple values.

  I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is th…

  

  Answered

  Forms

  Formulas

  Reports

  Formulas and Functions

  234

  Jan 16, 2024

  3

• How to count total checked in report instead of just total number in report?

  I am trying to use the report to summarize some data to ultimately put in a Dashboard. In the screenshot I am actually trying to count the total number of T4C completed which would be indicated by the…

  

  Answered

  Formulas

  Reports

  Countif

  Smartsheet Basics

  272

  Nov 22, 2023

  3

• Can I used conditional formatting to high duplicates in reports?

  We have several grant programs within our organization and I am working on funneling all the form submissions from each into a main report. I would like that report to identify duplicate submissions s…

  

  Answered ✓

  Government

  Reports

  Conditional Formatting

  Government

  1076

  Oct 10, 2023

  2