Using value from a formula column in a separate formula

Greetings,

Goal: I am looking to create a formula column that uses the values listed in a different formula column in this this new column formula.

Example: IF({this formula columns value}>=“any digit”,“Pass”, IF({this formula columns value}<=“any digit”,“Fail”))

Is this possible and / or can you even pull final values from formula columns?

Cheers!

@JHarlowe

Yes, you can absolutely do that.

Give it a shot!

Jim - Subscribe to The Monday Man
Watch Our Latest Video: The Power of the Right-Click

Thanks a ton for the quick reply.

I did give it a shot and got the deaded illegal formula exclamation.

IF({Need 3 to Pass}>=“3”,“Pass”, IF({Need 3 to Pass}<=“-3”,“Fail”))

I used the column picker to be sure the text matched.

Could the real numbers be the snag?

@JHarlowe

Hovering over the exclamation point will give you more information as to the reason for the error.

Try this:

IF({Need 3 to Pass} >= 3, "Pass", IF({Need 3 to Pass} <= -3, "Fail", ""))

Jim - Subscribe to The Monday Man
Watch Our Latest Video: The Power of the Right-Click

1 Like

It worked, must have been the syntax and “”

@JCorrell you truly are the monday man!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.