How to sort your offer Excel download by expiry date
When considering how you respond to an offer, it can be helpful
to sort the offer by critical information such as product expiry date. This is
possible once you have downloaded the offer spreadsheet.
Note: Remember, there are two spreadsheets you can download
from an offer; firstly, the ‘Download offer’ sheet which can be used to review
the offer in detail or share with a colleague but cannot be used to update the offer.
Secondly, the ‘Download’ spreadsheet, found in the update via spreadsheet section which can be used to review some details
of the offer as well as update the offer by uploading your edited spreadsheet. The following steps work for both versions of the spreadsheet.
2. Open the spreadsheet and highlight all rows from the column headers onwards (exclude the first 3 or four rows):
3. Click ‘Sort & Filter’ > 'Custom Sort' in the
navigation bar:
4. Select ‘Expiry date’ in the sort
by dropdown menu
5. Click OK and you will be prompted
to respond to a warning. Select ‘Sort anything that looks like a number, as a
number’:
6. Press OK, and now your
spreadsheet will be sorted by expiry date:
Related Articles
Update Offer Via Spreadsheet
You are able to download, view and edit a spreadsheet containing the details of your offer. This may be beneficial as you consider and respond to the offer. Download offer as a spreadsheet Simply click the ‘Download offer’ button to download an Excel ...Create an offer
So, you’re ready to share an offer of one or more products, with one or more External Partners (EXP) – how to create an offer? This article will outline how you can create an offer in three steps. Note: Prior to sharing your offer, you’ll need to ...Release Notes: Summer-24
Comms ENHANCEMENT - Provide OPCO Organisation Owner with an email alert when new EXP users are created. Donations VISUAL UPDATE - Enabled OPCO users to use download to update function so that OPCO users can edit all fields within a donation of ...Responding to offers
Offer Statuses When an External Partner (EXP) responds to an offer from an Operating Company (OPCO), there are three essential statuses to consider: means that the EXP has been notified of an offer and have not yet responded. means that you have ...Allocate products to meet partners’ response
So, your EXP (External Partner) has responded to your offer, what next? Use the status filter on the main offers table to view all offers with a status which means they are waiting on your Operating Company’s (OPCO) reply. Remember that an offer is ...