Workflow Request for Blank Fields
Hi I'm looking for some advice on workflows. I have quite a large sheet to manage with several project managers. When a project is completed I would like a workflow to be sent to the PM if any of the mandatory fields are blank for the project close out.
I've done a Request Update as a test, included conditions for each of the columns required if they are blank and then attached the specific fields which I have under conditions. Is there a way that when an update request is sent that it only shows up which of these fields is blank? So that if I have 30 fields which are mandatory to complete, but the PM has completed 27 of them, then it just shows the missing 3 fields on the update request? I'm worried that they might miss something if there's 30 fields for them to scroll down through on the request to find the blanks they've missed.
Answers
-
I hope you're well and safe!
Yes, but you'd have to create a workflow for each scenario or maybe at least create one for each group.
Make sense?
Would that work/help?
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, Awesome, 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.
-
Thanks Andree but that sounds painful! 🤣 Think I'll go with a report instead but thanks for your help!
-
Haha! Yes, but at least possible! 🤣
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome 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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives