Forum Discussion
Solved
Convert Calculated Value to a Static Value Automatically
I'm not sure if this is even possible, but I am working on creating a sales form template for use at trade shows. The idea is that a salesperson will launch a blank form template on a tablet and fill...
- I just found this brilliant solution to this vexing problem.
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
Hello jdkuehne
as you are using Microsoft 365, have you ever thought about using the Forms app for this purpose (https://www.office.com/launch/forms) ?
It's easy to create forms there which could be used on any device (also mobiles) and the best thing is, all the answers are automatically stored in an Excel workbook as a table. So whenever you need, you could download the workbook and do your analysis in Excel.
Thanks for your response Martin_Weiss.
I looked at this initially, but I didn't understand how to create what I needed using this tool, so I went with Excel. This form number is the last puzzle piece needed to complete the form.
- I just found this brilliant solution to this vexing problem.
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html