Checking if it is ok to have formulas in a design table or is that not supported.
Thanks for any help,
In Design Tables you can use any formula or function available in Excel. You can even define your own functions (using a VB module) and use them on the design table (just add the VB module to the design table open in Excel). You can also link cels in the design tables to cels on other excel files, etc,. A SW design table is just an embedded Excel object. The limit is your level of knowledge of Excel and Visual Basic.
The DT uses an Excel platform.
I have used formulas all be it simple ones, but yes it can be done.
How complicated are you looking to get?
These can be helpful:
Excel tips for Engineers
You can use any excel functions in your design table. You can even use multiple worksheets (I do quite often), but SW will only use the information on whatever worksheet is open when you close the file.
Retrieving data ...