-
Anyone having issues with Outllok app uploading attachments that are NOT checkmarked?
I submitted an email to support yesterday but have not heard back. I'm having an issue where I uncheck attachments I do not want to upload to SS and it's ignored and uploaded anyway. I then go into SS and delete those attachments. For a lengthy email chain, there could be a lot of jpg's from signatures that do not need to…
-
Help automating sharing
I was wondering if there was any way to automate sharing when planning schedules. I have a sheet that has multiple tasks on it, however I only want to share it to the people I assign said tasks to. Rather than having to assign the task and then having to share the sheet individually to every person on the assigned column…
-
Need to set a date with formula whenever new task is entered
Hi. Among the other columns i have 2 columns named "Task Name" and "Start Date". What i would like to create now, is whenever new line is entered to "Task Name", the current date will appear automatically to "Start Date" row and date should remain as date when task was entered. I tried following: =IF([Task Name]5 > "0";…
-
Manpower Tracking with Projects
I am trying to set up a way to track manpower 50+ people plus projects that are ongoing. 2 separate sheets are fine - 1 project summary and 1 manpower. How can i set it up, that i can see who is available, when workers will be on vacation and it will notify is someone is booked for one project so i can't double book them.…
-
Report not updating when adding new sheet
I have a report tracking all new sheets when added to the folder in my workspace. The report does not recognize this new sheet and I have to manually go into every report (many) to add it to the sheet list. Is this an error in the workspace interface or am I missing a checkbox somewhere?
-
I need both dependencies and predecessors
I have used the predecessor column and love it but I need to also have a dependency column. For instance if I have task 1, 2, and 3 and 3 has a predecessor of 2 and 2 has a predecessor of 1 then I want to know that 2 has a dependency of 3. Knowing the predecessor only tells me what needs to be completed before the task. I…
-
Averages
Hello all. Thank you for any help you can provide. I have 5 fields containing averaged numbers. I want to roll them all into 1 field to show the average for that specialty. Anyone know of the right formula to use? In English, I have the average for 5 counties for primary care clinics and want just 1 average for the…
-
More functionality for for rules
The rules feature is nice but it is very limited and only allows to change things from different fonts, colors, strikeouts, etc. I would like a rule that allowed more detailed changes. For example, if column a says completed, changed column L to 100%. There are many different scenarios. We are unable to use the…
-
Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
-
IF And
Good Day, I need so assistance, I am trying to do the following I want to change my Project stoplight Status Column (RYGB ball) to yellow if the following condition is met if my "# of Days" column is > 138 and my "% Complete" column is < 50% Here is my If condition - =IF(AND(([# of Days]2 > 138, ([% Complete]2 < 50)),…