Verify if there is comments in a row

Clément Q

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 empty or not ?

Best regards

ShaneP

You could try the following (which will tick a box in the row when a comment is added or a separate box for when a document is attached):

1. Add a column to your sheet and make the column type "checkbox" - Call it something like "Comment Added". Make sure you hit 'save' before doing the next step
2. In automation, select create from scratch, do the following
   1. Trigger: When rows are changed
   2. When: select 'A comment' - is: Added (tick this) Changed (could also tick this)
   3. Then under select a action, select "Change cell value"
   4. Select the column you created as a checkbox and under the dropdown, select 'Checked'

Do the same thing for attachments; just call it 'Attachment added' and for point b. you would select 'an attachment'

ShaneP

You could try the following (which will tick a box in the row when a comment is added or a separate box for when a document is attached):

1. Add a column to your sheet and make the column type "checkbox" - Call it something like "Comment Added". Make sure you hit 'save' before doing the next step
2. In automation, select create from scratch, do the following
   1. Trigger: When rows are changed
   2. When: select 'A comment' - is: Added (tick this) Changed (could also tick this)
   3. Then under select a action, select "Change cell value"
   4. Select the column you created as a checkbox and under the dropdown, select 'Checked'

Do the same thing for attachments; just call it 'Attachment added' and for point b. you would select 'an attachment'