Forum Discussion
Ticket form
I am creating a test ticket. I attempted to add an xlookup in a cell. This is the formula. =XLOOKUP(B19,Table1,2,0). The ticket I am attempting to create is using information from 2 sheets located...
QTY has a formula that adds total days, which should multiply by the price once I am able to pull that information from the 3rd page. I also need the '1" to remain nothing until the date fields are populated for that row. I am attempting to create rent type ticket. When a an item number is selected the description is automatically added and the price associated with that item is added as well to complete the formula. I need to add date picker to the cells for the date cells.