-
% Complete Formula based on Start/Finish Dates
Hello! I am in need of help writing a formula to auto-calculate the "% Complete" column based on the "Start" column date and "Finish" column date. Additionally, I also have an auto column for "Duration". The goal is to have the % Complete auto calculate based on the today's date in relation to the start and finish date…
-
Returning entire row
I want to Pull Data from a sheet name (Daily Sales Sheet) to another sheet (Payable). This is the entire row from Daily Sales Sheet. In (Daily Sales Sheet) there is a column by the name of payment method. If any cell in column marked as Payable, that entire row having customer name, service and other details should reflect…
-
IF Statement with cell either blank or with any date
Hi everyone Please can you assist me with correcting this formula? I have a column 1st queries received that is locked to dates only. This formula is for the health status column. If the deadline is in the future, then the health status must be blank. If the deadline is in the past, the received date is blank, and the…
-
Why does my chart widget display a different numeric percentage scale on different phones?
We use dashboards extensively with remote teams. Most people have no problem accessing and seeing information correctly on the mobile app. I have one person, the President, that see the numeric percentage scale differently on his phone. No problem on his desktop and I'm not aware of anyone else having this issue. I have…
-
IF Formula for task row containing mini tasks in columns in order from left to right
I have a document that is setup per client as the primary column. Each client row represents a task to complete audited financials each year for each client. Each column from left to right represents a sub-task during the audit process outlined below. I have setup each column to use conditional formatting to change the…
-
Unparseable
Hi, I'm trying assign a number to the $ symbol. I'm using this formula: =IF(6_state_$ = "Empty", 0, 6_state_$ = "One", 1, IF(6_state_$ = "Two", 2, IF(6_state_$ = "Three", 3, IF(6_state_$ = "Four", 4, IF(6_state_$ = "Five", 5, 0)))))) But it comes back with unparseable. What am I doing wrong? Thank you in advance!
-
Multiple conditions with IF and PARENT ()
Trying to get multiple conditions working with IF + PARENT () If formula works when it's used alone. =IF(Type@row = "task", "") -> Works =IF(Type@row = "subtask", PARENT(ID@row)) -> Works However, when I tried to combine the formula, it returns UNPARSEARBLE. =IF(Type@row = "task", ""), if(type@row="subtask",…
-
COUNTIFS criteria including dates after X
I'm trying to create a formula that counts the number of entries submitted to a separate sheet per person completed since a specific date (3/24/2020). My formula that works for counting all entries by individual is =COUNTIF({Other Sheet Range1}, [Member Name]1) but when I try adding the AND {Other Sheet Range2}…
-
Formula to reference one column based on entries from another column.
I need help on a formula for Project Assignment when a dollar amount is what determines who gets a Project assignment. For example, A Facilities coordinator will get a project if it falls between $5k - $24,999 Project Manager A will get a project if it falls between $25k and $99,999 Project Manager B will get a project if…
-
Designate top or bottom of sheet when a row is copied or moved to another sheet
Can I designate where the row goes when it is moved?