Flowgrammer

ClickUp Contract Tracker

Implement the published contract register on a ClickUp List with owners, dates, durable file pointers, and operational notice flags. Not legal advice and not a CLM.

— Craig Major

A ClickUp contract tracker is the published Contract Tracker register built as a List of tasks. Each task names an assignee, a closed status value, a durable URL plus native id and version key, and the key dates. Views and Date Custom Field notify recipes help a person record renew, amend, or terminate. ClickUp does not give legal advice, replace a CLM, or treat a notification as legal notice.

The shared field list lives in the published Contract Register and Renewal Template. The paired ClickUp Contract Register Template is the Custom Field recipe, CSV import, views, and notify-only automation design. This is not a ClickUp invoice tracker, not timesheet Approvals, and not a full document approval workflow. Approval status is a pointer only. If you already run the same schema in Drive, Microsoft 365, monday.com, Notion, Airtable, or a local vault, the published Google Sheets contract tracker, SharePoint / Microsoft Lists contract tracker, monday.com contract tracker, Notion contract tracker, Airtable contract tracker, and Obsidian contract tracker are the platform twins.

Who this is for

Use this when signed files already live in Drive, Box, Dropbox, or SharePoint and the immediate job is one visible ClickUp List: who owns the task, which file version is authoritative, which notice window is open, and which decision is still missing.

Prerequisites:

  • One contract family for the first List. The worked example is fictional Cedar & Quay Fabrication Ltd.
  • Agreement that this is an operational register, not legal advice and not a CLM
  • A named assignee, not a shared inbox
  • A durable file pointer: URL plus native id and version key. Task attachments are an optional companion, not the sole system of record when policy requires an external store
  • A written rule for what happens when a reminder gets no reply
  • Agreement that Formula Fields, Automations, Inbox Reminders, and recurring tasks never set renewed or terminated
  • A reminder path that matches the plan. TODAY() Formula Fields cannot drive Automation Conditions. Date Custom Field arrives recipes need remaining monthly Actions

Stay out of this first List: clause interpretation, auto-renewal legality, e-sign send, a full approval matrix, timesheet Approvals, invoice amounts, tax, PO, payment fields, and any claim that permissions, guests, Activity, Audit Logs, or data hosting are certification.

If you still need the platform-neutral model, stay on the parent tracker. Do not copy invoice money fields from any ClickUp invoice List into this register. Planner lists ClickUp invoice tracker as a separate phrase with no reported data. ClickUp invoice template is 10-100 and stays invoice. ClickUp approval workflow is a different job.

Keyword Planner reports ClickUp contract tracker as No reported data. Do not invent demand.

What ClickUp implements

The parent template defines the shared field list. This pack uses the same names so you can move data without remapping it.

Parent piece ClickUp twin
Field dictionary Custom Fields, same names
Status model Dropdown Custom Field values on status
Duplicate key Text Custom Field plus a grouped view
Roles and exceptions RolesAuthority and ExceptionTaxonomy sheets in the pack
Sample tasks REG-CQ-2026-0914-0920 Same fictional Cedar & Quay cases
Notice formulas notice_date stored as a Date Custom Field; day counts from Config as_of or live Formula TODAY() on a paid plan
Approval pointer approval_status only

Do not rename fields for ClickUp convenience. The same names make later imports and migrations easier.

ClickUp-native additions that are not a second schema:

  • Task assignee for owner, plus People Custom Fields for escalation_target and reviewed_by
  • Dropdown or Labels Custom Fields for type, exception, approval pointer, and access test
  • Date Custom Fields for expiry, notice, and reminder_due_at
  • URL plus Text native id and version key
  • Optional task attachments companion
  • Formula display fields on paid plans, plus helper Number or Dropdown fields when a flag must notify or filter
  • List, Board, Calendar, and Table views
  • An optional notify-only Automation design. If the Workspace still has Actions left, a Date Custom Field arrives or due-date recipe may be an option. Otherwise use the manual reminder process. Tenant- or plan-dependent behavior is needs_live_proof

List, Custom Fields, and the one Closed status

Pick one system of record for status. Do not keep a second live status on the PDF.

