Exported report fields with 'No Value' should be left blank, they shouldn't state 'No Value'

HubSpot Ideas
1

Exported reports use to have blank cells upon exporting if there was no data for that value. Now they explicitly state ‘No Value’ which prevents easy analysis of numeric data. Please just leave these fields blank (nearly every system you ever export data from leaves fields blank, otherwise it looks like someone literally entered ‘No Value’ into your database and that is not the case).

2

Yes please, if the cells don’t have a value, leave it as blank so we can have formulas running for this.

3

Need to have the option for it to be blank!

4

I second the motion. Please give us this option.

5

+1. Please do not insert a “(No value)” value onscreen and in exports if there’s no value in a property.

6

+1 Please do not insert a “(No value)” value onscreen and in exports if there’s no value in a property.

7

Why did someone think it is better to insert data into a Blank field??? How is that better? Did that help one person?

Please rethink this. If a field is blank… leave it blank.

Or someone please tell me there is a work around for this.

Very much appreciate if there is a solution. We are on Enterprise and really don’t want to have to remove all these fields that are blank.

Thanks

8

Yes, please. This is so annoying to clean.

9

Just adding my 2 cents that yes…blank fields should be left blank…

For those using google sheets, pop your raw data into 1 tab and you can then use this formula in a 2nd tab to pull the data dropping the (No value)

=arrayformula(substitute(QUERY({Insert your range},"select *",1),"(No value)",""))

10

I would like this, too. My exported report is full of cells with ‘(No Value)’ I have to edit it before I can send on internally.

11

For the love of God Hubspot. Go back to blank

12

Agreed, this would be very helpful for us!

13

I have a million workarounds for Hubspots various quirks, making this program feel more and more daunting each time I use it. It would really be nice to have 1 less workaround for this simple ask. Values in blank cells is just absurd

14

Please leave it blank! This would be a huge help when it comes to reporting and clean up

15

“No Value” is a value…come on Hubspot.

16

BTW anyone following this channel I found a workaround. If you use
calculated fields, you can calculate IF([field name]=“null”,“”,[fieldname).
There is a limit to how many calculated fields you can use in a report
however, but it does help clean things up just a LITTLE bit. Preferable if
hubspot can fix this. To echo BBellon, no value is a value!