Export Subscribers - Include the 'Status' field?

  • MBAS
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
5 years 5 months ago #133459 by MBAS
Hi, is it possible to include the status field on the Subscriptions page when exporting the list to Excel?


Please Log in or Create an account to join the conversation.

More
5 years 5 months ago #133461 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export Subscribers - Include the 'Status' field?
Hello

There is published field in the export already:

0: Pending
1: Active
2: Expired

Tuan

Please Log in or Create an account to join the conversation.

  • MBAS
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
5 years 5 months ago - 5 years 5 months ago #133462 by MBAS
Hi Tuan;

Thanks for your prompt response. Using the info from your reply as inspiration I added an extra column to the left of the spreadsheet (called Status) and pasted this formula =IF(W2>0,IF(W2=1,"Active","Expired")) in the 2nd cell and copied it down to the last row to translate the published field into an easily read 'Status Column'.
Last edit: 5 years 5 months ago by MBAS.

Please Log in or Create an account to join the conversation.

More
5 years 5 months ago #133463 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export Subscribers - Include the 'Status' field?
Yes, that's good a solution :)

Please Log in or Create an account to join the conversation.