Returning a Blank in a IF THEN ELSE statement involving a list

DanielU · 2024-01-03T18:03:26+00:00

There was an error rendering this rich post.

DanielU

Hi,

I am looking for a way to return a blank for an IF THEN ELSE formula involving a list:

IF x AND y AND z

THEN Values to lookup[LOOKUP: Mapping]

ELSE Return a Blank

The Return a Blank part is what I am having an issue with. I can't use 0 or "Null" as the format of the line item is a list, is there a way to return a blank without adding a list item?

Any assistance would be appreciated, let me know if you have any questions 🙂

Many thanks,

Daniel

Accepted answers

rob_marshall

@DanielU

Have you tried using BLANK?

IF x AND y AND z

THEN Values to lookup[LOOKUP: Mapping]

ELSE BLANK

All comments

andrewtye

Hi @DanielU

Unless am misunderstanding you all you need do is to do is put BLANK at the end and you'll get an empty cell - presumably what you're after?

Tiffany.Rice

Daniel, you are so close you can taste it! "BLANK" is the syntax to return a null value for a list formatted line item.

So in your example that would be:

IF x AND y AND z

THEN Values to lookup[LOOKUP: Mapping]

ELSE BLANK

rob_marshall

@DanielU

Have you tried using BLANK?

IF x AND y AND z

THEN Values to lookup[LOOKUP: Mapping]

ELSE BLANK

DanielU

Thanks all, this has worked!

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…