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
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!