juliesilverio ✭✭✭✭

Overview

Overview

Roles	Member
Badges	35

About Me

About Me

Industry	Biotechnology
Area of Expertise	Program Management, Pharmaceuticals, Biotech
About Me	I'm a graduate of Penn State (We Are!) and live in sunny San Diego.
How I Use Smartsheet	I use Smartsheet to enable my organization to track our drugs through preclinical and clinical development--and hopefully in the future to the global market to help patients worldwide! I help to create and manage timelines, templates, dashboards, reports, and ad-hoc requests, like formula help and trainings.
Linkedin	https://www.linkedin.com/in/juliesilverio/

Analytics

37

Posts

99

Visits

20.3k

Points

Aug 27, 2021

Join Date

Jan 25, 2024

Last Active

Reactions

• Insightful 2

  2
• Vote Up 1

  1
• Awesome 18

  18

• Discussions
• Comments37

• Re: Why is this formula #invalid operation

  juliesilverio

  01/17/24
  Hi Ricky, I believe it is because of your date formatting. I would try the below: =COUNTIFS([Flight]:[Flight] "FSC", [Date of Award]:[Date of Award], AND(@cell >= DATE(2023, 01, 01), @ce…
  1 ·

• Re: How to create a to-do list that draws from all sheets?

  juliesilverio

  01/18/24
  Hi Sean, I would approach this by creating a row report including all of your different sheets that assign you to tasks in your source sheets. Here is an article that walks you through how to set up …
  1 ·