Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,759
Community Members
 
Community Events
165
Community Groups

Creating a 'next review' date to turn into a RAG status

Hi there, I have created a page in Confluence, added a 'Page Properties Report macro' and inserted a /date option to create a future date for review. 

ReviewDate.PNG

This table is then reported onto a parent 'report' page that lists all my pages with their dates, owners, titles, status, last review etc. 

I wish for the 'new review' date to flag up red if the date passes.  This would allow me to see on the parent report page, quickly, at a glance the passed dates where no review took place.  Is this possible?

Please note: I already have a 'status' row but this is manual input, so I do not think this is the answer.

Status.PNG

I am not a programmer so would not understand any code.  If my idea is not possible, would Jira have to be the option? (which I do use, therefore, would be able to add this in, but am hoping Confluence has an alternative simple answer too).  

Thank you

2 answers

2 accepted

Hi @Stacey Ropiha ,

We can also suggest trying our app - Table Filter and Charts for Confluence.

You'll be able to wrap your Page Properties Report into our Table Toolbox macro and create a sequence Page Properties Report <- Table Transformer <- Table Filter.

With the help of the Table Transformer macro you'll be able to set statuses using conditions (compare your dates with "today", for example).

And with the help of the Table Filter macro you'll be able to filter your new statuses and show dates that overpassed "today" or are due soon.

Maybe this also can help.

Good morning Katerina, thank you for responding to my question and I will definitely like to take a look at your answer, it sounds like it would be a good option.

Thank you and have a good day, regards Stacey.

Hi Stacy,

As a workaround without coding: you could enter a task with add a date, like this:

Untitled.jpg

If the date is in the past, if will be displayed in red.

Hope that helps,
-Stefan

Stefan, thank you soooo much, that works!! So simple :) appreciate your reply, again thank you

You're welcome, @Stacey Ropiha.

While we're at it: If you are getting into Page Properties, make sure you also have a look at our app Orderly Databases, which is Page Properties on steroids: https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Announcing-Orderly-Replace-Confluence-Page-Properties-with/ba-p/1915196

...or watch the new video: https://www.youtube.com/watch?v=0rTJUkPhmWc

That said, it does have date fields, but doesn't support your use case yet. (But will do so soon, and will also be able to send notification emails)

Like Stacey Ropiha likes this

Excellent, thank you Stefan. I can show this to a few colleagues, it may be of interest to others as well.  Thank you!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

320 views 2 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you