Ollie Cater ✭✭

Overview

Overview

Roles	Member
Badges	4

About Me

About Me

Not much happening here, yet.

Analytics

17

Posts

26

Visits

47

Points

Apr 8, 2021

Join Date

Apr 29, 2021

Last Active

Reactions

No reactions yet.

• Discussions4
• Comments13

Discussions

• Remove "In Progress" from formula, but comes back unparseable

  Good morning! I would like to change the behaviour of the below formula that defines rag status... =IF(Status@row = "Complete", "Gray", IF(AND(Status@row = "In Progress", [Due Date]@row > TODAY()), "Y…

  

  Answered ✓

  Formulas

  Smartsheet Basics

  141

  Apr 19, 2021

  5

• Creating a report by task owner and RAG status

  Hello Smart Sheet-ers, I am fairly new to SmartSheet so excuse me if this is breathtakingly simple. I need to create a report of the following in dashboard. I assume from using Sheet Summary. It needs…

  

  Answered ✓

  Reports

  Dashboards

  Sheet Summary

  Smartsheet Basics

  851

  Apr 14, 2021

  8

• Creating a report by task owner and RAG status

  Hello Smart Sheet-ers, I am fairly new to SmartSheet so excuse me if this is breathtakingly simple. I need to create a report of the following in dashboard. I assume from using Sheet Summary. It needs…

  

  Answered

  Smartsheet Basics

  141

  Apr 14, 2021

  1

• Simple RAG status

  Hi all, I am looking to create a RAG status, based on start date of a task. Rules would be: If start date is over a week away, status is GREEN If it's within one week of the start date is YELLOW If st…

  

  Answered ✓

  functionality

  Project Management

  Formulas and Functions

  2613

  Apr 8, 2021

  12