Dear XOR,

I work in a construction office and we submit transmittal to Consultant for approval.
And UNIFIER is a ONLINE PROJECT MANAGEMENT SOFTWARE. We submit transmittal online through UNIFIER not hard copy. So while uploading files UNIFIER gives a unique reference number like TRN-00276. And this reference number may be different for every submission. For example: it may be one for Y13 and another for AC13. It field should be updated manually after uploading the file to UNIFIER.

I have attached the LOG_3 file.
There in the cell W13 - which is the date of submission. I input the date in W13 but V13 did not get changed. This is the very problem.

When I get respond from CONSULTANT, I input the date in X13.

So if there is submission date only- the date of current status should be same as submission date. And there is also respond date the date of current status should be same as respond date. So which is latest date, that should be the date of current status. It has the problem only in 1st Submission field that is W13- others are working well.

Thank you very much again. I hope you will surely find a solution for me.

Attached Files

LOG_3.xlsx (140.7 KB, 9 views)