So is there any future prospect of these limitations being lifted for Timeline View? Timeline view limitations Not available for reports Can’t embed it on dashboards Timeline view is useful, but would…
OK, so I have a problem that I cant solve. I have a sheet that (in the example) lists students and their assessment dates. I have a column for student name, then columns for each assessment dates. I w…
I've been getting frustrated by cross sheet references recently. The other day I added cross sheet references I knew existed into a new formula in a cell only to get the INVALID REF# error. I went int…
So I've set of a project template, comprising a project schedule and project cost tracking. In the project cost tracking solution there is a budget & cost tracking sheet, an invoices sheet and a cost …
OK, looking for some inventive ideas here. I have a budget sheet and a schedule sheet with a copy row automation, obviously this just copies to the bottom of the sheet, then I need to move each row ma…
And it really annoys me. Wasted four hours of my life today on a simple INDEX(MATCH()) for no reason. Here is my source sheet: Here is my destination sheet: Here is my cross sheet formula: =INDEX({JOB…
OK, so I have three sheets, A job sheet A cost sheet An quote data sheet (which imports from Xero via a Zap). In the job and cost sheet I'm interested in recording the quote no. In the quote number co…
Here it is, Seemingly simple, but never runs, I cant understand why. FYI... INT is a checkbox column which is formula based, referencing another sheet. Essentially once two interviewers complete an in…
Anybody have a clue about this one? 2x sheets with matching 'retailer' columns, for some reason there are two retailer fields in the report, not one. Any ideas? Adam.