Created a template form with name as a mandatory cell - cannot share it as blank initially
Hello everyone, I have set a cell in my template as mandatory for person's name to be added before they close the document using F11, workbooks, before close etc., all good! However, I need it to be a blank field when I share it with Sales and then mandatory for them to enter the data as otherwise they may just forget to amend it to their own name. How do I achieve this please? thanks in advance for your help. Gemma