If Function

Shadany ✭✭
edited 10/05/22 in Formulas and Functions

Hello, I'm trying to use the IF function, if column "Type Of Request" is "SCRAP" to automatically insert a negative sign into the "Value" column in front of the number. If it's something other than "SCRAP" then to leave the number alone.

Maybe I'm just overthinking it a little too much.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!