Remote Ops

Set Up an Async Decision Log with an Explicit Response Deadline

How do I set up an async decision log in Google Sheets with explicit response deadlines and rules for closing decisions?

Use Google Sheets to record each decision's owner, deadline, objections, and status. The deadline ends normal review but does not count as approval. Close a decision only after required approvals are recorded, blockers are resolved, and the outcome is documented.

What you need

  • A Google Sheets spreadsheet with a blank tab named Decisions
  • Access to configure spreadsheet settings, validation, and protected ranges
  • Decision owners and identified required reviewers

A Google Sheets async decision log puts the owner, proposal, response deadline, objections, and outcome in one shared record. The deadline ends the usual review period; it does not approve the proposal. The owner can close a decision only after recording the required approvals and resolving any issues that block closure.

What does the response deadline mean in this decision log?

The response deadline ends normal review, but it does not approve the proposal.

A response is on time only if it arrives before the deadline. Anything received at the cutoff or later is late. If no objection appears in the log, that means only that no objection was recorded. It does not mean reviewers approved. A decision with a missing required approval stays open after the cutoff. The deadline check tells the owner to review the record, not that review is finished.

Set the spreadsheet timezone to America/New_York. Reviewers may convert the deadline to local time, but entering a timezone label in a cell does not convert a timestamp. Teams passing work across time zones should use one consistent approach, such as this method for converting UTC handoff times to local time in Google Sheets. Publish the timezone with every deadline so reviewers can tell which cutoff applies.

Which sample decisions illustrate the Google Sheets log?

The sample records show three different cases: an open proposal, a blocked proposal, and a draft.

Decision ID Proposal Owner Response deadline Timezone Objections Outcome Status
DEC-101 Replace Tuesday status call with written updates Mira Example 2026-07-14 16:00 America/New_York NONE OPEN
DEC-102 Move support handoff to noon Eastern Theo Placeholder 2026-07-15 12:00 America/New_York OPEN: Coverage gap from 11:30 to noon BLOCKED
DEC-103 Pilot a shared onboarding checklist Luma Sample 2026-07-16 15:00 America/New_York NONE DRAFT

NONE means the log contains no objections. It does not show that everyone responded. DEC-101 is still under review. DEC-102 cannot close until its coverage objection is resolved. DEC-103 has not yet entered review. These dates are examples, not suggested review periods. Set a cutoff that gives required reviewers a fair chance to respond during their working hours.

The template builds numeric deadlines with DATE and TIME, rather than storing them as text. That lets the deadline check compare the deadline with the spreadsheet’s current time. When asking a remote team to review a decision, include its ID, owner, exact cutoff, and timezone. More guidance on making work and decisions visible across distributed teams is available on the remote-ops topic page.

How do you install and configure the Google Sheets decision log?

Paste the tab-separated template into A1 on a blank Google Sheets tab named Decisions, then complete the setup steps.

Columns A-H contain decision details. Column I displays a prompt calculated from the deadline and status, and column J holds the manually maintained history.

