Formula Returning Null/Blank

[DouTrina]

Hi, 

I am trying to get the below formula to return either "1 Deployment" or the data form the Review 1 column and it is returning blank where "1 Deployment" should be.  Any ideas?

IF [Review 1] = "Last record USW" && [record] = "1"
THEN "1 Deployment"
ELSE [Review 1] ENDIF

[LordNeilLord]

Hi,

Are you able to share your workflow or a sample of your data?

Your formula looks correct

[DouTrina]

Thank you so much for any help you can provide. 

[DouTrina]

Here's a sample of the data as well

[LordNeilLord]

Hey,

Everything looks OK, I tested your formula and it gave the correct results.

The only thing I can think of (without having your actual data to play with) is that you have an extra space after "Last Record USW".....to quickly test this if you put TRIM([Review 1]) in your formula it will give you the results:

If trim([Review 1]) = "Last record USW" && [record] = 1 Then "1 Deployment"
Else [Review 1] Endif

If that still doesn't work, please attach some data (anonymised of course) and I can experiment more.

[DouTrina · Accepted solution]

Thanks for the help LordNeilLord!

I found that the "" around the 1 was stopping the formula from reading it as it was trying to read it as a string.  

Problem solved!