-
If a cell does not contain a period
Looking for the syntax for if a cell does not contain . (a period) This is not working =IF([Work #]1 <> "*.*", "No", "Yes")
-
Copy INTO a sheet?
I know it's possible with the workflow to conditionally copy or move rows to another sheet. I'm wondering if it is possible to copy rows INTO the same sheet, FROM another sheet, based on a condition. I can't see any way to do this with a workflow. Functionally, what I'm trying to do is add a bunch of sub-tasks to a task…
-
Time calculation formula using an IF variable
I am trying to write a formula that counts the number of days we left to finish specific work cases. The end result that I'm trying to calculate is the number of days remaining to work a second level case based on two variables: 1.) how much time is allowed for a specific case type, and 2.) how much time was exhausted…
-
Formula help
Hi Everyone I am having some difficulties with trying to pull some data. Background of the formula is I am looking to see how much a certain individual spent in 2019 on agencies. I am using the following formula =SUMIFS([Annie Direct]:[Annie Direct] "Patrick Madsen",[Year]:[Year], "2019", [Payment Amount]:[Payment…
-
Nested VLOOKUP statement error
I am receiving an error with the following nested VLOOKUP statement. I've included an image that might help to better explain. Unfortunately, I have looked at this so many times and tried so many combinations that I'm afraid it is a simple fix that I am just not seeing. Need to use the number in Details4 cell (in this case…
-
Contact Formatted Cell --> Autopopulate Info into another cell.
How can I get a cell that is formatted as a Contact List to populate a cell to the right with a phone number, email, or other static attribute when a select different contacts? Our assigned to items can change quite frequently, and it would be great to autocomplete contact info in the next cell automatically. Thanks.
-
Baseline/Actual Schedule formula help
Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them…
-
Referencing a Report in a VLOOKUP
I've read numerous times that we can reference a VLOOKUP in a sheet from a Report, I'm trying to figure out how =IF(ISERROR(VLOOKUP(Address28, {Customer ID Consol Report}Primary1:[Customer ID]1))) Any assistance?
-
RYGG based on dates and complete check box with blanks
Hi there, I have had success with most of this equation, the part that is stumping me is that I want to have the health status turn "Gray" if there is no "Finish" date to indicate that it has not yet been started/not yet being worked on. I have the other colors to be set to work respectively with the "Finish" date and the…
-
Returning INVALID DATA TYPE - Definitely shouldn't be
Hello - This one has got me pulling my hair out. This USED to work. NOTHING has changed. =SUMIFS({WAP Total}, {WAP Date}, MONTH(@cell) = MONTH(TODAY())) Returns #INVALID DATA TYPE But... it's not. WAP Date is DEFINITELY a date data type and =SUMIFS({WAP Total}, {WAP Date}, @cell = TODAY()) works just fine... This formula…