Skip to content
Formula Fitness | ListCombine
Welcome to Formula Fitness!
ListCombine Workout Routine
Data
More
Share
Explore

icon picker
ListCombine Workout Routine

Let's get this workout started!
What is it?
List - Creates a list
ListCombine - Creates one unified list
When to use it?
When you need to change the data type to be a list
When you need to join lists together
When you have a list of lists

Exercise 1

You want to know how many items of
@Outerwear
⁠
were sold.
Your answer:
Reveal Answer
⁠
15
⁠
⁠

Exercise 2

You want to know all of the unique items that were sold this month.
Your answer:
Reveal answer
⁠
Jumpsuits & Rompers Outerwear Shoes Headbands Swimwear Dresses
⁠
⁠

Exercise 3

You want to create a select list that has both the
Bundles
⁠
and
Products
⁠
as options.
Your answer:
Date
Items sold
1
5/3/2021
​
2
4/26/2021
​
3
4/28/2021
​
There are no rows in this table
⁠

Reveal answer

Date
Items sold
1
5/3/2021
Back to School
Headbands
Outerwear
Dresses
Fancy Dress
2
4/26/2021
​
3
4/28/2021
​
There are no rows in this table
⁠

Exercise 4

You want to generate sale prices for every bundle and product you have. You’re going to offer 20% off.
Your answer:
Reveal answer
⁠
⁠
$36.00⁠
⁠
⁠
$36.80⁠
⁠
⁠
$16.80⁠
⁠
⁠
$4.00⁠
⁠
⁠
$0.80⁠
⁠
⁠
$8.00⁠
⁠
⁠
$16.00⁠
⁠
⁠
$12.00⁠
⁠
⁠
$4.00⁠
⁠
⁠
$8.00⁠
⁠
⁠
⁠

Exercise 5

You have a table where people can choose which shift they want to pick. You have a morning and an evening shift, and want the column to automatically have both shift options listed.
Your answer:
Shifts
0
Day
Time
Person
1
Mon
​
MM
Maria Marquis
2
Tues
​
MM
Maria Marquis
3
Weds
​
MM
Maria Marquis
4
Thurs
​
MM
Maria Marquis
5
Fri
​
MM
Maria Marquis
There are no rows in this table
⁠
Reveal Answer

Shifts Answer
0
Day
Time
Person
1
Mon
​
Melanie Heyside
2
Tues
​
MM
Maria Marquis
3
Weds
​
MM
Maria Marquis
4
Thurs
​
MM
Maria Marquis
5
Fri
​
MM
Maria Marquis
There are no rows in this table
⁠



Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.