Forms with formulas



  • I have a similar question to those on this thread. And if I am reading this correctly, it is not possible.

    I am creating a form for our purchasing department. It will then have automation for approvals based on type and total purchasing price. I was hoping to create a formula form field where they enter units and unit price. The form would then have a column for them that totals U*UP. I would then have another formula field that would sum all U*UPs entered. My colleague was creating something in Excel, and that had limitations, but would be something like this and would allow the calculation:

    My work around was that I could have U, UP, TOTAL fields and they would do the calculations outside the sheet. I could then have the sheet do the calculations so there is some auto validation for the Purchasing Director to reference.

    Thanks for any help that would eliminate the work around.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!