Ignore blank Cells

Steven Griffiths

Hi I'm trying to get the following formula to ignore blank cells =INDEX(([1]:[1]), MATCH(MAX(Created:Created), Created:Created, 0)) Can't quite get it to work.

Stefan

Hi @Steven Griffiths,

did you try ISBLANK ?

https://help.smartsheet.com/function/isblank

Hope this helps

Stefan

Steven Griffiths

Hi Stefan,

I've tried several iteration of the isblank function within the formula, sadly I can't get the required result.

Basically I have several forms each populating multiple columns within a sheet. I then want to summarise each of these these columns with the most recent 'Not Blank' entry so I can display them as a metric on a dashboard.

Do you have any tips on how to insert an 'ISBLANK' command to achieve this?

Stefan

Hi @Steven Griffiths,

your formula

=INDEX(([1]:[1]), MATCH(MAX(Created:Created), Created:Created, 0))

has needed brackets in "([1]:[1])" ;-)

But besides this I see no problem with your formula as long as it is placed in a date column.

Can you provide more detail about why you want it to ignore blank cells?

Greetings

Stefan

Steven Griffiths

Hi @Stefan

I'm trying to display the most recent form entries from a sheet which is populated by multiple forms. Each form populates different columns, this means that when a form entry creates a new row not all columns are populated. I would like the summaries to only show only the most recent entries which are not blank.

Stefan

Hi @Steven Griffiths,

"summaries" = sheet summary report in the side panel?

So every form entry creates a new row where only some columns are filled with data. Do you want to show only the data of the latest row addition? Basically you want cell data of type XYZ where date is youngest, right?

Or do you want to summarise the latest entries for multiple type (from every type of form) of data?

Greetings

Stefan