Forum Discussion
Status based on multiple date columns
brianheath
You compared the assessment date with the minimum date and link with ||, this is of course all rows are matched. Try replace Or(||) with And(&&).
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Thanks Paul.. I did try your solution and although it logically makes sense when I read up on your thoughts... for some reason it did not work unless I kept ||.. I am not sure if others can help me understand why?
I have worked the issue further and although still not as elegant as I would like, now think the original solution wa a bit of overkill for my needs. After messing with the original code and stripping down what I felt I did not need, the code below seems to be where I have got to currently, but does not account for empty cells of previous proceses; something I need to account for.
Any other thoughts on how to make it more elegent? It would be good if it picks up the furtherest completed cell and reports that as the status to overcome poor data entry discupline, but have no idea where to start with that