Community Solutions Library

Explore

Coda Community Solutions Library
Coda Community Solutions Library

Welcome!

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

Resources⁠

⁠

Question:

⁠

Formulas Used:

⁠

Keywords:

⁠

Area:

⁠

Full Solutions List

Full Solutions List

Question

Solution Button

Formulas Used

Search to Text

Keywords

Notes

Area

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

How can I set global variables in a doc?

Solution

Value

how,can,i,set,global,variables,in,a,doc

Global variables

Table formulas

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

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

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

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

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

How can I replicate Excel’s Vlookup in Coda?

Solution

how,can,i,replicate,excels,vlookup,in,coda,excel

excel, vlookup

Lookups

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

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

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

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

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

How can I create a schedule table?

Solution

how,can,i,create,a,schedule,table,dates,weekdays,scheduler

dates, weekdays, scheduler

Date/time

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

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

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

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

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

How can I send an email from a table?

Solution

Concatenate

how,can,i,send,an,email,from,a,table

Table formulas,Packs

How can I open a row with a button?

Solution

Concatenate

how,can,i,open,a,row,with,button,buttons

Buttons

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

How can I make a horizontal rule?

Solution

Rectangle

how,can,i,make,a,horizontal,rule,formatting

Formatting

Table formatting

How can I create colorful status indicators?

Solution

how,can,i,create,colorful,status,indicators,conditional,formatting

Conditional formatting

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

How can I make a custom sort order?

Solution

how,can,i,make,a,custom,sort,order,

Table formatting

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

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

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

How can I set up consecutive row numbers?

Solution

Rank

how,can,i,set,up,consecutive,row,numbers,sort

Sort

Table formulas

How can I lookup from another table?

Solution

Lookup

how,can,i,lookup,from,another,table,lookups

Lookups

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

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

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

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

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.

Coda Community Solutions LibraryCoda Community Solutions Library

What’s a solution?

How do I use this doc?

Coda Community Solutions Library
Coda Community Solutions Library