Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

RAG Formulas

Faye Rhodes
edited 12/09/19 in Archived 2017 Posts

I have a project sheet and I have used formulas to create metrics.

I have a RAG column and want  to simply create four metrics:

I am struggling to find the correct formula to simply count the following:

  • RAG Status Green
  • RAG Status Blue
  • RAG Status Amber
  • RAG Status Red

Many Thanks





This discussion has been closed.