John Steel
New member
- Joined
- Aug 16, 2014
- Messages
- 7
- Reaction score
- 0
- Points
- 0
I'm trying to assign an automatic sequential control number based on another field. I want to begin with "001" and continue sequentially. However the worksheet I'm using will have multiple rows - some with bids won in which I want to assign the next number in the sequence for the control # and some with bids lost in which I want to leave blank and not assign a control number.
I'd also like the control number to end with the value in another field (the year) to look like this in the end - "001-2014". I know I can accomplish that with a custom format.
Here's what my worksheet looks like. I don't know why the image is so small. If anyone knows how to make it larger...
Thanks
I'd also like the control number to end with the value in another field (the year) to look like this in the end - "001-2014". I know I can accomplish that with a custom format.
Here's what my worksheet looks like. I don't know why the image is so small. If anyone knows how to make it larger...
Thanks