Forum Discussion

VOx15's avatar
VOx15
Icon for Helper I rankHelper I
5 years ago
Solved

Date from Previous Row into new column

Hello all,  I have been trying to figure this out for a while and would appreciate any insight.    My current data only has the Entry Date field and I am trying to create a new ExitDate field by g...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    My formula returns the correct result.  See the screenshot

VOx15's avatar
VOx15
Icon for Helper I rankHelper I
5 years ago

Ashish_Mathur  thank you that helped for most row.

 

But what about the rows where the entry date is the same for two consecutive queues. With the formula you provided if the entry data is the same for two queue the exit date is blank...how can i adjust the formula?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Please share an example and let me know the row in which my formula is not working.  Share data here in a format that i can paste in an MS Excel file - do not paste a picture.