Decision ID	Proposal	Owner	Response deadline	Timezone	Objections	Outcome	Status	Deadline check	State history
DEC-101	Replace Tuesday status call with written updates	Mira Example	=DATE(2026,7,14)+TIME(16,0,0)	America/New_York	NONE		OPEN	=IF(A2="","",IF(OR(H2="DECIDED",H2="WITHDRAWN"),"CLOSED",IF(H2="DRAFT","NOT OPEN",IF(OR(D2="",NOT(ISNUMBER(D2)),E2<>"America/New_York"),"FIX DEADLINE",IF(H2="BLOCKED","RESOLVE OBJECTION",IF(H2="OPEN",IF(NOW()<D2,"COLLECT RESPONSES","OWNER REVIEW DUE"),"FIX STATUS"))))))	2026-07-13 09:00 America/New_York | Mira Example | DRAFT to OPEN | Review requested
DEC-102	Move support handoff to noon Eastern	Theo Placeholder	=DATE(2026,7,15)+TIME(12,0,0)	America/New_York	OPEN: Coverage gap from 11:30 to noon		BLOCKED	=IF(A3="","",IF(OR(H3="DECIDED",H3="WITHDRAWN"),"CLOSED",IF(H3="DRAFT","NOT OPEN",IF(OR(D3="",NOT(ISNUMBER(D3)),E3<>"America/New_York"),"FIX DEADLINE",IF(H3="BLOCKED","RESOLVE OBJECTION",IF(H3="OPEN",IF(NOW()<D3,"COLLECT RESPONSES","OWNER REVIEW DUE"),"FIX STATUS"))))))	2026-07-13 10:00 America/New_York | Theo Placeholder | DRAFT to OPEN | Review requested; 2026-07-14 11:00 America/New_York | Theo Placeholder | OPEN to BLOCKED | Coverage objection received
DEC-103	Pilot a shared onboarding checklist	Luma Sample	=DATE(2026,7,16)+TIME(15,0,0)	America/New_York	NONE		DRAFT	=IF(A4="","",IF(OR(H4="DECIDED",H4="WITHDRAWN"),"CLOSED",IF(H4="DRAFT","NOT OPEN",IF(OR(D4="",NOT(ISNUMBER(D4)),E4<>"America/New_York"),"FIX DEADLINE",IF(H4="BLOCKED","RESOLVE OBJECTION",IF(H4="OPEN",IF(NOW()<D4,"COLLECT RESPONSES","OWNER REVIEW DUE"),"FIX STATUS"))))))	2026-07-14 09:00 America/New_York | Luma Sample | Created as DRAFT
  1. Set the clock. Open File, Settings, and choose United States locale and Eastern Time for New York, with daylight-saving changes included. Enter America/New_York in the timezone cells.
  2. Format deadlines. Set D2:D to the custom date-time format yyyy-mm-dd hh:mm. A hidden time can make a midnight cutoff hard to spot.
  3. Validate entries. Add a dropdown in H2:H with these values: DRAFT, OPEN, BLOCKED, DECIDED, WITHDRAWN. Restrict E2:E to America/New_York. Apply custom validation =OR(D2="",ISNUMBER(D2)) to D2:D. Reject invalid entries in all three ranges. A blank deadline is allowed only for a draft.
  4. Extend formulas. Copy I2 down through I1000 so the references adjust by row. Protect I2:I1000 from routine editing.
  5. Set recalculation. In File, Settings, Calculation, choose on change and every minute. NOW() does not send notifications.
  6. Assign editing responsibilities. Owners maintain each record, while reviewers comment on proposal cells. Owners copy substantive objections into F and enter every status transition in J. Restrict direct editing where necessary.
  7. Publish review requests. Include the ID, proposal, owner, exact deadline, and timezone. Identify required reviewers in the proposal, and set the status to OPEN only after allowing a reasonable response period during working hours.

Replace the sample records and history with the details of actual decisions. Assign every decision a unique ID, and keep that ID the same when sorting rows. Before review begins, decide who can edit the status and history. If several people can change those cells and no one clearly owns them, the log may no longer reflect the process the group agreed to follow.

Which status transitions may an owner record?

The owner changes status manually under the rules below; column I neither approves a proposal nor changes column H.

Put these rules on a separate Rules tab.

From To Required condition
New row DRAFT Assign a unique ID and owner. The proposal may still change.
DRAFT OPEN Complete the proposal, publish a future deadline, verify the timezone, and notify reviewers.
OPEN BLOCKED Record an unresolved objection or a missing mandatory approval that prevents closure.
BLOCKED OPEN Document resolution of every blocking issue. Retain the existing deadline.
OPEN DECIDED Deadline has arrived, required approvals are recorded, no blocking issue remains, and outcome is complete.
DRAFT, OPEN, or BLOCKED WITHDRAWN Owner records why the proposal is no longer proceeding.
DECIDED or WITHDRAWN No further state Preserve the row. Create a linked decision for reconsideration.

Do not make any transition that is not listed. In particular, an owner must not change BLOCKED directly to DECIDED.

When an objection is resolved, change OPEN: to RESOLVED: but keep the original text, resolution, actor, and timestamp. Record each objection on its own line. Before closing a decision, check pending comments and add any missing blocking issue to F. For a late objection, record whether the owner accepts it or declines it, and give the reason. An accepted objection that remains unresolved blocks an active decision. If the owner declines a late objection, keep the reason in the record.

A decision can stay open after the deadline. For every transition, add its literal timestamp, timezone, actor, old state, new state, and reason to J. Do not use recalculating NOW() for the history. Record the change and its reason directly, so the history will not shift when a formula updates.

