I want to create a single button, using ENUM,...

[Jason_Denniston]

I want to create a single button, using ENUM, and use the value of that button (if pressed) to show a different field.

The value is a string.

How do I write that in the Show_If box of the field I want to show?

[SantiagoU]

Try . --> Show_IF: [The column with the ENUM]=The value in the button.

[Jason_Denniston]

This is what I used and it’s not pulling up.

That’s actually what I had in there before.

[Jason_Denniston]

Here’s the button…

[Aleksi_Alkio]

ISNOTBLANK([Farmer Mac])

[Jason_Denniston]

that worked, thanks Aleksi!

[Jason_Denniston]

@Aleksi_Alkio I’ve got another equation: IF (ISNOTBLANK([Farmer Mac]),[Interest Rate]=[COF]+[Spread], [Interest Rate]=[COF]+[Farmer Mac Spread])

but, I keep getting this error: The expression is valid but its result type ‘Yes/No’ is not compatible with the expected type ‘Percent’

How would I write this so I can see if a field is true, to set the value of a field one way - and, if false, set the field another value?

[Aleksi_Alkio]

Without knowing your structure you could try… IF(ISNOTBLANK([Farmer Mac]),[COF]+[Spread],[COF]+[Farmer Mac Spread])