Does the following calculation work?
if [Last Modified Days] < 30 then 'Green'
elseif [Last Modified Days] < 60 then 'Orange'
If not, would you be able to post the packaged workbook (twbx file)? Or a screenshot of the calculated field box, showing the error messages?
Hi Tracey... I made the calculation you gave as COLOUR UP and move it to Mark - Color, It colors the last column (Drop) not the last modified days column.
I can't bundle because I use a database.. I can't print screen because I think it's to big...
But it looks something like this
PMID Days Open Last Days Modified Drop
==== ======== ============== ===
123 50 150
444 10 5
345 35 31
Thanks for your help!!!!
Can you put the Last Modified Days calculation on the Text shelf, and the created calculation on the color shelf? If you want the header to appear, create a calculated field that is a string with the desired output and place it on the Columns shelf.
Hope this helps a bit!