-
Re: Limit to Dropdown values?
Hi, I recently tested the limit and it is 20,000 exactly setting the dropdown options using the API.1 · -
Re: How to have a Date and Time format for Date Column Properties?
Interestingly I have seen that date type columns do indeed contain date/time data however it can only be exposed via the API. We could take the dates from a critical path with minute duration values …5 · -
Re: Project Management - How do I create a recurring task within a project task list?
@jennifer blow That's is the theme of my solution as well. In addition I used a MAX(COLLECT()) function to find the last completed task on the 2nd sheet. -Jeremiah1 · -
Re: Project Management - How do I create a recurring task within a project task list?
@Ger Thor Here's a google doc describing the solution. You can request access to the workspace.3 · -
Re: Project Management - How do I create a recurring task within a project task list?
Hey @Mindy Friedman! Two Methods: 1 Sheet (Formula Method) This method assumes the frequency is consistent regardless of the last occurrence. We used an array of date formulas to have recurring tasks…4 ·