MAX COLLECT with IF?

Options
LJK
LJK ✭✭
edited 06/06/22 in Formulas and Functions

Hi everyone

I would like to feed a graph as follows:


Please show me the last 5 days in the yellow assigned cells in sequence of date, that had a value in column 1, so I can display the value in a graph.


Any suggestions?

Tags:

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @LJK

    Are you building your graph off of a report or a sheet? If you're using a sheet, you should build a report from that sheet and in the filters of the report you can specify to only include results with greater than 0 in any specific column.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!