Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Document Received | Priority | Status |
06 May 2016 | Medium | Closed |
07 April 2016 | High | Open |
07 April 2016 | High | Closed |
06 May 2016 | Medium | Open |
I want
1)if the priority is high and document received (current date- date received) is more than 4 months, status is open then it is coming on red
2)if the priority is medium and document received (current date- date received) is more than 10 months, status is open then it is coming on red
3) if the priority is high and status is closed then it is coming on green
4)if the priority is medium and status is closed then it is coming on green
Maybe this?
if(Status='Closed',green()
,if(Priority='High' and today() > addmonths([Document Received],4),red()
,if(Priority='Medium' and today() > addmonths([Document Recieved],10),red())))
if(Status = 'Closed',
green(),
if(Priority = 'High' and [Document Received] < AddMonths(Today(),-4) and Status = 'Open',
red(),
if(Priority = 'Medium' and [Document Received] < AddMonths(Today(),-10) and Status = 'Open',
red())))