"Aged Report" in Smartsheet
Answers
-
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?
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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!
-
@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).
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives