Skip to content
What is it?Concatenate lets you put combine multiple values to create custom labels or make sense of your data.
Your answerHintPut the text portion of your heading in quotation marks. Don’t forget a space.Reveal answer
Your answerHintIf you type = in the column, your formula will automatically apply to every row.Reveal answer
Your answerHintRight click on the dropdown menu to see its name.Reveal answer
Your answer
Al ChenAl ChenHintYou’ll use the RowID formula componentReveal answer
Al ChenAl Chen
Your answerHintYou’ll be concatenating the text using quotation marks and the User() formula. Right click the button to update the content.Reveal answer
Your answer:
Al ChenAl ChenHint 1This seems tricky, but you got this! You’ll want to combine a few different column values with some text to make a dynamic message, just like you did in Exercise 2.Hint 2Here’s a sample message: “Good news - Author ‘s doc called Doc title was just published! You can find it in the Category category on the blog.”Reveal answer
Al Chen
Maria Marquis
Thomas HilsAl ChenAl Chen
Nathan Penner
Concatenate Workout Routine
Let's get this workout started!
Exercise 1
Create a heading for the notes from today’s date.
Note from 12/5/2025
Exercise 2
Use Concatenate to create a byline for each article. For example “My great blog by Maria Marquis”
Doc Title
Author
Concatenate
There are no rows in this table
Doc Title
Author
Concatenate
There are no rows in this table
Exercise 3
Create a custom message welcoming the user to your doc and using the adjective from the Adjective select list.
Pick an adjective
awesome
Weclome to the doc Anonymous User, you're awesome!
Exercise 4
Create a blog tagging system that combines the row number with the category and date.
ID
Doc title
Author
Date published
Category
5/26/2020
Al's column
4/28/2020
Al's column
There are no rows in this table
ID
Doc title
Author
Date published
Category
1-5/26/2020-Al's column
5/26/2020
Al's column
4-4/28/2020-Al's column
4/28/2020
Al's column
There are no rows in this table
Exercise 5
Customize the button label so that it includes the person’s name.
Add a task for
Add a task for Anonymous User
@Maria Marquis
Exercise 6
Write a dynamic message to send via the Gmail pack. Add the formula in the "Message” column below. Then, try pushing the button to send yourself an email!
There’s no one correct answer here - come up with your own creative message to send!
Message
Notify
Doc title
Author
Date published
Category
Notify
5/26/2020
Al's column
Notify
4/28/2020
Al's column
There are no rows in this table
Push buttons
Answer
Notify
Doc title
Author
Date published
Category
Good news - Al Chen's doc called was just published! You can find it in the Al's column category on the blog.
Notify
5/26/2020
Al's column
Good news - Maria Marquis's doc called was just published! You can find it in the Launch category on the blog.
Notify
5/21/2020
Launch
Good news - Thomas Hils's doc called was just published! You can find it in the Product category on the blog.
Notify
5/13/2020
Product
Good news - Al Chen's doc called was just published! You can find it in the Al's column category on the blog.
Notify
4/28/2020
Al's column
Good news - Al Chen's doc called was just published! You can find it in the Al's column category on the blog.
Notify
4/15/2020
Al's column
Good news - Nathan Penner's doc called was just published! You can find it in the Launch category on the blog.
Notify
3/26/2020
Launch
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.