Action Button to Update Value Based on Cell Reference

Is there a way to create an Action button that updates a value based on a cell reference or named reference?

So instead of hard coding a value in the ‘with these values’ field, refer to a cell or named reference on the same sheet e.g. cell F13 or named reference ‘Color’?


Updating a field value in this sheet to another sheet is not supported, however, you could try update value on another sheet to update the same entry on the same sheet, which can update based on field value but not a hard string.