need_help
asked on
How can I flag a modified value? (v4.6)
I hope this is easy...
I have a document containing 4 columns. The first and third columns contain numbers. In the second and fourth columns I would like to have a "*" appear if a number to the left changes (the criteria for displaying the "*" would be if the number to the left changes anytime after the day the document was created).
How would I do this? Do I need a separate field with a formula to display the "*" in each cell in my 2nd and 4th columns? Or does notes have some type of 'offset' method I can use in my 1st and 3rd columns to have the "*" appear in the 2nd and 4th columns. I really don't want to define any fields in my 2nd and 4th columns since there are many cells involved!
Many thanks in advance!
need_help
I have a document containing 4 columns. The first and third columns contain numbers. In the second and fourth columns I would like to have a "*" appear if a number to the left changes (the criteria for displaying the "*" would be if the number to the left changes anytime after the day the document was created).
How would I do this? Do I need a separate field with a formula to display the "*" in each cell in my 2nd and 4th columns? Or does notes have some type of 'offset' method I can use in my 1st and 3rd columns to have the "*" appear in the 2nd and 4th columns. I really don't want to define any fields in my 2nd and 4th columns since there are many cells involved!
Many thanks in advance!
need_help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.