Community

Not easy to relay what i'm trying to do here... 

I'm trying to establish a resource requirement list. We have 13 resources available for 4 categories. 

Right now, I have each category set to cap at 13 resources based on volume per category(this can happen as these are fed via a separate

Any one know if we can set auto email comments, instead of manually email comment? Thanks in advanced!

Hi,

Please need your help on the below formula.

As you can see on the image below, the stage column is set up as a dropdown list. I wanted to get a formula that says, if the project owner decided to close the project at a certain stage (these are the subtasks) because of any of the listed reasons,

Some of my admins of certain sheets cannot send rows to other sheets that they are also admins of. Anyone else have this problem? (yesterday it was

I am looking to use a form to make multiple entries into a sheet without the form going away once I hit submit, e.g., I should be able to fill an entire spreadsheet of tasks from one form. Thanks D A

Hi again,

Please need your help to correct my formula below. I wanted to count the number of projects that are due to start 14 days based on planned start dates but I am getting "Incorrect Argument Set" error.

Please don't get confused with the formula. The projects I created have 5 subtasks and as

I am looking to set up a notification once everything in a specific column has been check marked.  Basically I have 10 things that need to be collected by someone every week, they are listed in rows in the sheet and have a checkbox next to them to check once the item is collected.  I want a

For each of our sheets, we use a "Health Status" of Red, Yellow, Green to indicate how that task is going. I would like to create a report which looks across all sheets and simply counts up the total number of tasks which are Red or Yellow. I can easily create the report which shows the list of

A client filled out a form and said it would not submit. She checked all her info and it still would not submit. I tried it once with an upload and once without and it worked and had one other person check it and it was fine. 

Anyone ever come across this issue of forms not submitting?

I am trying to create a formula to check a box in one column if a date in another column is greater than a specific date. 

Here is what I have, that is not working: 

=IF(ISDATE([Estimated Close Date]1), IF(AND([Estimated Close Date]1 = >DATE(2018, 6, 1), 1)))

Estimated Close Date is a date column.