IF Column B@row or Column C@row is more than 10, say yes

A Rose

A Rose ✭✭✭✭✭

07/02/20 in Formulas and Functions

How Can i write the above IF Column B@row or Column C@row is more than 10, say yes, so smartsheet understands?

Anyone, Please assist.

Thank you!

0 ·

Best Answer

Paul Newcome Community Champion

07/02/20 Answer ✓

Try this...
=IF(OR([Column B]@row > 10, [Column C]@row > 10), "Yes")

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
5 · Share on Facebook Share on Twitter

Answers

Paul Newcome Community Champion

07/02/20 Answer ✓

Try this...
=IF(OR([Column B]@row > 10, [Column C]@row > 10), "Yes")

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
5 · Share on Facebook Share on Twitter
A Rose ✭✭✭✭✭

07/02/20

That worked.
Thank you very much!!!

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

07/02/20

Happy to help! 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Conditional formatting for "where % complete is not equal to 1" is not working
I have a project plan where I'm trying to set conditional formatting where % Complete is not equal to 1 and Finish Date is in the past, to turn row Yellow. It is not working. Please advise.
Mass Remove Hyperlinks
Is there a quick way to mass remove hyperlinks within specific columns on a Smartsheet? I do not want to "clear content", just remove the hyperlinks.
Can you collate Ancestors based on another column condition?
Hi all, looking for some formula help. I would like to collate the names of my ancestors for a task in my "Stage" column, but only if the Hierarchy level of that parent or grandparent is >= 3. I have tried utilizing the Join(Ancestors(Task@row), " - ") and this returns all of the parent tasks. When I try to utilize an if…