Pattern Use when Status lives File identity
Single List plus Dropdown status Default. Matches the inherited 13-status model The Dropdown Custom Field URL plus native id. Attachments optional
Native statuses for in-progress only You want Board view colors for open work Coarse native status plus the Dropdown Same pointers
Shared guest List An external reviewer must see selected tasks The Dropdown Same pointers. Free Forever guests get full access
Hybrid attachments plus external store Operators want a PDF on the task and a durable SoR elsewhere The Dropdown Prefer the external URL. Attachments alone are a weak SoR

ClickUp Help documents custom statuses at Space, Folder, Subfolder, and List levels, and says you cannot create custom Closed statuses. You can rename the one Closed status. Official page: Manage task statuses. That is why this pack prefers a Dropdown Custom Field for the inherited closed list. Status labels do not enforce allowed next statuses. Everything view only shows statuses that exist in every location.

ClickUp Help documents Custom Fields by location. Free Forever has 60 Custom Field uses, including Formula Fields. Paid plans have unlimited uses. Guests cannot create Custom Fields. Official pages: Intro to Formula Fields and Intro to Custom Fields. The public pricing table currently labels Free Custom Fields as Trial. Cite Help for the 60-use figure. Recheck both on publish day. Exact tenant UI is needs_live_proof.

Durable identity and the attachments companion

Path-only pasted URLs break when someone moves a file. Prefer a stack:

  1. file_pointer_url as a URL Custom Field to the durable external store
  2. file_native_id as the Drive, Box, Dropbox, or SharePoint file id
  3. file_version_key as revision, version id, etag, or content hash
  4. Optional task attachments for a working copy on the task

Attachments are a companion store. They are not a certified version system of record. Docs attached to a task inherit task permissions. They are still not the contract SoR. Official page: Share Docs.

Proof gate: open the pointer as a named reviewer and set access_test_result. A material file replace without a new register task is missing_or_stale_file_pointer or a superseding task.

TODAY() Formula Fields cannot drive Automations

ClickUp Help documents that Formula Fields calculate between numeric, date, and time fields. Formula Fields do not support Custom Fields that contain text. Formula Fields that use TODAY() cannot be sorted, filtered, grouped, or used in Dashboard Calculation cards. You cannot calculate those Formula columns. Nested Formulas cannot exceed one layer. Formula Fields cannot be added to multiple locations. Official page: Intro to Formula Fields.

Automation Conditions do not support Formula Fields that use Today(). Official page: Use Automation Conditions. Custom Field change Triggers also skip Formula Fields that use Today(). Official page: Use Automation Triggers.

Formula Fields are not compatible with templates. When you apply a List or task template and include Custom Fields, Formula Fields are not included. Official pages: Use List templates and Use task templates. Recreate Formula Fields after apply, or skip them and keep Date Custom Field helpers.

Do not point a notify recipe at a TODAY() Formula flag and expect it to fire.

Use one of these:

  • Config as_of_date for packaged samples. This pack uses 8 September 2026
  • Date Custom Field arrives on notice_date or reminder_due_at
  • Due date arrives or Date is Before/After, which fire at 4 am local time of the Automation creator when no time is set
  • A helper Number or Dropdown set by Automation, then notify from the helper
  • Manual ReminderEscalation when Automations are unavailable or the monthly Action cap is exhausted

notice_date is expiry_date minus notice_window_days when both exist. Store that result as a Date Custom Field. That is operational date math. It is not legal notice.

duplicate_key is lower(counterparty_id or counterparty_name) plus | plus lower(contract_id). Populate it by import or Automation into a Text Custom Field. Do not assume a Formula can concatenate text Custom Fields. ClickUp has no native unique constraint. A grouped view plus a human duplicate status is the control.

These formulas are planning aids. They are not statutory interpretation or an auto-renewal rule. If notice flags live only in a TODAY() Formula, record formula_automation_gap. If a template apply dropped Formula Fields, record formula_missing_after_template.

Date Custom Field reminders and Action caps

A reminder is an operational nudge. It is not proof that contractual or statutory notice was validly delivered. No reminder timeout may set renewed or terminated.

