Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

Best regards

Best Answer

  • ✭✭
    edited 10/02/24 Answer ✓

    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'

Answers

  • ✭✭
    edited 10/02/24 Answer ✓

    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'

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions