Require a roll up $ value to be inserted into a Form
Scenario: our Form has 5 different product categories that our partners will add $ values for applicable product categories. Unfortunately, our partners will submit the form will all of the other information without inputting any values. Thus, internal team will need to reach back out to partners to resubmit.
It is possible that a job has all 5 product categories or only 1 so we don't want to require each field because it may not be applicable.
I would like to insert a formula that rolls up the total list and if the value is not > $0 it locks down the form. I don't think the "lock down" is an option.
My best current solution would be a conditional field that rolls up values with a FLAG that statis Total List is $0, you need to insert a value. Once Total List is >$0, that conditional field disappears.
Is that the best/only solution. Thanks all.
Answers
-
Forms cannot do calculations like that. You would need to submit the form to be able to evaluate the data. You will need to either look into a 3rd party form option that has that capability, or you will need to send an automated update request to the submitter after the fact.
-
Thanks for the response.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives