Best Of

@Marcela Hernandez

Method 1: Hide Columns

In this method, I hide all the unwanted columns and change the 'Comments without Note' column to add one Tech Note at the top, as shown in the 'One note and Comments' column.

https://app.smartsheet.com/b/publish?EQBCT=7fa790e49ea441fe932e8a9be0b9f92b

=[Tech Notes]@row + CHAR(10) + JOIN(COLLECT({Comments by Prefilled Form : Comments w/o Notes}, {Comments by Prefilled Form : Line No.}, [Line No.]@row ), CHAR(10))

This method is good if your commentator has viewer access to the sheet, and can not add comments to rows or the sheet.

Method 2: Latest Comment Special Column + Copy rows automation

If your commentator has commenter or editor access, you can use the Latest Comment special column.

The latest row comment will automatically populate the column, and with automation, you can copy the row to another sheet. Then, using Line No. as a key, you can refer to those comments.

https://app.smartsheet.com/b/publish?EQBCT=c0b3a52d580043abbd61c81223e47fb1

https://app.smartsheet.com/b/publish?EQBCT=aec11f18e0bf450d9fa87b32d7786084

I have a couple of comments on this topic for your reference, if you are interested in this method.

Is there a way to collect all comments in one cell?

Moving Comments Between Sheets

Central Location for User Comments across Smartsheet

@k_Hunter001 Smartsheet can't perform that type of validation in a grid view. The only view in Smartsheet that could do that type of validation would be Dynamic View.

Otherwise, you'd have to use another 3rd party form solution that can enforce that type of logic.

Hi @RiseUpPNW

You need to change the First Name's formula to this;

=LEFT(Volunteer@row , FIND(" ", Volunteer@row ) - 1)

In English, find the space between the first name and last name. Get the string from the top up to position one before the found space position to get the first name.

https://app.smartsheet.com/b/publish?EQBCT=e1858249b1eb43d08b95fe92860b5cd5

I would insert a helper column that outputs the level

=COUNT(ANCESTORS())

Then you can leverage this in whatever other formula you are using to evaluate the levels.

=COUNTIFS(………………….., Level:Level, @cell = 2)

Hey Brandon, would this do the trick?

=SUMIFS({Upcoming Jobs (High Level) Range 3}, {Upcoming Jobs (High Level) Range 1}, OR(@cell = [Job Name 1]@row , @cell = [Job Name 2]@row , @cell = [Job Name 3]@row , @cell = [Job Name 4]@row ))

Hello KPH,

So…. I should probably be barred from sending updates on Monday mornings. You are absolutely right and I haven't been looking at this right, till now. I'm going to go do this a little more correctly and I'll get back to you. Sorry, but thank you for sticking with me!