Why are most of my months showing up "N/A" when I know there is data?

edited 11/16/23 in Formulas and Functions

Why are my metrics showing N/A on mostly all of my months for Long Term Project TCC? Please see formula below

Populates only one month:


  • MichaelTCA
    MichaelTCA ✭✭✭✭✭✭

    Hello @NBKD

    You'll have to do some detective work.

    Make sure the month and year are actual values and not 0. Unless you default to a month of 0 being used as a trigger or reference for another analysis.

    The columns being referenced, the cells being evaluated, and May83 need to be all date columns.

    I would remove all the IFERROR functions in the middle and keep the one surrounding the entire function.

    If you have a Month of 0 and Year of 0, there's no reason to default to an error value that causes another error when an error has already occurred.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!