Display Date based on certain condition

[Anonymous]

I am working on updating a title block's revision block and I ran into an issue. The end goal is to have the "Date" column update automatically based on the plot date. Currently, I have 6 columns (Rev, Date, Remarks, By, CHK, APPV). Each column (with the exception of the Date column) is set up to using attributes with a field referencing a lookup table. I am trying to come up with a way to have the date column automatically update if the row is being

used. If not, I need it to remain blank. See below for an illustration. I have also attached the block file. As you can see from the photo, my initial thought was to use the fields "PlotDate" feature. However, it would print the date in each row of the of the Date column. I only want the date to be shown if the row is being used. I hope I explained this sufficiently.  

[Anonymous]

I'm not sure if I did a good job explaining the problem in the initial post. I will try again. Looking at the picture, the revision block shows the REV column, Date column, Remark Column, etc. 

Example: Drawing plotted on 12/21/17 would show REV A in the REV column and the plot date (12/21/17) in the Date column. Now if a change is made to the drawing the next day, the second Row of the REV column would be REV B and a plot date (12/22/17) in the Date column.

My approach was to add a "PlotDate" field in the date column, however, this approach doesn't work based on a couple scenarios I can think of.

1. If the REV B cell is empty (i.e. a B rev hasn't been created yet), a date would still be generated in the date column corresponding to REV B. I would want that cell to be empty. 
2. If REV A and REV B were created on different dates, the corresponding dates should be different. It seems like the PlotDate field changes all of the dates to be the same in the "Date" column of my block. Ultimately, I just need the dates that correspond to the REVs to be independent of each other. 

[Libbya]

I do not know of a way to do what you are asking.  As you found, all of the plot date fields will update at the same time to the same date.  

For my revisions block I use sheet set custom properties for the revisions dates.  Then I use fields that reference those custom properties on a per project basis.  That way, I can change the one custom sheet set property to the next revision date and all sheets that have the revision date displayed will show the correct/same date for that revision.