IF Formula help

Hello,

I am looking to add a conditional if formula but not sure how to move forward and unsure if smartsheet has a capability.

Is it possible to check a column based on 3 other columns if not blank. and if so what do I have to write for the condition of columns not being blank. I got as far as selecting rows but unsure what to write next.

Please help. I appreciate your support.

Thanks!

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 06/29/21 Answer ✓

    Hi @Mital Patel 

    Hope you are fine, please try the following formula and convert it to a column format formula:

    =IFERROR(IF(COUNTM([C1]@row:[C3]@row) = 3, 1), "")


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!