Restricting Input Based on Conditional Formatting in Pigment Metrics

Hello Pigment Community,

I hope you're all doing well!

I’ve created a table with the following metrics:

1. Month
2. Amount
3. Blended Interest

(Please refer to the attached screenshot for reference.)

Currently, I have a checker metric set up for conditional formatting, which highlights a month in red if it is greater than the closing period.

Here’s what I’m trying to achieve:

• If a month entered is greater than the closing period, I want the Amount and Blended Interest metrics to become non-editable so users cannot input data in these fields.
• If a month entered is less than or equal to the closing period, users should be able to input data as usual in these metrics.

Could anyone guide me on how to set this up in Pigment? Your assistance would be greatly appreciated!

Thanks in advance!
 

4o