5 Replies Latest reply on May 23, 2020 2:06 PM by Jonathan Drummey

    Multiple IF and ISNULL

    Nishesh Ved

      Hi Community


      I am trying to sort a formula but just unable to figure out the correct structure


      I have three fields and i have created a calculated field to test if any of this has a value it should populate the calculated field. I am also testing if there is a null in any of these fields, if they are null it can check for other fields to find the value.


      Can someone please help - i have got the below




      IF (ISNULL([Costelementfor supplier]))

      or (isnull([Vendor Sum Name]))

      OR (ISNULL([Summary Name]))


        [Summary Name] ELSE[Vendor Sum Name]