ContributionsMost RecentMost LikesSolutionsIf statement applying logic across the full column when it finds a true value Hi everyone, I have an IF statement that I would like to use to swap out a column for another column when a condition is met. The goal is to have this formula evaluate the condition for each row. For some reason, when just one record in the table meets the condition, the entire list of records is getting changed and not just the individual record. Anyone know why this could be? Here is my formula: If(IsNull([RecordID (Official) - Country_CCC_Pts]),[RecordID (Official) - Total_Points],[RecordID (Official) - Country_CCC_Pts]) Essentially all this formula is doing is saying if RecordID (Official - Country_CCC_Pts is null, then use the total points column. Else use the Country_CCC_Pts column Again, I need this to only apply to the records that meet the condition, not the entire column all at once ------------------------------ Spencer Chaffee ------------------------------Re: Field Formula helpSorry about that. It looked bigger when I pasted. Here is the formula: IF(and([fy22 mkt share chg vs ya]>=-4,[fy22 mkt share change vs ya]<=4), [fy22 mkt share chg vs ya]*[weight],([fy22 mkt share chg vs ya]*[weight]/2)) ------------------------------ Spencer Chaffee ------------------------------ Field Formula helpHey there, I am looking for some help in turning this excel based formula into something quickbase can handle. It is pretty disappointing that Quickbase does not allow AND/OR operators in your syntax. I am essentially looking to have my formula multiply the user's inputted share change and if it falls between -4 and 4, multiply that input by the weight I have assigned in another column. If the user's input falls outside of the -4 and 4 range, I want to multiply their input by the weight but then divide by 2. I have tried using the CASE formula but for some reason it won't let me use > or = signs. Is there any way around this that I am missing? Thanks, Spencer ------------------------------ Spencer Chaffee ------------------------------