So I’m aware that currently automations don’t trigger based on formulae:
How do automations work with formulaic columns?
Currently, the modified row trigger can only work with columns that are manually updated (via direct edits, button-generated edits or API edits). They do not work on value changes in formula based columns that are manually updated rather than columns that are populated by formulas. Stay tuned for updates!
But I’m not sure if there’s another way to automatically “press” a button? I’m trying to schedule content posts to various channels and this is the last step that I need to be able to completely move all social media posting out of services like Buffer and into Coda, but it’s leaving me stumped!
EDIT: One possible solution is if you can use Action Formula within a table cell, but it’s unclear from the docs whether this is possible?