L_Christine · PMP Consultant · ✭✭

Overview

Overview

Roles	Member
Badges	3

About Me

About Me

Title	PMP Consultant
Area of Expertise	Project Management; IT
About Me	Life Long Learner
How I Use Smartsheet	Managing a complex IT System Upgrade

Analytics

8

Posts

28

Visits

46

Points

Sep 27, 2023

Join Date

Apr 17, 2024

Last Active

Reactions

• Awesome 1

  1

• Discussions4
• Comments4

Discussions

• How to Set Up Tracking for customer builds - Recommendation for best Smartsheet approach

  Hello Everyone, We have an item that is the same. We build it at customer locations and each build projects has the same milestones. We want to start using Smartsheets to plan and track each project a…

  

  Answered

  Formulas and Functions

  121

  Feb 28, 2024

  4

• How to cound items in a RAID log using the Health Color

  Hello - I would like to reoprt the # of green, vs. yellow vs. red items in my RAID log and use that # in a chart on dashboard. I use a lot of countifs but I am not sure how to countif the health colum…

  

  Answered ✓

  Countif

  Formulas and Functions

  153

  Jan 30, 2024

  3

• Is there a way to include a real time update of date in a title?

  Hello - I am asking this question on 10/17/23. I am using countifs to report on the # of items assigned to specifc employees that have a status of "new" or "in progress" or "closed" and the count upda…

  

  Answered

  Smartsheet Basics

  113

  Oct 17, 2023

  1

• Using Countifs in a cross reference formula

  Hello - This is the formula I am using: =COUNTIFS({Company RAID Log Range 1}, "XXXXXX", {Company RAID Log Range 2}, "CVI") Company RAID Log Range 1 = LEAD Column Company RAID Log Range 2 = Ownership C…

  

  Answered

  Formulas and Functions

  161

  Sep 28, 2023

  3