Column Value Until Another Column Triggers Change
Good afternoon,
We currently have our "BAC" column with this formula , =IFERROR(HTD@row / [% Comp.]@row, 0).
However, we need to be able to change it so that the "BAC" column will equal the "BAE" column until the "HTD" and "% Comp." columns have values entered into them.
Thank you in advance for your help!
Best Answer

I think you just need a nested IF statement. Something like:
=IF(OR([% Comp.]@row = 0, HTD@row = 0), BAE@row, IFERROR(HTD@row / [% Comp.]@row, 0))
The first IF and OR statement basically tell the formula to use BAE until both % complete and HTD are not 0. The second comma is the False of that statement (meaning % complete and HTD have something in them) and reverts to your original formula.
Answers

I think you just need a nested IF statement. Something like:
=IF(OR([% Comp.]@row = 0, HTD@row = 0), BAE@row, IFERROR(HTD@row / [% Comp.]@row, 0))
The first IF and OR statement basically tell the formula to use BAE until both % complete and HTD are not 0. The second comma is the False of that statement (meaning % complete and HTD have something in them) and reverts to your original formula.

That worked perfect. Thank you @David Tutwiler

Awesome!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!