-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
-
If cell is empty or blank,
Hi, I have currently formulated the following formula, =IF([Days (Difference Forecast - Baseline)]1 <= 5, "Green", IF(AND([Days (Difference Forecast - Baseline)]1 > 5, [Days (Difference Forecast - Baseline)]1 <= 10), "Amber", "Red")) which is working efficiently, but problem occurs when the cell is empty, and it show me…
-
Resource allocation not matching project sheet allocation
A member of my team is allocated resource on a project. The issue is that although they are only allocated to 85% on this project/task, it is showing as 100% in my resource view. I only have view access to the sheet and cant change that but am confused as to why this would be doing this
-
COUNTIFS a range with multiple assigned groups
Hello all, I am trying to COUNTIF a range that includes multiple assigned groups in some cells. I would like to count rows that include "Dept 1". There is one row in particular that contains two assigned groups - "Dept 1" and "Dept 2" - that is not being counted This is my formula: =COUNTIF({Sheet Range 4 - Department},…
-
RAG Status - Formula
Hi, I have currently formulated the following formula, =IF([% Committed to Date]1 - [Project Status %]1 < 0.25, "Green", IF(AND([% Committed to Date]1 - [Project Status %]1 >= 0.25, [% Committed to Date]1 - [Project Status %]1 <= 0.75), "Amber", "Red")) which is working efficiently, but problem occurs it shows me the…
-
OpenSSL.SSL.Error: [('SSL routines', 'ssl3_read_bytes', 'sslv3 alert handshake failure')]
Please advise: Traceback (most recent call last): File "/opt/venv/sheetconnector35/lib/python3.5/site-packages/urllib3/contrib/pyopenssl.py", line 441, in wrap_socket cnx.do_handshake() File "/opt/venv/sheetconnector35/lib/python3.5/site-packages/OpenSSL/SSL.py", line 1716, in do_handshake self._raise_ssl_error(self._ssl,…
-
Deactivate temporarly all "Alerts & Actions"
Hi all, i need to make some updates on my spreadsheets, that were not made on due time. But i don't want to confuse people by triggering notifications and alerts of actions already completed. Is there any way of deactivating all the "Alerts & Actions" at the same time, and then activating them again as soon as i got…
-
Counting and applying "color status" for parent/children rows
I have overall Annual goals (purple lines) with sub projects that fall into a particular category. I then have subtasks that fall under the corresponding item (identified with an alphanumeric task number). I want to be able to summarize (on a dashboard) a couple of things: the task health of the project level (task 25 with…
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Card view - How to decide the "fastview" Columns?
Hi! When you go into card view and look at a card. You see the "Main collumn" as the card name but you also see 4 more columns without going into "edit". How do I decide what columns should be shown ON the card in card view? Kind Regards// Hugo Martinwall