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!
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?
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
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.