Calculating Formula help


My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students


Best Answer

  • S-Jacob
    S-Jacob ✭✭✭
    edited 04/25/24 Answer ✓

    I think what you are asking for is this

    =if([Total number of Students]@row=0,[Number of Students]@row,[Total Number of Students]@row-[Number of Students]@row)

    Which is for columns A, B, and C
    If B is 0, return A, else return A - B


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!