I have a column whose value is the result of a formula but I only want it to be set on selected (manually, by me) rows.
So, basically, I want a trigger formula that is triggered by me clicking on the field. Is there any way of doing this?
Add a toggle column and set the trigger formula for your field on change to the toggle column.
Set the toggle column’s trigger formula with a sleep timer and return false if you want to untoggle the toggle.
The other option would be to set the toggle for the rows you select, and then in your formula column add an if $toggle_column (toggled=true, untoggled=false) and in the true block then add your formula.