Embed Test

by Jim

Rated: E · Sheets · None · #2362174

.wdc-sheet-embed-sheetph{display:none;}

Log
Author (Alphabetical By Username)	Most Recently Submitted Blog Post	Upvotes Given Today (max 1 each per day)		Total # Posts Submitted
Author (Alphabetical By Username)	Most Recently Submitted Blog Post	Blog Post	Commenter	Total # Posts Submitted
=Bloggers!A3:A	=BYROW(F3:AI,LAMBDA(posts,XLOOKUP(TRUE,MAP(posts,LAMBDA(cell,cell<>"")),posts,"",0,-1)))	=IF(ISBLANK(A3:A),"",IFERROR(BYROW(A3:A,LAMBDA(author,FILTER(UpvotesEligible!$C$3:$C,UpvotesEligible!$A$3:$A=DAY(TODAY()),UpvotesEligible!$D$3:$D="post",UpvotesEligible!$B$3:$B=author))),""))	=IF(ISBLANK(A3:A),"",IFERROR(BYROW(A3:A,LAMBDA(author,FILTER(UpvotesEligible!$C$3:$C,UpvotesEligible!$A$3:$A=DAY(TODAY()),UpvotesEligible!$D$3:$D="commenter",UpvotesEligible!$B$3:$B=author))),""))	=IF(ISBLANK(A3:A),"",BYROW(F3:AI,LAMBDA(days,COUNTA(days))))

Printed from https://www.writing.com/main/handler/item_id/2362174-Embed-Test