Quick Auto Pop-Up Form As Part of an Automation
We have a sheet where all our RFQ's are entered.
I have created an automation where as soon as the Status of the RFQ is changed to Sent it automatically copies the sheet to a Quote Register /Pipeline.
I wondered if it was possible that as part of the automation, when the status is changed a quick form pops-up where the user who has changed it to sent can fill in things like the Sale Value etc?
Would be very grateful for any help.
Thanks
Answers
-
Do you have the dynamic view add-on? That would be best in this situation. You can have the field you want filled out on status change also required, or you can have it show up after they change the status (but wouldn't be able to require it for a subsequent save)
The other way I try to enforce process is to use conditional formatting to turn the cell or row bright Yellow when you have another field that requires data entry. You could set conditional formatting to turn the row bright yellow, and the cell(s) you want filled out bright red when the status value is set to "Sent it", but the Sales value column is blank.
-
Thanks for the response - just not sure what the dynamic view add-on is?
Cheers
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives