Filling in blank rows on an output with a 'n/a'

[Sjkitts]

Hello, 

I am currently trying to figure out a formula that will but a 'n/a' in the rows that don't get filled in once the workflow is ran. I looked at a few discussions and tried the below code. It worked but it got rid of the name and put 'false' in there instead of keeping the name? What do I need to put at the end to keep the names there if they come up and have the rest of the blanks read 'n/a'? Thanks!

IF (IsEmpty([Product Owner])) THEN "n/a" ELSE 'false' ENDIF

Please see the before and after pictures for details. 

[IraWatt · Accepted solution]

Hey @Sjkitts,

To put the name in you will need to reference the name column currently your just putting in the string 'false'. I think you want something like this:

IF (IsEmpty([Product Owner])) THEN "n/a" ELSE [Product Owner] ENDIF

[Sjkitts]

@IraWatt thank you so much!! Much appreciated!

[IraWatt]

No worries @Sjkitts ! any time :D