JPJPJP✭

Thanks for the suggestion! So just to clarify, there's no built in way to summarize dates like this using Reports or Dashboards? Both Excel and Google Sheets can do this easily, so it's strange such as simple task can't be done without yet another helper column in addition to all the other helper columns I had to add for…

Yayy! This helps with part of my requirements. Can you please also add the ability to insert pictures/gifs into the form? I sometimes have questionnaires that require a visual component to refer to beside the question. So this would be amazing if possible. I've submitted feedback for this as well.

Awesome do you have an example, or formula, or a link to some documentation on how to do that? I can't seem to figure out how to update/increment the value in the helper sheet.

Thanks @Andrée Starå @Paul Newcome @Maaik Meijerink ! Sorry for the confusion. I don't know why I thought the AutoNumbers shifted! I just tested it, and you're right. They only shift when you manually reset the column it seems, so in this case a helper sheet wouldn't be needed... phew!! Thanks for clarification!

Ah - so you're saying even if the say there's 20 items, and the last item gets deleted/moved. The next row will still be #21? The only way the numbers shift is if the AutoNumber is manually refreshed?

Hi Andre, Curious - how do I implement that button you mentioned? I just submitted the product enhancement request.

Sorry for the delay in response. Unfortunately Control Center is not an option for us. Question - I noticed there's a 100,000 cell limit for cross-sheet formulas. Is that per sheet or per account? Here's my thoughts on the process, do you think this is do-able? Intake form sends ALL fields to "Intake" sheet An approval…

Question - The post says "supports up to ~2,300 tasks"... what happens after that count? This numbering format is exactly what I was looking for, I'd like to use it for our project tracker which includes the deliverables as sub-items. There's thousands of projects in the tracker sheet and many deliverables under each one,…

No worries! Lol.... I'd love to see this solution if you're willing to share it. The more inspiration the better!

Thank you, Paul! You're correct. That's actually what I was trying last night, and seems to work. It's just a bit annoying, because I don't want these long descriptions for each deliverable type in my cleanly formatted project tracker sheet. I would love if I can have one 'intake' sheet and one 'tracker' sheet, but they…