Skip to content
Recued
Menu
← Back to recipes

Comment on Smartsheet row with closure watch

by recued-core v1

Workflow origin for the Smartsheet row discussion closure loop. It reads one Smartsheet row and current row discussions for context, creates exactly one owner-provided row-level discussion through recued-core.smartsheet.row.discussion.create, and when the discussion succeeds it seeds durable data.shared closure state for smartsheet-row-discussion-closure-watcher. It uses deterministic owner-provided copy rather than AI and does not add rows, edit cells, delete rows, share sheets, send update requests, upload attachments, mutate automations or proofs, or otherwise mutate Smartsheet beyond the owner-approved row discussion.

Complete workflow

Workflow pack for Recued-created Smartsheet row discussions. It composes the Smartsheet capability pack with a closure ledger: create one owner-approved row-level discussion/comment on an existing Smartsheet row, persist only the connection/sheet/row/discussion linkage in data.shared, and let a scheduled watcher re-read that exact row until a configured status column reaches a terminal value. Terminal rows close the Recued row; unreadable rows remain open until a future watcher pass can prove terminal state. This pack does not replace Smartsheet discussions, comments, automations, update requests, reminders, notifications, reports, dashboards, sharing, attachments, proofs, or sheet permissions; it adds Recued-visible closure state for row discussions Recued created.

You are viewing one recipe in this workflow. Installing it opens the complete pack so its other recipes and background automations arrive together.

Workflow origin for the Smartsheet row discussion closure loop. It reads one Smartsheet row and current row discussions for context, creates exactly one owner-provided row-level discussion through recued-core.smartsheet.row.discussion.create, and when the discussion succeeds it seeds durable data.shared closure state for smartsheet-row-discussion-closure-watcher. It uses deterministic owner-provided copy rather than AI and does not add rows, edit cells, delete rows, share sheets, send update requests, upload attachments, mutate automations or proofs, or otherwise mutate Smartsheet beyond the owner-approved row discussion.

smartsheetsheetsrowsdiscussions
by recued-core pinned v1

Scheduled adopter for Smartsheet row discussion closure rows seeded by comment-smartsheet-row-with-closure. It lists only Recued-originated row-discussion watches, re-reads a bounded batch of Smartsheet row, and closes the shared row when the configured terminal column reaches a terminal value. Rows that cannot be read remain open instead of closing from cached state. It can notify the owner on terminal state, but it never creates, updates, deletes, shares, imports, uploads attachments, sends update requests, comments on, mutates automations or proofs, or otherwise mutates Smartsheet.

smartsheetsheetsrowsdiscussions
by recued-core pinned v1

Low-frequency timeout role for recued-core/smartsheet-row-discussion-closure. It moves a bounded batch of expired rows from active to timed_out, deletes the active copy only after the durable timeout write succeeds, and notifies the owner once per batch.

smartsheetwatchertimeoutowner-review
by recued-core pinned v1

Owner-visible list/close role for recued-core/smartsheet-row-discussion-closure. It lists bounded active, timed-out, and closed rows. Supplying a timed-out or closed key deletes only that exact terminal row; active watches cannot be deleted here.

smartsheetwatcherreviewclose
by recued-core pinned v1
View pack details, dependencies, and permissions →
How it works 46 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Process (46 steps)
sheet_id_value trim
Trim whitespace from setting sheet id
row_id_value trim
Trim whitespace from setting row id
comment_text_value trim
Trim whitespace from setting comment text
terminal_column_id_value trim
Trim whitespace from setting terminal column id
has_connection compare
Check if setting smartsheet has data
has_sheet_id compare
Check if sheet id value has data
has_row_id compare
Check if row id value has data
has_comment_text compare
Check if comment text value has data
has_terminal_column compare
Check if terminal column id value has data
skip_row_read any
Check if any of the conditions are true
row_details ?
skip: step.skip_row_read equal true
columns_raw ?
skip: step.skip_row_read equal true
live_row_id default
Apply default
has_live_row compare
Check if live row id has data
columns default
Apply default
terminal_columns filter
Filter by condition
has_terminal_column_match compare
Check if terminal columns has data
row_cells default
Apply default
terminal_cells filter
Filter by condition
terminal_cell_value default
Apply default
terminal_cell_norm lowercase
Convert terminal cell value to lowercase
row_already_terminal compare
Check if terminal cell norm is one of setting terminal values
skip_discussion_context any
Check if any of the conditions are true
row_discussions_raw ?
skip: step.skip_discussion_context equal true
row_discussions default
Apply default
discussion_count_before_create count
Count items in row discussions
skip_discussion_create any
Check if any of the conditions are true
created_discussion ?
skip: step.skip_discussion_create equal true
created_discussion_id default
Apply default
has_created_discussion compare
Check if created discussion id has data
created_at date_add
Add 0 days to
raw_row_key join
Join items with ":"
row_key_colon replace
Replace text in raw row key
row_key_slash replace
Replace text in row key colon
row_key_dot replace
Replace text in row key slash
row_key_at replace
Replace text in row key dot
row_key_space replace
Replace text in row key at
row_key_left_angle replace
Replace text in row key space
row_key_right_angle replace
Replace text in row key left angle
row_key_plus replace
Replace text in row key right angle
row_key_equals replace
Replace text in row key plus
row_key_question replace
Replace text in row key equals
skip_closure_seed any
Check if any of the conditions are true
closure_timeout_at date_add
Add setting no response timeout days days to
seed_smartsheet_row_discussion_closure_watch ?
skip: step.skip_closure_seed equal true
summary to_summary
Format results as a summary card
Settings 7 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

row id setting =
sheet id setting =
smartsheet setting =
comment text setting =
terminal values setting = complete,completed,done,closed
terminal column id setting =
no response timeout days setting = 30

Trust & control

What installing this recipe would let it do. Recued grants these permissions at install — review them there before approving.

Where it runs

Device + server Runs on your device (browser) or your server.

Permissions it requires

Read your Smartsheet connection
Declared by the recipe — Recued grants these at install, where you review them before approving.

Data it touches

Warehousedata.shared

About

Tags

smartsheet smartsheetsheetsrowsdiscussionscommentswork-managementproject-managementapprovalclosed-loopstate:smartsheet-row-discussion-closure-watcherpack:smartsheet-row-discussion-closure

Details

46 steps 7 configurable settings recipe_id: comment-smartsheet-row-with-closure