-
If checkbox is checked select this option from dropdown list
Does anyone know how to write this formula correctly? Basically, I've got a "completed" column that is a check box column. I've got a "priority" dropdown column with several different levels of priority includeing "none" so that I can sort my reports via priority. I would like the priority column to go "none" when I check…
-
Looking for input
I am new to SS. Looking to see if the following scenario is do-able: We are a small catering company, where interdepartmental communication is not consistently accurate enough for the volume we are capable of producing. SO, if I have (for ex.) 6 events in one day, 2 at lunch and 4 at dinner time, I need the prep guys to…
-
User sees only empty report sheet
Dear all I have created a report from a task list that shows only the tasks owned by a specific user. That user is not a licensed user but I shared the report with him and assigned Editor rights. When he opens the report link, he sees no entries but only the column headers. What did I miss? Any suggestions would be welcome…
-
Fixed duration in the Gantt chart
Hi all, I'm evaluating duration time of every tasks. In the sheet, I set a duration time, a start date and the end date is adjusted accordly. If I want to change the start date, the end date will be updated and vice-versa. It's fine. However, in the Gantt chart, when I'm touch a gantt bar to change the task start, it's…
-
Conditional Formatting
I have a question that someone may be able to help me with. If I have a column called Finish Date. On line 5 - I enter a date that my customer wants project to be finished On line 4 - I have a automatic date that is from a predecesor based on finish date so that it populates automatically depending on the tasks completed…
-
Group Management and Admin Rights
Hi, I am the admin on our enterprise account. I just set up some groups for one of the retail departments but it looks like I can't transfer group ownership to anyone else in the group unless they have admin rights. I obviously don't want to give admin rights to anymore people but I also don't want to own all these groups.…
-
Count of multiple values
Hi I'm workng on a risk log template and want to summarise the number of red risks (score 20), amber risks (score 15-19), number of yellow risks (score 10-14) and the number of gree risks (score <10). I thought I could use a COUNTIFS statement but I can only get it working to count all of just ONE value (example: 12).…
-
Coordinating multiple projects and sharing sensitive documents selectively
I have 5 vendors working on a project. All five vendors have tasks which are significant projects in their onw right. There are interdenpendencies. I want to coordinate the project in a way that there is one gantt chart for the overall project which all vendors and their teams can see, their project managers can edit and…
-
Getting RowID in a sheet?
Is there a way to get the rowid for a different row for a comment. I have a schedule with a delay of 3d because of something external to the project. In the Predecesor column I have 23FS+3d because of the delay after completing the task on row 23. I would like a comment ="This is delayed because of (reason) after…
-
Webform copy for someone other than the creator
The help center states "there isn't a way to have the web form confirmation email sent to the sheet owner or collaborators," however,the collaborator would like to an email that looks like the form and not a Notification which looks like the sheet. His reasoning is that he wants to print the webform which is vertical and…
