AnsweredAssumed Answered

Status

Question asked by thong127 on Jan 22, 2015
Latest reply on Jan 23, 2015 by thong127

Title

Status

Post

Hello Everyone,

Can you please share your expertise in building my status field calculation.

I have 4 fields

1. Expiry Date

2. Retest Date

3. Remarks ( Check box, Values are ( Quarantined, Released, Expired, Rejected, USed, R & D and Retest, Close to expiry)

4. Status 

I want that in my status field will show “Expired” if a certain material reached their Expiry date or Retest Date otherwise “Active”  and when the Remarks is “Expired”, “Rejected” or “Used” it will show “Expired”

Thank you so much in advance.

Outcomes