pgwalsh
 
Search this site

What I do

KAHE
SPARKLING NECTRARS
Awesome flavor no junk!
Sweetened with Stevia


All Natural
No HFCS
No Added Sugar
No Artificial Ingredients
No Artificial Sweeteners
No Preservatives
GMO Free
Kosher

Comments How To

This is alternative format version of Steven Hind's excellent visitor comments form, which can be found here. Follow his directions or video tutorial and then if you want your comments section to look like mine, use the content format below for your List page. 

Total comments added up for the list page. Put this in your A1 row of your list page. 

=("Total Comments: " & counta(Sheet1!A2:A))

This next part is the Table Cell Content Format for the list page. Make sure to put this in your A2 row of your list page and nothing in B onward.  
Explanation:

  • ArrayFormula( "all your cells references" )  Creates an array of cells matching your ranges. Essentially repeats downward.
  • Sort("your reference, 1, false) Sorts your table by first column.
  • IF(ISBLANK("name reference"), "blank", "By:") This checks if the cell is blank or not. If you don't have this statement you will have By: in every blank cell. Not good.
  • CHAR(10) A newline. This allows your to have some separation from user name and comments.

Here's the entire formula to cut and paste if you wish. Remove spaces if you get an error.

=ArrayFormula(sort(Sheet1!A2:A&IF(ISBLANK(Sheet1!B2:B), " ", " By: ")
&Sheet1!B2:B&CHAR(10)&CHAR(10)&Sheet1!C2:C&CHAR(10)
&CHAR(10),1,false))


* Note: You may get a an error "Invalid Cell Contents," but everything should still work.

Comments_How_To


Comments_How_To