How can I use a colourization formula to highlight record(show only last added record only) based on date

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Photo of raghav reddy

raghav reddy

  • 192 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,658 Points 10k badge 2x thumb
Hi Raghav,

Are these records related to another table by chance? Are they possibly the child of a parent table? If so you could create a summary field that summarizes up the Max Record ID related to each parent record then pass it back to the child record as a lookup field, then set up a colorization formula to highlight that record in a certain color when its Record ID is equal to the Max Related Record ID. I hope this suggestion is helpful Raghav.