Request tracker template: Close requests
Hello,
I'm using a Smartsheet template for tracking request, with sheets + forms, metrics, report & dashboard displaying open requests.
However I can't seem to find where/how to close requests so that once they're no longer displayed on the dashboard.
Thank you in advance for your help!
Cheers,
Akim
Answers
-
I hope you're well and safe!
Which template are you using?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Doing well thanks, I hope you as well.
I'm using this template: https://app.smartsheet.com/b/publish?EQBCT=99e6d3744ec7420eb9beb58bcb58d48c
Thanks for the quick response,
Cheers,
Akim
-
Happy to help!
Glad to hear you're doing well. I'm as well!
It shouldn't show in the Dashboard as open when you've changed the Status to Closed in the Request tracker sheet.
Did that work?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Well, it does show them; I renamed the status field as implementation status, and renamed closed to done.
I reversed the change (from done to closed) to no avail, the requests still appear as open in the dashboard.
I guess it's a matter of adding a condition or formula, but where am I supposed to put it; In the Open report or in the Metrics sheet?
Thanks in advance,
Cheers,
Akim
-
You're more than welcome!
Strange!
Did you only change it in the sheet?
I'd be happy to take a quick look.
Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives