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)
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.