Once review opens, do not change the proposal, owner, or deadline. If the proposal needs a material revision or the deadline needs an extension, withdraw the original and create a new ID with a fresh review period. Put the replacement ID in the original outcome. This preserves the original review record and prevents a revised proposal from inheriting responses to an earlier version.

For DECIDED, G must include the selected action, rationale, implementer, and implementation start. A rejection is also a decision. To reconsider a closed decision, create a linked new decision rather than reopening the preserved row.

What deadline-check output should the sample produce?

At 2026-07-14 17:00 America/New_York, the sample formulas should show the prompts below.

Decision ID Stored status Deadline check Owner’s next action
DEC-101 OPEN OWNER REVIEW DUE Inspect responses and record a decision if closure conditions are met
DEC-102 BLOCKED RESOLVE OBJECTION Address the coverage objection before attempting closure
DEC-103 DRAFT NOT OPEN Finish the proposal and publish the review request

DEC-101 is still open one hour after its deadline. DEC-102 continues to show its blocking condition even though its deadline is in the future. Once the objection is resolved, change the decision back to OPEN without moving the cutoff. DEC-103 remains a draft despite the example deadline. The prompt updates as the spreadsheet’s current time changes.

The formula uses nested IF checks in Google Sheets to select a prompt using the row’s ID, stored status, deadline, and timezone label. Google’s NOW() function supplies the current date and time for comparison. Neither function records responses, sends reminders, or changes a status. The owner still has to review the record and make the transition.

The first check, IF(A2="","",...), leaves a row blank when it has no ID, so unused rows stay clear. Next, OR groups DECIDED and WITHDRAWN under CLOSED, since both are terminal states in this template. The following IF returns NOT OPEN for DRAFT before checking the deadline. A draft can have no deadline.

Then OR, NOT, and ISNUMBER check that the deadline is numeric and that the timezone label matches the expected value. Numeric deadlines let the formula compare times rather than text. The formula checks BLOCKED before OPEN, which means an objection must be resolved before the owner acts on the clock. That is why DEC-102 displays RESOLVE OBJECTION even while its deadline is still ahead.

For an OPEN row, NOW()<D2 returns COLLECT RESPONSES before the deadline. At the cutoff or later, the result is OWNER REVIEW DUE. At the example time in this guide, DEC-101 therefore gets the review prompt, while DEC-103 remains NOT OPEN. The final FIX STATUS fallback prevents an unrecognized status from being treated as open. When the formula is filled down, the relative references run the same checks for each row.

How do you fix deadline and closure errors without hiding them?

Fix deadline errors where they originate, and document an invalid closure instead of treating a formula prompt as proof of approval.

A valid-looking deadline produces FIX DEADLINE

Symptom and cause: D shows a timestamp, but I displays FIX DEADLINE. The deadline may be stored as text, or the timezone label may be incorrect.

Exact fix: For DEC-101, enter =DATE(2026,7,14)+TIME(16,0,0) in D2 and set E2 to America/New_York. Reapply the date-time format. For other rows, use their intended dates and times.

Review ends at the wrong local hour

Symptom and cause: A 4:00 p.m. Eastern cutoff appears several hours early or late because the spreadsheet timezone does not match the label. Cell labels do not set the value of NOW().

Exact fix: Set the spreadsheet timezone to Eastern Time for New York. Check D against the published deadline and notify reviewers of any correction. If an open review had an unclear cutoff, withdraw it and create a replacement with a new deadline.

A decided row retains an open objection

Symptom and cause: I displays CLOSED even though F still contains unresolved OPEN: text. Someone has bypassed the manual rules, since the formula does not check objections.

Exact fix: Add a history entry explaining the invalid closure, then create a linked replacement that includes the unresolved objection. Do not present the original as a valid approval. If the problem recurs, restrict status editing to owners.

When should you avoid this Google Sheets decision log?

Do not use this log when a delay could put people at risk or when approval controls need technical enforcement.

  • Urgent operational incidents: Use a live incident channel and name a decision-maker, then enter the decision in the log afterward.
  • Enforced transitions or immutable approval evidence: Choose a dedicated approval workflow with required approvers and controlled transitions. Use the spreadsheet as a readable index, not the authoritative approval record.

When the group needs a record of comments as well as the decision, collect responses outside the decision row and link each record by ID. For recurring updates that do not need a formal approval status, a Google Sheets async weekly digest may be a better fit than creating a decision for every status change.

Sources

Esc