Pattern When What it may do What it must not do
Manual ReminderEscalation Always valid. Use this first, or when Automations are paused Owner reviews Notice and Decision views. Record reminder_sent_at and evidence_ref Auto-renew
Date Custom Field arrives If Automations remain available; Action caps apply; needs_live_proof for UI labels Notify the owner when the Date Custom Field arrives Change status to renewed or terminated
Due date or Date is Before/After Creator timezone; no time fires at 4 am local Notify only Treat the run as legal notice
Inbox Reminder Every plan, including guests Personal or delegated follow-up Use Inbox as the register SoR

ClickUp Help documents Date Custom Field arrives and Custom Field changes as Automation Triggers, and Set Custom Field as an Action. Official page: Use Custom Fields in Automations. Date Automations use the creator timezone. If the date has no time, the Automation fires at 4 am local. Official page: Use Automation Triggers. Exact Automate labels stay needs_live_proof.

Inbox Reminders are available on every plan, including guests. They live in Inbox and can be delegated. Official page: Intro to reminders. They are optional human aids. They are not DecisionRecord.

Automation Action and active-rule caps are plan-gated. Help currently documents Free Forever 5 active Automations and 100 Actions per month, Unlimited 500 and 1,000, Business unlimited active and 5,000 Actions, Business Plus unlimited active and 25,000 Actions, and Enterprise unlimited active and 250,000 Actions. Conditions are documented as Business Plan and above. One Automation may have 1 Trigger, 15 Conditions, and 6 Actions. Usage history is 1 day on Free Forever, Unlimited, and Business; 30 days on Business Plus; 6 months on Enterprise. Caps reset on the first of the month Pacific Time. Exceeding the cap pauses Automations for that month. Official page: Automations feature availability and limits.

Public ClickUp pricing currently shows four tiers: Free Forever, Unlimited, Business, and Enterprise. Help and the API still document Business Plus. Do not invent CAD or USD seat prices. Recheck both on publish day. When the allotment is exhausted, record automation_action_cap_exhausted and switch to the manual process. Do not treat silence as renewal.

The pack includes an original notify-only recipe design, not a tenant export and not a Template Center listing. It is not executed against a live environment.

Timesheet Approvals are not contract approval

ClickUp documents Timesheet approvals as a weekly time-entry submit and review feature. It is not a contract register and not a document-approval system. Official page: Timesheet approvals. That Help URL was Cloudflare-challenged during this production re-fetch. The public pricing table still lists Timesheet Approvals as a separate feature. Exact plan gates stay needs_live_proof. If a team treats timesheet Approvals as contract approval, record timesheet_approvals_confusion.

approval_status on this register is a pointer to the published document-approval vocabulary. It is not timesheet Approvals.

Guests, Activity, and hosting are not certification

Map pack roles operationally:

Pack role Typical ClickUp mapping
Register_Admin Workspace owner, admin, or a member who may change List structure
Contract_Owner Member with edit on own tasks
Reviewer Limited member or comment permission
Escalation_Owner Member
Auditor_Read View or comment
Counsel_OutOfBand No List edit. Advice stays outside ClickUp
External_Counterparty Guest only when policy allows. No edit
Unauthorized_Actor Any other editor. Log unauthorized_status_change

ClickUp Help documents guest, limited member, member, admin, and owner roles. Free Forever guests must be given full access on the public pricing table. Permission-controlled guests start on paid plans. Guests cannot create Custom Fields. Collaboration controls are not a security certification. Official page: Permissions in detail. Views are not access control.

Activity view depth is plan-gated on the public pricing table: 1 day on Free Forever, 7 days on Unlimited, deeper on Business and Enterprise. Workspace Audit Logs are Enterprise only, owners by default, with optional admin access. Help re-fetched on 8 September 2026 says historical Audit Log data is available for 60 days. Official page: Audit Logs feature availability and limits. Research commit 24ce755 cited 30 days. Use the current 60-day Help figure. Activity and Audit Logs are not DecisionRecord. Keep DecisionRecord and Evidence.

ClickUp stores customer data in AWS regions Oregon, Ohio, Sydney, Singapore, and Dublin. Enterprise customers can request US-only, EU-only, Singapore-only, or AU-only hosting. There is no charge stated for that request. Login, Notes, and Reminders may still live in the global region. AI features may process outside the selected region. Official page: Data hosting. Hosting and retention stay questions, not certification.

