Can IF Function return the value of another field if True?

[Neil1 (Neil Taylor)]

I’m trying to create an IF Formula that returns the value of another field. I tried the following but doesn’t work. Have I just got the syntax wrong or is Monday not capable of this ? Thanks

IF({Next Action / Status}=“TESTED”,Total Hours)

Where Total Hours is a numerical field. Thanks

[mark.anley (Green Llamas Consulting)]

Hi @Neil1 - yes it is possible, you just need to ensure the column you would like to show Total Hours is in braces: IF({Next Action / Status}=“TESTED”, {Total Hours})

You may want to put an Else clause in there is well to display something when Status <>
TESTED".

Thanks,
Mark

monday.com + Green Llamas