Forum Discussion
CTrail09
Jun 27, 2024Copper Contributor
How to update date depending on cell text
We have a requirement to forecast when a supplier is next due for an audit. In column A we have the classification, A Critical, B Moderate, C Non-Critical and D Trivial. In column B we have the dat...
Martin_Angosto
Jun 27, 2024Iron Contributor
Hi, please see attached document with proposed formulation. Do not forget to format cells in column C as dates.