Use “Comment on Smartsheet row with closure watch” in Recued. It carries out the named workflow using the connections and settings you choose.
Comment on Smartsheet row with closure watch
Use “Comment on Smartsheet row with closure watch” in Recued. It carries out the named workflow using the connections and settings you choose.
Complete workflow
Smartsheet Row Discussion Closure Loop
4 pinned recipes
Use Smartsheet Row Discussion Closure Loop in Recued for sheets, rows, discussions, and comments. It includes 2 ready-to-run workflows and 1 related pack in one install.
You are viewing one recipe in this workflow. Installing it opens the complete pack so its other recipes and background automations arrive together.
Use “Smartsheet row discussion closure watcher” in Recued. It checks saved items on a schedule and updates them when the connected service reports a final status.
Use “Smartsheet row discussion closure watcher timeout” in Recued. Low-frequency timeout role for the connected service. It moves a limited batch of expired rows from active to timedout, deletes the active copy only after the durable timeout write succeeds, and notifies the owner once per batch.
Use “Smartsheet row discussion closure watcher lifecycle review” in Recued. It carries out the named workflow using the connections and settings you choose.
How it works
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 connections 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
recued-core.smartsheet.row.read
Read row on smartsheet
skip: step.skip_row_read equal true
columns_raw
recued-core.smartsheet.column.search
Search column on smartsheet
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
recued-core.smartsheet.row.discussion.search
Search row discussion on smartsheet
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
recued-core.smartsheet.row.discussion.create
Create row discussion on smartsheet
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
core.storage.shared.write
Write storage shared
skip: step.skip_closure_seed equal true
summary
to_summary
Format results as a summary card
▼
Output
summary
summary
Settings
Configurable at install. Defaults shown — change them anytime in Recued.
row id
setting
=
sheet id
setting
=
comment text
setting
=
terminal values
setting
=
complete,completed,done,closed
terminal column id
setting
=
no response timeout days
setting
=
30
Uses (5 operations)
Pack operation
Read row on smartsheet
recued-core.smartsheet.row.read
Pack operation
Search column on smartsheet
recued-core.smartsheet.column.search
Pack operation
Search row discussion on smartsheet
recued-core.smartsheet.row.discussion.search
Pack operation
Create row discussion on smartsheet
recued-core.smartsheet.row.discussion.create
Shared store
Write storage shared
core.storage.shared.write
Trust & control
What installing this recipe would let it do. Recued grants these permissions at install — review them there before approving.
Permissions it requires
Declared by the recipe — Recued grants these at install, where you review them before approving.What it's allowed to do
Write
Shared store
core.storage.shared.write
external change
4 more aren't listed here. You'll see them at install.