I have a table called Pole_Movement_Master with a column [Sheet Number]. I am auto generating this number through an appformula. I only want the number to incement by one each day as opposed to each transaction.
Could somebody advise what I could add to my expression so that the Sheet Number is only incremented when today’s date changes?
Any help would be great, thank you.