Link to home
Start Free TrialLog in
Avatar of geoffsweb
geoffsweb

asked on

Sharepoint calculations in workflow

I'm using Sharepoint MOSS 2007 and Sharepoint Designer.

I have a list (form) that the user needs to fill out.  It has the standard name, date, category dropdowns, etc...  then there are 5 textboxes that the user can type info into, asking questions in those textboxes.  At the very bottom of the form, there is a textbox called "Total # of Questions".  This textbox needs to auto-populate with the number of the above Questions textboxes that were typed into.  Is this something that I would create a workflow for?  Or would it be done another way?  i tried creating a workflow, and created a variable, and had it populate to 1 if the textbox changed.  But it never seemed to trigger.  Not sure if I did it right.  Any help, suggestions, examples would be much appreciated.
Thanks!
Avatar of leopolde
leopolde

Do you need the calculation to happen in the form, while it is still not saved by the user?

If not, I'd suggest using a calculated column.  Formulas are similar to what you'd use in Excel.  See the following links:
http://office.microsoft.com/en-us/sharepoint-server-help/introduction-to-data-calculations-HA010121588.aspx?CTT=3
http://office.microsoft.com/en-us/sharepoint-server-help/examples-of-common-formulas-HA010105479.aspx?CTT=3
ASKER CERTIFIED SOLUTION
Avatar of geoffsweb
geoffsweb

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of geoffsweb

ASKER

No valid answer given.