-
How can I create a NETWORKDAYS formula that results in a blank field until an End Date is specified?
I need a column to show =NETWORKDAYS(([Start Date]@row), ([End Date]@row)), but currently the rows where End Date is blank are returning #INVALID DATA TYPE in my formula field. I would like it remain blank until an End Date value is entered. =IF(NOT(ISBLANK([End Date]@row)), "Not Blank", "") returns the expected result.…
-
What is WORKDAY formula with SLA built in
Hello, I'm seeking a way to add in a formula that runs left to right. When a start date is added to kick off a set of activities, the cells on that line calculate +2 days (what I'm calling SLA date/ service level agreement date) AND also makes the date a WORKDAY (no weekends or holidays). Thank you so much
-
Help with formula that wont run
Hello everyone! This simple formula is driving me nuts =SUMIF([Is this before today?]@row, "Yes", ([Actual]@row-[Actual Cumul]1), "",) This keeps returning an #UNPARSEABLE error I'm trying to get an answer for simple sum If the current column (is this before today) is yes. Then subtract the "actual" value from the previous…
-
using a date value in a text column changes sometimes from German to US format
Hi all, I have a date column and I am using the locale for germany. The date column shows e.g.: 09.08.22 I use this in a text column like: ="some text " + date@row@rowanelizabeth The result is sometimes "some text 09.08.22" and sometimes "some text 08/09/22" What should I do, that always the german date format is used in…
-
Schedule Variance
How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.
-
Count Compliant Status Reporting
Hello Community, I am pretty stumped on this one; I want to count the number of rows (projects) that are in and out of compliance for their status reporting ("Status Date") based on their project stage ("Project Stage") as different items in the Sheet Summary. Currently, "Project Stage" has multiple possible stages, but…
-
Out of Practice, Need 2 Variable Flag (At Risk) Help
I haven't been a good girl practicing my formulas. Everything I've tried is coming up Uparseable. What I'd like to do: Red Flag when "Expected Completion Date" is within 5, days, or in the past, and "Current Status" does NOT equal "Complete". I'm feeling pretty silly that I've spent so much time trying to get this to work.…
-
INDEX MATCH formula - not working
-
How to Add Specific Field into Form with SUBSTITUTE Formula
Hey Community, I am trying to have my OPPTY # field prepopulated in my form using the SUBSTITUTE formula because a lot of our users tend to enter it incorrectly. Can you please help me figure out how to solve this? I will paste a screenshot of the format below.
-
Need to calculate number of days but only if there's an entry in both cells.
Hello, I have a formula to calculate the number of days between two cells (Date Filed and Date Resolved) but can't figure out a way to keep the #InvalidDataType message from showing if the matter is still open and there's no entry for Date Resolved yet. You can ignore column 10 in the image. That's just me messing around…
