"Aged Report" in Smartsheet

Options
System
System Employee Admin
This discussion was created from comments split from: Looking for formula.

Answers

  • Beronica Muller
    Beronica Muller ✭✭✭✭
    Options

    Hello,


    I am new to Smartsheet and trying to create an aged report in Smartsheet. The criteria is to create a report based on inquiries pending from submission date and is at a standstill.  Could you assist with what I am doing wrong?

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Beronica Muller

    Could you provide screen captures of your Report Builder open, and a screen capture of the sheet you're working with? (Please block out any sensitive data).


    Here's an example of what my criteria looks like in a similar report, which is looking for all the rows that are "In Progress" and where the date column has a date in the past:


    Notice that I'm using the What? criteria for the Status, and the When? criteria for the date column.

    This link has some videos you may find helpful: https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

  • Beronica Muller
    Beronica Muller ✭✭✭✭
    Options

    Sure, please see below.  I am actually trying to create a formula that would tell me the number of days that the inquiries have been pending. Ugghhh, I am soo lost right now!

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    @Beronica Muller - I don't think the upload of the image worked... could you try again?

    If you're looking to count Working Days, you could use the function NETWORKDAYS (see here).

    This calculation would need to be done in a sheet, not a Report though. A report can gather together the different rows across many sheets that meet certain criteria, but formulas within sheets create calculations (based on criteria, if needed).