API rate limits are 100 requests per minute per token on Free Forever, Unlimited, and Business; 1,000 on Business Plus; 10,000 on Enterprise. HTTP 429 on exceed. Official page: Rate Limits. Those numbers are mutable. Recheck on publish day.

Worked example

Cedar & Quay Fabrication Ltd is a fictional Toronto fabricator. Create the List from the Custom Field recipe, or import csv/register-import.csv. Leave Config as_of_date at 8 September 2026.

  1. REG-CQ-2026-0914, Northshore Logistics MSA CTR-CQ-MSA-2024-017. Owner Avery. Status active. URL, native id FICTION-CQ-MSA-017, and version key present. Expiry 30 September 2027. 60-day operational notice window. No exception.
  2. REG-CQ-2026-0915 uses the same family with a nearer expiry. Status notice_window_open. Date Custom Field notify scheduled to Avery. Escalation target Riley.
  3. REG-CQ-2026-0916 is on exception hold because the durable URL and native ids are blank. A renewal decision stays blocked.
  4. REG-CQ-2026-0917 is a second Northshore plus the same contract id. Status duplicate. Canonical task REG-CQ-2026-0914 continues.
  5. REG-CQ-2026-0918 records an unauthorized attempt to mark renewed. Status returns to exception hold. Quick status-arrow skips may not appear in Activity.
  6. REG-CQ-2026-0919 expired on 15 August 2026 with no renew, amend, or terminate note.
  7. REG-CQ-2026-0920 sent a reminder, failed escalation, and keeps renewal_decision_needed. If TODAY() Formula flags never notified, also record formula_automation_gap. If a template apply dropped Formula Fields, record formula_missing_after_template. If monthly Actions ran out, record automation_action_cap_exhausted. It does not auto-renew.

Those numbers are fixture math, not a customer result.

On the as-of date 8 September 2026, the clean Cedar & Quay MSA uses expiry 30 September 2027 and a 60-day window. That produces notice date 1 August 2027, 327 days to notice, and 387 days to expiry. Case 2 uses a nearer expiry so the same family can show a window that is already open.

Views and dashboards

Create these views:

  • List: Active
  • List: Notice window
  • List: Decision needed
  • List: Exceptions
  • List: Duplicates, grouped by duplicate_key
  • Calendar on expiry_date or notice_date
  • Board on status

Dashboard Calculation cards cannot read TODAY() Formula Fields. Use helper Number or Dropdown fields when a widget must read a flag. Advanced Dashboard cards are plan-gated. Recheck on publish day. Exact card labels stay needs_live_proof.

Filters and views are not access control. People with edit can still change tasks they can open. Status labels constrain the Dropdown. They do not hard-enforce allowed next statuses. Unauthorized changes stay a process and DecisionRecord exception.

What can run automatically, and what cannot

Situation Automatic action Person required
Complete task with durable pointer and owner Status may stay active Owner assignment
Date Custom Field arrives on notice_date Notify owner; stamp reminder_sent_at Owner reviews the file
Notice passed with no decision Flag renewal_decision_needed Explicit renew, amend, or terminate
File pointer, native id, or version key blank Exception missing_or_stale_file_pointer Restore the pointer before any renewal close
Second task, same counterparty and contract id Status duplicate Admin links the canonical task
Actor not on the matrix sets renewed Exception unauthorized_status_change Register admin reviews
Reminder sent, no ack, escalation unreachable Exception reminder_escalation_failed Repair the path. Do not auto-renew
TODAY() Formula flags never notify Exception formula_automation_gap Add a Date Custom Field recipe or helper, or use the manual process
Formula Fields missing after template apply Exception formula_missing_after_template Recreate the Formula or keep Date helpers
Monthly Actions exhausted Exception automation_action_cap_exhausted Manual process; no auto-renew
Guest overshare Exception guest_overshare_or_permission_mismatch Review sharing; hide sensitive Custom Fields
Timesheet Approvals used as contract approval Exception timesheet_approvals_confusion Separate the time-reporting feature
Invoice money fields added to the register Exception invoice_schema_bleed Remove those fields. Use a separate invoice List
Automation sets renewed Out of scope Remove that action
Payment, bank-detail change, or final accounting post Never Entirely outside

Human gates

