-
Using Zapier to update a Form Sheet
Hi! I would love some insight on if I can use Zapier integration to update a form sheet. I created a form for new job requisitions. I need to be able to receive updates from our legacy system as the status changes for each job req. Data Shuttle is not an option as the enterprise does not plan to support it. Could Zapier…
-
Verify if there is comments in a row
Good afternoon, Is there any way to automaticaly know if a row has any comment or document ? My goal is to have a cell that return true or false if the row contains a comment or a document in order to add condition on my sheet. So is it posible to call the cell that contain conversations and comments to check if it is…
-
How to attach notes to a line item
Hi, I need to attach notes to my line items. Setting a column as a Note Field is not practical, as I have too much informaiton than can fit on a short line. Using Comments is not practical, as I need to be able to easily access and edit the notes, not scroll thru a list of Comments. How to achieve this in Smartsheet? Thank…
-
Merged: Add New Comment as a Workflow Action
This discussion has been merged.
-
Report on Last Comment date?
I'm seeing that the System Modified field is NOT updated after entering a new comment on a row. Is there a way to report on the Last Comment Date? I am trying to identify a way to create a report on my sheet that shows Last Update dates, and Comments are being utilized to provide a status update, or entry of the last…
-
How can we link a reply in Slack back to SmartSheet without clicking a link back to SmartSheet?
We already linked the SmartSheet with Slack where we received a notification of a comment in Slack, but we noticed that it is only when we use @ as mentioning from SmartSheet comment. Is this true? We also cannot receive a reply back in Slack captured in SmartSheet, unless we click the link in Slack to open SmartSheet to…
-
Seeking Assistance with Smartsheet for Task Management
Hi all, I’m very new to Smartsheet and am keen to explore its features with the goal of eventually rolling it out in my work area. I have an enterprise license assigned through the Government. In our area—Media and Corporate Communications—we receive many tasks through Microsoft Outlook. These often include requests for…
-
Merged: Reactions to Comments
This discussion has been merged.
-
collecting all comments in one cell?
Hi there, I am trying to collect all comments in to one cell following these formulas: =JOIN(COLLECT({Comments}, {Row ID},[RowID]@row)) =JOIN(COLLECT({Comment Only}, {Row ID}, [Row ID]@row), CHAR(10)) Example explaining it: a way to collect all comments in one cell - Smartsheet.com however, it keeps giving me #UNPARSEABLE…
-
Comments to appear in email notification for update request
We have set up an update request automation to include comments. However, when the email comes through, it does not show the comments and the only way to view them is to open the request. It would be nice to see the comments in the emailed notification prior to needing to open the request.