How can I send to Monday when a dropdown field is empty on sheets and make it look only empty in Monday board?

How To
1

Hi,

I’m migrating data from Google Sheets to Monday.com

How can I send to Monday when a dropdown field is empty on sheets and make it look only empty in Monday board?

image

I already tried a couple of possibility to send it empty,

image
image

  • null and whitepace didnt work

image

  • Create labels if missing is active too

image

image

But I just cannot see an empty space like in the sheets in monday.

How to control this kind of empty space for Monday?

2

Hi @onurbolaca ,

It depends on how the API of Monday acts as well. I have no experience with using Monday, but can you try to use the {{ignore}} keyword instead and share your result?

Glenn - Callinetic

1 Like
3

Hi,

I tried with “ignore” too and it looks like this;

image

image
image1032×57 9.17 KB

I’m sure that only dropdown field is empty on my row and when dropdown field is filled, it is working.

That’s interesting. I already tried

null,
emptystring,
ignore,
“”,
" "

What would be the solution I wonder?

4

Hello @onurbolaca nice to meet you.

If you want to send a null value to a particular field, that field must support a null value. From what i know in Dropdown fields you can not set empty value from the interface of Monday. I think you need to contact Monday support for more information.

Don’t hesitate to contact us if you require further assistance.

//Vlad

2 Likes