Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Find Record with Highest Value in Formula Column

Topic Labels: Automations
865 2
Showing results for 
Search instead for 
Did you mean: 


I am trying to automate posting a random record to twitter.
I have an automation set up already that whenever i check a box on the record it will send out the tweet - this is working fine. I want to automate that step though so i made a column with “random” values.

Now I want to set an automation that each day, it finds a record with the highest value from that “random” value column and updated the record to check the box that will then trigger the twitter automation.

How can I set up an automation to find the highest value and then update that record by checking the box?


2 Replies 2

A good example of a similar problem solved here: How to get the highest value out of a column - #2 by W_Vann_Hall

it’s a bit wonky, as AT doesn’t work like a regular spreadsheet, but the TLDR version is that by creating a linked record on all the tweet fields, you can use a MAX rollup to identify where MAX=Your Random Column and then automate tweeting it out.

Hi @Kevyn_Levine and welcome to the community!

My first tought: