Skip to content
Community Solutions Library
Share
Explore

Coda Community Solutions Library

Welcome!
Here you’ll find a collection of community posts that provide solutions to various things you may want to achieve in your doc.
What’s a solution?
All of us will encounter problems when we’re working on a doc. A problem can be something in your doc that’s not working how you want and you want to change, something that’s difficult to achieve, or something that you’re not sure how to achieve at all. Solutions can help us solve problems in our doc.
A solution...
Solves a problem in a doc
Gets you from Point A to Point B
Changes the nature/status of an element in the doc
In a nutshell, a solution is an answer to a problem you want to solve in your doc build.
How do I use this doc?
Have a specific problem you’re trying to solve? You can search the solutions library using the full solutions list below and using the built-in table search. If you want to narrow down your search, you can also use the interactive filters at the top of the table.
This doc is updated periodically, so keep an eye out for new solutions!
For a list of other popular resources, head over to
Question:
Formulas Used:
Keywords:
Area:
Full Solutions List
0
Search
Question
Solution Button
Formulas Used
Search to Text
Keywords
Notes
Area
1
How do I extract the URL from a hyperlink?
Solution
ToText,Split,Filter,RegexMatch
how,do,i,extract,the,url,from,a,hyperlink,remove,link,
remove, link, remove url
Table formulas
2
How do I create line breaks or a new paragraph when I concatenate a message for Slack?
Solution
Concatenate,Character
how,do,i,create,line,breaks,or,a,new,paragraph,when,concatenate,message,for,slack,text,formatting
concatenate, slack, text formatting
Character(10)
Text formatting,Packs
3
How do I randomly select a row with a button?
Solution
Nth,RoundUp,Random,Count
how,do,i,randomly,select,a,row,with,button,random,randomize,pull,up
random, randomize row, select a random row, pull up a random row
Table formulas,Buttons
4
How do I include links with the Trim() formula?
Solution
Trim,Middle,WithName,Split,Find,First,Last
how,do,i,include,links,with,the,trim,formula,url,link,blank,usergenerated,text,hyperlink,hyperlinks,trimming,sentence
url, link, blank, user-generated text with links, hyperlink, hyperlinks, trim text with links, trimming sentence,
Table formulas
5
How do I trigger an automation with a new row? Instead of a row changes, I only want it when new rows are added.
Solution
Created,Modified
how,do,i,trigger,an,automation,with,a,new,row,instead,of,changes,only,want,it,when,rows,are,added,automate,triggered,by,adding,triggering
automate, automation triggered by adding new row, triggering
Automations
6
How do I rank the bottom 10 in a list?
Solution
In,Sort,Slice
how,do,i,rank,the,bottom,10,in,a,list,using,slice,to,limit,rows,view,return,top,n,dynamic,of,last,ten
Using Slice to limit the rows in a view (return Top n rows), dynamic list of last ten
Community post is for the top 10 so you’ll need to flip it. Use True instead of False.
Filtering tables
7
How do I filter groups of rows by the most recent date?
Solution
Filter,Sort,First
how,do,i,filter,groups,of,rows,by,the,most,recent,date,top,max
Filter, recent, top, max
Table formatting,Date/time
8
How can I find the total days allocated for a specific assignee?
Solution
Sequence,FormulaMap
how,can,i,find,the,total,days,allocated,for,a,specific,assignee,unique,count,assignees
Unique, Count, Assignees
Table formulas
9
How can I get a summary of the quantity metric (price, duration, etc.) by the categorization dimension (e.g, category, trade, assignee, label)?
Solution
Lookup
how,can,i,get,a,summary,of,the,quantity,metric,price,duration,etc,by,categorization,dimension,eg,category,trade,assignee,label,rollup,summaries,reverse,lookup
Summary, Rollup, Summaries, Reverse Lookup
Table formulas,Math
10
How can I find all of the possible unique combinations in a set of data?
Solution
Product,Rank,RoundUp,Count
how,can,i,find,all,of,the,possible,unique,combinations,in,a,set,data,generate
Set, Combinations, Unique, Generate
Table formulas
11
How can I group items individually from a multi-select list?
Solution
Filter
how,can,i,group,items,individually,from,a,multiselect,list,grouping,selection,multiple,select
Grouping, Selection, Multiple, Select
Grouping,Select lists
12
How can I separate multiple bullet list items into many different rows?
Solution
Split,Character,FormulaMap,AddRow
how,can,i,separate,multiple,bullet,list,items,into,many,different,rows,check
Check list, bullet list, separate, many rows
Lists,Text formatting
13
How do I find the difference between two lists?
Solution
Contains,In
how,do,i,find,the,difference,between,two,lists
Difference, Lists, Find
Table formulas,Lists
14
How can I use a wildcard character in a filter to broaden searches?
Solution
Find
how,can,i,use,a,wildcard,character,in,filter,to,broaden,searches,filtering,wild,card,,search
Filter, Filtering, Wild Card, *, Search
Search
15
How can I reference the previous row in a particular table. (By date, rowID(), or in a view?
Solution
RowId,PreviousRow
how,can,i,reference,the,previous,row,in,a,particular,table,by,date,rowid,or,view,find
Find, Previous, Row, Date, Row Reference, RowID
Table formulas
16
How can I send an automation reminder based on a piece of data in a table? (for example, based on time in date cells.)
Solution
how,can,i,send,an,automation,reminder,based,on,a,piece,of,data,in,table,for,example,time,date,cells
automation, reminder, time based
Automations
17
How can I create a single-cell formula?
Solution
Sum,Filter
how,can,i,create,a,singlecell,formula,single,cell
single cell formula, single cell
Cell formulas
18
How can I reference the currently selected card in a formula?
Solution
how,can,i,reference,the,currently,selected,card,in,a,formula,row,current,view
Selected Row, Current Row, Current Card, Selected Card, Card View
Cell formulas,Cards
19
How can I set global variables in a doc?
Solution
Value
how,can,i,set,global,variables,in,a,doc
Global variables
Table formulas
20
How can I run actions on just a specific subset of rows?
Solution
RunActions
how,can,i,run,actions,on,just,a,specific,subset,of,rows,runactions,formula,button,multiple
RunActions(), formula, button, multiple, rows, actions
Table formulas
21
How can I find all of the rows between two dates?
Solution
Sequence,FormulaMap,Unique
how,can,i,find,all,of,the,rows,between,two,dates,months,count,date,math
months, count, date math
Date/time,Table formulas
22
How do I limit a table to show only the top N rows?
Solution
Slice,In
how,do,i,limit,a,table,to,show,only,the,top,n,rows,x
Top rows, top x, top n
Rows,Filtering tables
23
How can I make a table of unique lookup values?
Solution
ListCombine,Unique
how,can,i,make,a,table,of,unique,lookup,values
Unique lookup
Lookups
24
How can I filter a table by date?
Solution
Filter,Today
how,can,i,filter,a,table,by,date
date, filter
Date/time,Filtering tables
25
How can I replicate Excel’s Vlookup in Coda?
Solution
how,can,i,replicate,excels,vlookup,in,coda,excel
excel, vlookup
Lookups
26
How can I select a random row from a table?
Solution
Sort
how,can,i,select,a,random,row,from,table
random, row, select
Table formulas
27
How can I reverse a string with a formula?
Solution
Trim,FormulaMap
how,can,i,reverse,a,string,with,formula
String, Formula, Reverse
Table formulas
28
How can I calculate the week of a month?
Solution
Day
how,can,i,calculate,the,week,of,a,month
week of month
Date/time
29
How can I calculate the last working day of the month?
Solution
Month,Today,If
how,can,i,calculate,the,last,working,day,of,month
working day, last, month
Date/time
30
How can I create a log of changes made to data in a table?
Solution
Filter,Sort
how,can,i,create,a,log,of,changes,made,to,data,in,table,history,backup,record
history, log, backup, record
Table formulas
31
How can I create a schedule table?
Solution
how,can,i,create,a,schedule,table,dates,weekdays,scheduler
dates, weekdays, scheduler
Date/time
32
How can I add rows to a cross-doc with a button?
Solution
AddRow
how,can,i,add,rows,to,a,crossdoc,with,button,action
cross-doc, action, button
Cross-doc,Buttons
33
How can I group dates by week?
Solution
SwitchIf,ListCombine
how,can,i,group,dates,by,week,weekdays,thisweek,nextweek
dates, weekdays, thisweek, nextweek
Date/time
34
How can I display columns of a table as indented items on bulleted lists?
Solution
FormulaMap,BulletedList
how,can,i,display,columns,of,a,table,as,indented,items,on,bulleted,lists,bulletlist,nested,formulamap,
BulletList(), Nested, FormulaMap()
Lists
35
How can I limit the number of votes each person can cast in the voting template?
Solution
how,can,i,limit,the,number,of,votes,each,person,cast,in,voting,template
Voting
Table formatting
36
How can I keep a Google Calendar in sync with a calendar view in my doc ?
Solution
how,can,i,keep,a,google,calendar,in,sync,with,view,my,doc,,packs
Google Calendar, calendar, packs
Packs
37
How can I send an email from a table?
Solution
Concatenate
how,can,i,send,an,email,from,a,table
Email
Table formulas,Packs
38
How can I open a row with a button?
Solution
Concatenate
how,can,i,open,a,row,with,button,buttons
Buttons
Buttons
39
How can I highlight duplicates in a column?
Solution
Filter
how,can,i,highlight,duplicates,in,a,column
Duplicates
Specifically finding duplicates using conditional formatting
Conditional formatting
40
How can I make a horizontal rule?
Solution
Rectangle
how,can,i,make,a,horizontal,rule,formatting
Formatting
Table formatting
41
How can I create colorful status indicators?
Solution
how,can,i,create,colorful,status,indicators,conditional,formatting
Conditional formatting
Conditional formatting
42
How can I just see today’s rows?
Solution
Days,Created
how,can,i,just,see,todays,rows,date,time,data,entry
Date, Time, Data entry
Date/time
43
How can I make a custom sort order?
Solution
how,can,i,make,a,custom,sort,order,
Table formatting
44
How can I create a table from a pre-existing list?
Solution
how,can,i,create,a,table,from,preexisting,list,lookups
Lookups
Lookups,Lists
45
How can I set up a column with a running sum?
Solution
Filter,Sum
how,can,i,set,up,a,column,with,running,sum,calculations
Calculations
This community post also has some ideas: https://community.coda.io/t/running-total-sum-average-median-etc/752/11
Math
46
How can I set up one button to take multiple actions?
Solution
RunActions
how,can,i,set,up,one,button,to,take,multiple,actions,buttons
Buttons
Buttons
47
How can I set up consecutive row numbers?
Solution
Rank
how,can,i,set,up,consecutive,row,numbers,sort
Sort
Table formulas
48
How can I lookup from another table?
Solution
Lookup
how,can,i,lookup,from,another,table,lookups
Lookups
Lookups
49
How can I set a column to display as subtext in list selector in detail view?
Solution
how,can,i,set,a,column,to,display,as,subtext,in,list,selector,detail,view,formatting
Formatting
Table formatting
50
What’s the right/easiest way to get a canvas column in a table to be a template?
Solution
whats,the,righteasiest,way,to,get,a,canvas,column,in,table,be,template,subpages
Canvas column, subpages
Table formatting
51
How can I merge two docs or copy one doc into another?
Solution
how,can,i,merge,two,docs,or,copy,one,doc,into,another
Copy, merge
Doc settings
52
How can I make a text control box to search a table?
Solution
If,Filter
how,can,i,make,a,text,control,box,to,search,table
Text, search, control box
Search
53
How can I use the barcode pack?
Solution
how,can,i,use,the,barcode,pack
Barcode
Packs
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.