How to generate one document for two form formatting and applies auto number only in dark blue row?
Hi, I am currently working on a two form formatting to generate a purchase requisition form. As you can see, there is one row in dark blue referring to the purchase requisition details, and another two rows referring to the breakdown of the items to purchase.
1) I would like to generate the 3 rows into one document and attached to the dark blue row. However, so far, the constraint that I am facing is that generation of documents is by each row.
2) I am applying auto numbering. However, I would want to only capture the auto numbering only when dark blue rows are available. Currently, the auto numbering is also applied to each row and not able to be selective. Is there any formula or automation i can use?
3) How to sum up the item cost to show a grand total of a particular purchase based on every order details submitted? Any formula that can help?