Formula Returning Null/Blank

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

Preparation

Accepted answers

DouTrina

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!

All comments

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.

Workflow.JPG

DouTrina

Here's a sample of the data as well

Sample Data.JPG

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

AkimasaKajitani 382

mbarone 337

Hollingsworth 335

LanisC 335