I am struggling with my IF formula if anyone could please help

edited 02/28/24 in Formulas and Functions

So, I'm looking to essentially trigger a value if a certain box is checked (indicating amount due was paid) to then transfer that due amount into the paid amount column. I'm struggling due to my limited knowledge, but the formula I've been working on is =IF(checked[Lift Paid@row6], =[Lift Amount Due]@row6).

Is it an issue that I'm referring to the column name as what I named it vs. "Column C"? Should I not be identifying the row number? Ideally this would become a column formula, not just in this row I'm testing it out on.

Thank you in advance!

Best Answer

  • Ric T
    Ric T ✭✭✭✭✭✭
    Answer ✓

    Hi @Madisen,

    Good attempt, I've attached a screenshot below that may be helpful.

    Column formula above: =IF([Lift Paid?]@row = 1, [Lift Amount Due]@row, "")

    You'll just need to modify the formula to fit the name of your columns :)




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!