If Formula

Samuel Dowdy Jr.
Samuel Dowdy Jr. ✭✭✭✭✭✭
edited 11/15/24 in Formulas and Functions

=IF([Work Performed Total]@row / [Employee Count]@row * 12 = 0, [Revenue Projection]@row / [Employee Count]@row * 12)

Why is it if the work performed cell is greater than 0 then the answer is blank? I want it to use revenue projection as the normal answer until work performed numbers start getting entered

Best Answer

  • Georgie
    Georgie Employee
    Answer ✓

    Hi @Samuel Dowdy Jr.,

    It sounds like if the “Work Performed Total” is 0, you want the formula to calculate [Revenue Projection]@row / [Employee Count]@row * 12, and if the “Work Performed Total” is greater than 0, you want the formula to calculate [Work Performed Total]@row / [Employee Count]@row * 12.

    If that’s correct, try this:

    • =IF([Work Performed Total]@row = 0, [Revenue Projection]@row / [Employee Count]@row * 12, IF([Work Performed Total]@row > 0, [Work Performed Total]@row / [Employee Count]@row * 12))

    Does that work for you?

    Georgie

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Answers

  • Jennifer Kurtz
    Jennifer Kurtz ✭✭✭✭✭✭

    Good morning!

    It looks like your If statement is looking for a value of 0

    [Work Performed Total]@row / [Employee Count]@row * 12 = 0

    and if that's true it will return the calculation

    [Revenue Projection]@row / [Employee Count]@row * 12

    Perhaps you intended your condition statement to read >0?

  • kowal
    kowal Overachievers Alumni

    hi @Samuel Dowdy Jr.

    the proper structure of the if function is:

    if (logical_expression, value_if_true, value_if_false)

    I can see you formula you have only one comma so it means that if the condition is false it will be blank.

    Hope this helps.

    Tomasz Kowalski

    The Real Smartsheet Enthusiast

    Is there anything else we can help you with? - book your time!

    MASA Consult - Your Aligned Smartsheet Partner

    Find us on LinkedIn!

  • Samuel Dowdy Jr.
    Samuel Dowdy Jr. ✭✭✭✭✭✭

    Yes, I need it to read if true. Can you help me write it? Basically if the worked performed is 0 then I need it to calculate the other formula. But if its greater than 0 then it need to calculate the first formula

  • Georgie
    Georgie Employee
    Answer ✓

    Hi @Samuel Dowdy Jr.,

    It sounds like if the “Work Performed Total” is 0, you want the formula to calculate [Revenue Projection]@row / [Employee Count]@row * 12, and if the “Work Performed Total” is greater than 0, you want the formula to calculate [Work Performed Total]@row / [Employee Count]@row * 12.

    If that’s correct, try this:

    • =IF([Work Performed Total]@row = 0, [Revenue Projection]@row / [Employee Count]@row * 12, IF([Work Performed Total]@row > 0, [Work Performed Total]@row / [Employee Count]@row * 12))

    Does that work for you?

    Georgie

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • Itai Perez
    Itai Perez ✭✭✭✭✭✭

    Hi @Samuel Dowdy Jr.

    =IF([Work Performed Total]@row=0,[Work Performed Total]@row / [Employee Count]@row * 12, [Revenue Projection]@row / [Employee Count]@row * 12)

    I think this is what you are looking for. Like @kowal said, you were missing an IF false statement.

    Let me know if it works.

    Itai Perez

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

  • kowal
    kowal Overachievers Alumni

    hi @Samuel Dowdy Jr. sorry for late response but as I was not tagged I did not get the notification.

    Is your problem already solved?

    Tomasz Kowalski

    The Real Smartsheet Enthusiast

    Is there anything else we can help you with? - book your time!

    MASA Consult - Your Aligned Smartsheet Partner

    Find us on LinkedIn!

  • Samuel Dowdy Jr.
    Samuel Dowdy Jr. ✭✭✭✭✭✭

    @Georgie answered my question. Thank you so much everyone.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!