IF formula question with an empty value in column

lgomezsgre

Hello - I am trying to create a formula where if the cell is not empty (e.g. WBS element) then would like to bring its value to a new column called 'WBES' (attached workflow). The WBS element is alphanumeric (ex. US/1995). I cannot seem to find a formula that will work. Please let me know if you can assist! Thanks!!

IF formula.PNG

BenMoss

In order to create a column you should look to use the formula tool; your statement would look something like...

IF [PC Category] = "Project CC Expense" AND !ISEMPTY([Order]) THEN RIGHT([WBS Short],7)

//Check to see if the PC Category field equals "Project CC Expense" and the Order fields is not empty, if so return the right 7 digits of the WBS Short field.

ELSEIF [PC Category] = "Project CC Expense" AND !ISEMPTY([WBS Element]) THEN RIGHT([WBS Element],7)

//If that check fials, then check to see if the PC Category equals "Project CC Expense" and the WBS Elemnt field is not empty, if so return the right 7 digits of the WBS Element field

ELSE NULL()

//If both tests are false then return the value NULL

ENDIF