Showing Continuous Trend even with Gap Data

eLIZo
eLIZo โœญโœญโœญโœญ
edited 07/10/23 in Formulas and Functions
image.png

For context, I am trying to show month by month trend, but there are some months where there are no data.

Right now, my trend column (#3) compares the data(Column #1) in the current row to the row right below it. For rows where the row below has no data, is there a formula to get it to skip the empty row and compare it to the next row with data?

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome Community Champion
    Answer โœ“

    NOT(@cell = "Something")

    and

    @cell <> "Something"

    are interchangeable depending on user preference. I tend to avoid the NOT function when I can because it is just one more set of parenthesis cluttering things up.


    The second Row column is more out of habit for me because it will maintain that numerical order from top to bottom regardless of sorting and is not affected by adding or deleting new rows anywhere in the sheet. Using just the auto-number column, those numbers are locked to that row, so they can get pretty out of order if you end up sorting the sheet. It will also mean there could be a gap or gaps in numbers if rows were deleted, and they could also be out of order if new rows are added anywhere other than the same place (always at the top or always at the bottom).


    I am very frequently adjusting and tweaking, so I tend to use the auto-number as well as the text/number to ensure I always have that row number no matter what since it is typically one of the first things I build into any sheet.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!