Copy formulas for your Custom Formats! 

Filter formulas by keyword:

Title	Copy to Clipboard
Invoices
Address with Client Name/Contact Name	Copy	[Client Name 1(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))][IF([Contact name(Client contact(Invoice client(Billing Decision invoice(Billing Decision))))] <> "", " Attn: ","")][IF([Contact name(Client contact(Invoice client(Billing Decision invoice(Billing Decision))))] <> "", [Contact name(Client contact(Invoice client(Billing Decision invoice(Billing Decision))))], "")] [Contact Address Address 1(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))] [IF([Contact Address Address 2(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))] <> "", [Contact Address Address 2(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))], "")][IF([Contact Address Address 2(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))] <> "", " ", "")][Mailing City State Zip(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision))))]	Invoices
Address with Client Name	Copy	[Client Name 1(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))] [Contact Address Address 1(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))] [IF([Contact Address Address 2(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))] <> "", [Contact Address Address 2(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))], "")][IF([Contact Address Address 2(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))] <> "", " ", "")][Mailing City State Zip(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision))))]	Invoices
Address with Client Name 1/Name 2	Copy	[Client Name 1(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))][IF([Client name 2(Invoice client(Billing Decision invoice(Billing Decision)))] <> "", " ","")][IF([Client name 2(Invoice client(Billing Decision invoice(Billing Decision)))] <> "", [Client name 2(Invoice client(Billing Decision invoice(Billing Decision)))], "")] [Contact Address Address 1(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))] [IF([Contact Address Address 2(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))] <> "", [Contact Address Address 2(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))], "")][IF([Contact Address Address 2(Mailing Address(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision)))))] <> "", " ", "")][Mailing City State Zip(Client Contact(Ledger Entry Client(Billing Decision Ledger Entry(Billing Decision))))]	Invoices
Statements
Address with Client Name/Contact Name	Copy	[Client Name 1(Client)][IF([Contact Name(Client Contact(Client))] <> "", " Attn: ","")][IF([Contact Name(Client Contact(Client))] <> "",[Contact Name(Client Contact(Client))], "")] [Contact Address Address 1(Mailing Address(Client Contact(Client)))] [IF([Contact Address Address 2(Mailing Address(Client Contact(Client)))] <> "",[Contact Address Address 2(Mailing Address(Client Contact(Client)))], "")][IF([Contact Address Address 2(Mailing Address(Client Contact(Client)))] <> "", " ", "")][Mailing City State Zip(Client contact(Client))]	Invoices
Address with Client Name 1/Name 2	Copy	[Client name 1(Client)][IF([Client name 2(Client)] <> "", " ", "")][IF([Client name 2(Client)] <> "", [Client name 2(Client)], "")] [Contact Address Address 1(Mailing Address(Client Contact(Client)))] [IF([Contact Address Address 2(Mailing Address(Client Contact(Client)))] <> "",[Contact Address Address 2(Mailing Address(Client Contact(Client)))], "")][IF([Contact Address Address 2(Mailing Address(Client Contact(Client)))] <> "", " ", "")][Mailing City State Zip(Client contact(Client))]	Statements
Labels
Address with Client Name/Contact Name	Copy	[Client Name 1(Client)][IF([Contact Name(Client Contact(Client))] <> "", " Attn: ","")][IF([Contact Name(Client Contact(Client))] <> "",[Contact Name(Client Contact(Client))], "")] [Contact Address address 1(Mailing Address(Client contact(Client)))] [IF([Contact Address address 2(Mailing Address(Client contact(Client)))] <> "",[Contact Address address 2(Mailing Address(Client contact(Client)))], "")][IF([Contact Address address 2(Mailing Address(Client contact(Client)))] <> "", " ", "")][Contact Address City State Zip(Mailing Address(Client contact(Client)))]	Invoices
Client Management
Interaction Listing - Logged in Staff Filter	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Interaction staff(Interaction))] OR ID(Logged In Staff) = [Staff staff id(Interaction staff(Interaction))], true, false)]	Client Management
Project Management
Budget to Actual - Logged in Staff Filter for Assigned	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Project assigned  staff(Project))], true, false)]	Project Management
Budget to Actual - Logged in Staff Filter for Responsible	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Project responsible  staff(Project))], true, false)]	Project Management
Project Listing - Logged in Staff Filter for Assigned	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Project assigned  staff(Project))], true, false)]	Project Management
Project Listing - Logged in Staff Filter for Responsible	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Project responsible  staff(Project))], true, false)]	Project Management
Project Listing - Logged in Staff Filter for Tasks	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Task staff(Task))], true, false)]	Project Management
Project Tracking - Logged in Staff Filter for Assigned	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Project assigned  staff(Project))], true, false)]	Project Management
Project Tracking - Logged in Staff Filter for Responsible	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Project responsible  staff(Project))], true, false)]	Project Management
Routing Sheet - Logged in Staff Filter for Assigned	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Project assigned  staff(Project))], true, false)]	Project Management
Routing Sheet - Logged in Staff Filter for Responsible	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Project responsible  staff(Project))], true, false)]	Project Management
Routing Sheet - Logged in Staff Filter for Tasks	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Task staff(Task))], true, false)]	Project Management
Task Budget to Actual - Logged in Staff Filter	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Task staff(Task))], true, false)]	Project Management
Task Tracking - Logged in Staff Filter	Copy	[IF(ID(Logged In Staff) = [Staff staff id(Task staff(Task))], true, false)]	Project Management