field for counting number of sheets in SSM / add custom field to "rename & renumber" dialog?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
hi everyone,
this question is not about the Description or Sheet Number fields in SheetSet Manager. unfortunately, I've inherited a 99-page sheetset from someone else, and for a number of reasons, I cannot change the setups of these fields.
given those parameters, I was wondering if there is a way to create a field / formula that essentially "locates" which page a sheet is in the total number of sheets in the sheetset without managing that through Description or Sheet Number. for example, there may be 20 sheets in my sheetset. is there a field / formula to identify that this is the 10th sheet in the set?
an alternative would be whether I could add a custom field to "Rename & Renumber," though that seems unlikely? or possibly connect to an external file, like an excel file, though I could see issues with that method, too.
thank you for your help!