At our company, we run 2-week long sprints, but we still meet weekly as a team to review our individual and team objectives and we use two different pages built with Coda to:
Gather information from each team member.
Present that information during the meeting.
In the presentation page, we only want to display a specific table of “lessons learned during last sprint” only if it is the beginning of the sprint. Otherwise, we don’t want that information to appear in the page at all.
Ideally, we could use an IF operator to choose to display a table only under certain conditions.
We don’t currently support formulaically displaying tables, but one thing you could do is experiment with the BulletedList() formula to show the table as a list.
Here’s an example. In this case, I just used a checkbox to control whether it’s the beginning of the sprint, but you could use another condition (such as comparing the sprint date to Today()).
I came up with a beautiful and horrible hack to add on to @oleg’s suggestion. Use Bulleted List in conjuction with FormulaMap, Hyperlink, and concatenation to construct a string for each row. While this doesn’t let you edit a row inline, it does give each row a hyperlink back to its source:
This is a really creative solution! I am not able to get the hyperlink to work when using thisRow in the formula. When you say it’s “hyperlnked,” are you saying each value in the bulleted list links back to the row in the table (like a @reference)? The URLs in the list are empty for me .
Another hack is to add a 3rd column that basically concatenates the first two columns. So my “concatString” column’s formula is =col1 + ' | ' + col2' and is set as the Display Column for the table. Then a bulleted list will allow you to see all the row’s attributes and reference the underlying row: