Forum Discussion

Byking23's avatar
Byking23
Copper Contributor
Nov 16, 2023

Calculated column w/ IF condition not showing the false value

Good day everyone,   I'm trying to create a calculated money column which looks another column to find and specific text and if is TRUE is gonna be the value of another money column already created...
microsoft lists
SharePoint Online
Kelly_Edinger's avatar
Kelly_Edinger
MCT
Nov 16, 2023

Hi Byking23 - I just got this to work in my dev environment:

 

=IF(Category="NCF",[Amount],"$0.00")

 

 

 

 

  • Byking23's avatar
    Byking23
    Copper Contributor
    Nov 16, 2023
    Hi Kelly,

    The thing here is that is a text field and it doesn't have the specific text i compared. That's why i place the fuction FIND because the text has B1100005486 and im tryna find the B11 in the entire text as the fuction CONTAINS. If the item contains B11 in this field it must have the value of a column im gonna set, if no $0.00.

    Got it?

Resources