A person keeps these decisions:

  • Named assignee before a task goes active
  • Explicit renew, amend, or terminate
  • Counsel review when the client's policy requires it
  • Duplicate versus canonical task
  • Missing or stale URL, native id, or version key
  • Unauthorized status change
  • Failed reminder or escalation
  • Whether Date Custom Field recipes, helper fields, or manual reminders can actually run
  • Who may edit the List, and whether guests belong on it
  • Whether timesheet Approvals are being confused with contract approval

A reminder can nudge. It cannot renew. It cannot terminate. It cannot prove that contractual notice was validly delivered.

Failure paths

Failure Expected status Renewal decision
Missing or stale file pointer exception_hold + missing_or_stale_file_pointer Blocked
Duplicate counterparty and contract id duplicate No second track
Unauthorized status change to renewed exception_hold + unauthorized_status_change Revert or hold
Expired without a decision expired + expired_without_renewal_decision Escalation required
Reminder or escalation failed renewal_decision_needed + reminder_escalation_failed Still required; no auto-renew
TODAY() Formula flags never notify Keep the decision open + formula_automation_gap Date recipe, helper, or manual process; no auto-renew
Formula Fields missing after template apply Process exception + formula_missing_after_template Recreate or use Date helpers; no auto-renew
Action cap exhausted Keep the decision open + automation_action_cap_exhausted Manual process; no auto-renew
Guest overshare Process exception + guest_overshare_or_permission_mismatch Still required
Timesheet Approvals confusion Process exception + timesheet_approvals_confusion Still required
Permissions or hosting treated as certification Process exception still required Still required
Automation sets renewed Out of scope Remove that action

Test cases

The seven Cedar & Quay cases are operational fixtures. They are not customer stories and they do not measure accuracy.

Case Input After the control
Clean active URL and native id present active, no exception
Approaching notice Same family, nearer expiry notice_window_open
Missing pointer Blank URL and ids Decision blocked
Duplicate Second Northshore + same contract id duplicate; canonical continues
Unauthorized change Teammate marks renewed Exception, revert or hold
Expired, no decision Expiry 15 August 2026 expired plus escalation
Failed handoff Reminder sent, Riley unreachable, Formula gap, template gap, or Action cap exhausted Decision still open

The ClickUp Contract Register Template walks each case.

What to measure

Record tasks with a URL plus native id and version key, active tasks with an owner, notice-window tasks with a scheduled reminder, blocked unauthorized status changes, suppressed duplicates, hours from reminder to ack, leftover monthly Automation Actions, and whether the Workspace uses Date Custom Field recipes, helper fields, or manual reminders. Put your numbers in the pack. Keep them as operational counts, not as a savings, accuracy, or ranking result.

There is no live production ClickUp contract-tracker metric here, and no Flowgrammer customer case. Keyword Planner reports ClickUp contract tracker as No reported data. Adjacent ClickUp automation, document-management, and approval-workflow phrases are 10-100 Volume reported and are not this H1. Do not invent a volume.

How to use the ClickUp template

The paired asset is an editable CSV and XLSX List-import pack plus views and a notify-only automation design. It is not a ClickUp Template Center or Marketplace listing, not a CLM, and not legal advice.

  1. Read Setup and acknowledge the legal-boundary, Formula TODAY, template, Action-cap, timesheet Approvals, and no-marketplace caveats.
  2. Create a ClickUp List from the Custom Field recipe, or import csv/register-import.csv.
  3. Confirm the inherited field list and the closed status model. Prefer a Dropdown Custom Field for status.
  4. Add Assignee, Dropdown, Date, Number, URL, Text, People, and optional Formula or attachment fields to match the dictionary.
  5. Walk Case01 through Case07. Confirm case 3 blocks renewal and case 7 does not auto-renew.
  6. Create the queue views. Optional: add a Dashboard that reads helper Numbers, not TODAY() Formulas.
  7. If you add reminders and the Workspace still has Actions left, a Date Custom Field arrives or due-date recipe may be an option. Otherwise use the manual reminder process. Tenant- or plan-dependent behavior is needs_live_proof. Notify and stamp timestamps. Never change status.

Unpublished Smartsheet, Coda, and Zoho contract-tracker children can reuse this dictionary later. Those pages are not published, so they stay unlinked.

