I am struggling with my IF formula if anyone could please help
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

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 :)
Cheers,
Ric
Answers

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 :)
Cheers,
Ric

Is there a way for me to then zero out the due amount? Or would that cause an unparseable equation because it would null it all?

Hi @Madisen,
When you say zero out the due amount, do you mean calculating the balance to be paid? For example, if the balance due was $100 but then there were multiple partial payments (e.g. 2 x $50, 4 x $25)?
If yes, I would create a new column (partial payment) on the right of the paid column (e.g. balance due), or use row and hierarchy's to manage that, more info from Smartsheet here https://help.smartsheet.com/learningtrack/level1getstarted/rowsandhierarchy
If not, could you give an example?
Cheers,
Ric
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!