Ignore blank Cells

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.

Answers

  • Stefan
    Stefan ✭✭✭✭✭✭

    Hi @Steven Griffiths,

    did you try ISBLANK ?


    Hope this helps

    Stefan

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

  • 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
    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

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

  • 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
    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

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!