Realistic limitations

  • A ClickUp notification, Inbox Reminder, or Automation run is not proof that contractual notice was validly delivered.
  • auto_renew_flag_operational is an operations flag. It does not mean the clause is enforceable.
  • ClickUp permissions, guests, Activity, Audit Logs, and data hosting are not certification.
  • TODAY() Formula Fields cannot drive Automation Conditions, sort, filter, group, or Dashboard Calculation cards.
  • Formula Fields are not included when applying ClickUp templates.
  • Automation Action caps, Custom Field uses, Activity depth, and API rate limits are mutable. Recheck Help and pricing on publish day.
  • Public pricing currently shows four tiers while Help still documents Business Plus. Cite plan categories only. Do not invent seat prices.
  • There is no native unique constraint on counterparty plus contract id.
  • ClickUp allows only one Closed native status. Prefer a Dropdown Custom Field for the inherited status list.
  • This package is a schema and import pack. No live ClickUp List was created or verified in this pass. Do not treat the download as a Template Center listing.
  • This guide does not rank CLM or e-sign vendors, and it is not a live ClickUp product walkthrough.
  • A signature-complete event is not a renewal decision. Invoice money fields belong on a different List. Timesheet Approvals belong to time reporting.

Next step

Download the ClickUp Contract Register Template and create the List. Keep the parent Contract Tracker open while you fill owner, dates, URL plus native id, and the seven cases.

If owners, notice windows, or the destination register are still unclear, start with an AI Success Audit. If one contract family, named owners, and one ClickUp List destination are already defined, book a fit call to scope an AI Automation Systems build.

Sources

Frequently asked questions

What is a ClickUp contract register?

It is the published contract register implemented as a ClickUp List: ownership, status, durable file identity, dates, and operational notice flags so a person can record an explicit renew, amend, or terminate decision.

Is a ClickUp contract register a CLM?

No. Contract lifecycle management products handle negotiation, clause libraries, and repository workflows. A ClickUp register tracks operational ownership, dates, and notice flags.

Is this the same as a ClickUp invoice tracker?

No. Invoice trackers focus on amounts, POs, and payment states. This register uses the parent contract field map and must not share invoice money schema. Planner lists `ClickUp invoice tracker` as a separate phrase with no reported data.

Are ClickUp timesheet Approvals the same as contract approval?

No. Timesheet Approvals are a time-reporting feature. Contract approval lives on the published document-approval workflow. This register keeps `approval_status` as a pointer only.

Can a TODAY() Formula Field trigger renewal reminder Automations?

No. ClickUp documents that Formula Fields that use `Today()` are not supported in Automation Conditions, and they cannot be sorted, filtered, grouped, or used in Dashboard Calculation cards. Use Date Custom Field arrives recipes and helper fields.

Do Formula Fields survive a List template apply?

No. ClickUp documents that Formula Fields are not compatible with templates. Recreate them after apply, or keep Date Custom Field helpers.

Does a ClickUp notification count as contractual notice?

No. Automation notifications and Inbox Reminders are operational alerts only. They do not prove that a contractual or statutory notice was validly delivered.

Who decides renew, amend, or terminate?

A named human owner, and the escalation owner when needed. Formulas, Automations, Inbox Reminders, and recurring tasks must not auto-set `renewed` or `terminated`.

Is this an e-signature solution?

No. Completing a signature is not the same as recording a renewal decision in the register.

Are Activity or Audit Logs a legal audit trail for renewals?

No. Activity is plan-gated collaboration history. Audit Logs are Enterprise only, with 60 days of historical data on the Help page re-fetched 8 September 2026. Keep an explicit DecisionRecord and evidence pointer for renewal decisions.

Do you ship a live ClickUp Template Center listing?

No. Flowgrammer ships original downloadable List-import assets for this register. Do not claim a live Template Center or Marketplace listing unless a verified URL exists.

Which ClickUp plan do you need for Formula Fields and Automations?

Formula Fields calculate on paid plans. Free Forever has 60 Custom Field uses including Formula. Automations exist on every plan with Action and active-rule caps that Help currently documents as Free Forever 100 Actions, Unlimited 1,000, Business 5,000, Business Plus 25,000, and Enterprise 250,000. Public pricing currently shows four tiers. Those caps are mutable. Cite plan categories only and recheck Help on publish day.