Welcome!

Copy contents of a cell into Comments

Is there any way to copy the contents of a cell into Comments?

Or have comments on a specific cell?

Or show the value of the last entry in Comments in a cell?

Thanks.

Formulas

Cell linking

Hi Matt,

Zapier could be a great option for some of those. Is that an option for you?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

MIN(COLLECT( function issues
I know I'm going to kick myself when this gets resolved, but I'm having a bit of a brain fart right now. I'm trying to get the lowest non-blank value in a particular range (columns A-E). [A]@row=18, [B]@row=16, [C]@row, [D]@row, & [E]@row are all blank. All five rows are products of column formulas. Basically, there are a…
Date minus # of days to get new date
I am trying to have the Drop Dead column subtract 42 days from the Final Confirmation Date. I have the Drop Dead column setup as a Date Column and have tried doing this formula, but am getting an "Invalid Operation" error. Can anyone tell me what I am doing wrong? And thanks in advance.
Multiple Forms on single Sheet
I am wanting to have a sheet that is going to have all of our production records on it. The office manager will enter all of the work order information with 1 form, and someone in Quality will enter the measurements on another form. If I have the Primary Column as each part's serial number, will the measurement info be…