Discussions

 View Only

If statement applying logic across the full column when it finds a true value

  • 1.  If statement applying logic across the full column when it finds a true value

    Posted 18 days ago
    Edited by Spencer Chaffee 18 days ago
    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
    ------------------------------