Google Sheets Arts and Crafts Formulas

Paint stages, origami folds, and craft project meters.

Paint to masterpiece

Put art progress 0-10 in A1. Palette strokes become a framed painting.

=IF(A1<=5,REPT("🎨",A1)&REPT("░",MAX(0,B1-A1)),REPT("🎨",5)&REPT("🖼️",A1-5)&REPT("░",MAX(0,B1-A1)))

🎨🎨🎨🎨🎨🖼️🖼️🖼️░░

IF REPT

Origami fold steps

Put fold step 0-10 in A1. Paper creases become a finished crane.

=IF(A1<=7,REPT("📄",A1)&REPT("░",MAX(0,B1-A1)),REPT("📄",7)&REPT("🕊️",A1-7)&REPT("░",MAX(0,B1-A1)))

📄📄📄📄📄📄📄🕊️🕊️░

IF REPT

Paint palette fill

Put palette progress 0-10 in A1. Color blobs fill the artist palette.

=REPT("🎨",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" palette"

🎨🎨🎨🎨🎨○○○○○ palette

REPT MIN MAX

Brush stroke counter

Put brush strokes 0-10 in A1. Paintbrushes tally strokes on the canvas.

=REPT("🖌️",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" strokes"

🖌️🖌️🖌️🖌️🖌️○○○○○ strokes

REPT MIN MAX

Clay sculpt stages

Put sculpt progress 0-10 in A1. Clay lumps shape into a finished figurine.

=IF(A1<=5,REPT("🟤",A1)&REPT("░",MAX(0,B1-A1)),REPT("🟤",5)&REPT("🗿",A1-5)&REPT("░",MAX(0,B1-A1)))

🟤🟤🟤🟤🟤🗿🗿🗿░░

IF REPT

Yarn ball unwind

Put knit progress 0-10 in A1. Yarn balls unwind into a finished scarf.

=IF(A1<=6,REPT("🧶",A1)&REPT("░",MAX(0,B1-A1)),REPT("🧶",6)&REPT("🧣",A1-6)&REPT("░",MAX(0,B1-A1)))

🧶🧶🧶🧶🧶🧶🧣🧣░░

IF REPT

Cross-stitch grid percent

Put stitches done in A1 and total in B1. X marks fill the embroidery grid.

=REPT("✖️",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" "&ROUND(A1/B1*100,0)&"%"

✖️✖️✖️✖️✖️⬜⬜⬜⬜⬜ 50%

REPT MIN MAX ROUND

Color pencil tip wear

Put pencil wear 0-10 in A1. Full pencils shorten as the tip wears down.

=REPT("✏️",MIN(A1,B1))&REPT("▪",MAX(0,B1-A1))&" wear"

✏️✏️✏️▪▪▪▪▪ wear

REPT MIN MAX

Canvas priming layers

Put primer coats 0-5 in A1. White layers prep the blank canvas.

=REPT("⬜",MIN(A1,B1))&REPT("🖼️",MAX(0,B1-A1))&" prime"

⬜⬜⬜🖼️🖼️ prime

REPT MIN MAX

Gallery wall hang progress

Put frames hung 0-5 in A1. Empty hooks become a full gallery wall.

=REPT("🖼️",MIN(A1,B1))&REPT("🪝",MAX(0,B1-A1))&" hung"

🖼️🖼️🖼️🪝🪝 hung

REPT MIN MAX

Pottery wheel spin

Put spin progress 0-10 in A1. Clay on the wheel becomes thrown pottery.

=IF(A1<=6,REPT("🟤",A1)&REPT("░",MAX(0,B1-A1)),REPT("🟤",6)&REPT("🏺",A1-6)&REPT("░",MAX(0,B1-A1)))

🟤🟤🟤🟤🟤🟤🏺🏺🏺░

IF REPT

Bead string length

Put beads strung 0-10 in A1. Colorful beads line the jewelry string.

=REPT("📿",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" beads"

📿📿📿📿📿○○○○○ beads

REPT MIN MAX

Scrapbook page corners

Put corners placed 0-4 in A1. Photo corners finish the scrapbook spread.

=REPT("📎",MIN(A1,4))&REPT("📷",MAX(0,4-A1))&" corners"

📎📎📎📷 corners

REPT MIN MAX

Glitter explosion meter

Put glitter level 0-10 in A1. Sparkles erupt as the craft project peaks.

=REPT("✨",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" glitter"

✨✨✨✨✨✨○○○○ glitter

REPT MIN MAX

Macrame knot count

Put knots tied 0-10 in A1. Rope segments show macrame progress.

=REPT("🪢",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" knots"

🪢🪢🪢🪢🪢○○○○○ knots

REPT MIN MAX

Watercolor bleed bar

Put wash progress 0-10 in A1. Blue drops bleed across the paper grain.

=REPT("💧",MIN(A1,B1))&REPT("🟦",MAX(0,B1-A1))&" bleed"

💧💧💧💧💧🟦🟦🟦🟦🟦 bleed

REPT MIN MAX

Related formula guides

Go deeper with Better Sheets

Members get full courses on CHAR, REPT, and dashboard design, plus hundreds of Google Sheets tutorials. Copy-paste formulas here stay free.

See membership options