[email protected]’s Profile

Community member since May 2017

Project Management
Area of expertise
Project Management


I want to limit the number of characters that a requester can enter into a cell via a form. The use case is that the user is entering a new request for consideration into an Intake Form. In assigning a name to their project request, we want to limit them to no more than 25 characters, based on


Hi everyone,

I need help on the below formula. I am trying to get the number of active projects based on the columns Section and Stage (see attached image).

The 2 sections are called Food and Non-Food.

The active stages are called Planning, Strategy Decision, Tender, Evaluation and Contract. Other


I am trying to work out the average number of days quotes are being taken to be submitted.


The columns i am working with are Enquiry Date and Date Quote Submitted.


I have done a Sum formula to count the number of days taken (=SUM[Date Quote Submitted]1 - Enquiry Date]1


but because not every


Hi, I hope someone can help me with this.

What I'm trying to do is find a way to automatically share some information from a sheet into another. For instance, I want to have a sheet with all the relevant information for the company's projects, including financial information. Then have another sheet