Restricting a form by amount entered on a monthly basis

I have a form that utilized for co workers to request use of our department credit card. Our card has a monthly limit of $2,500.00. Is there a way to create a form in smartsheets that would calculate per month the monetary limitation and include any other submissions total for that month and if anyone submitted a form with the estimated cost that would go over a the $2,500 limit an the current submission per month that it would auto send a decline email to the submitter?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!