Forum Discussion
Replace cell date when using a tick box
Please see attachment for screen shots and question I would need guidance on formula when box ticked the 2nd review date replaces review date column whilst still allowing 2nd review date to up ...
Lori786 -While it may not be the most elegant solution, I'm hopeful it will be effective. I recommend duplicating your original list to prevent any issues with formula circular references.
Please check out this file and let me know.
Ok i was thinking along those lines I will try this