-
Multiple criteria
Hi community! i need your help, I need to get a number based if the formula find match with multiple criteria in different rows. How can I get the result in the left side (yellow field) from the information on the right hand??? Thanks in advance!!!
-
IF function
Hi, I have the below formula but it is not working. Can you see where I'm going wrong? =IF([(Fuel Expense) Fuel Type]@row="Unleaded Petrol (£0.25 per mile)","0.25",IF([(Fuel Expense) Fuel Type]@row="Diesel (£0.45 per mile)",0.45",IF([(Fuel Expense) Fuel Type]@row="Electricity (£0.10 per mile)","0.10"))) Column B needs to…
-
Need to return a Sum when multiple criteria are met in a referenced sheet
=COUNTIF({Sprint Name}, "Ocean's Sprint 5", AND({Ocean's 13 Sprints Issue Type}, "Story")) I'm using the value above, but am getting an Incorrect Argument Set error.
-
Embed a map from Mapline?
Dear Community, I am trying to embed a map from Mapline into my dashboard. I have the embed code, and I tested other codes from Google Maps, and they work, but for some reason, the code from Mapline doesn't work. Any thoughts on this?
-
I'd like to Calculate date ranges for a specific type of project
I am getting different errors for the formula below, I think it is some comma or position I am missing. =COUNTIFS({EOTS}, "1",{CDate}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1)
-
Find and Replace in Formulas
Hello, I use a TON of formulas that involve employee names. When creating sheets for new employees I need to paste the names into each formula. It takes FOREVER because I cannot find and replace within the formulas. Am I missing something? Also, how do I stop this from happening? I can't make a column "number only" so I…
-
Dates in AVERAGEIF Formula
Hello all! I need to use formula averageif to count average of duration of projects in weeks, it is bases on the end date of it. I try to do it in Summary of the sheet. Here is the formula but id doesn't work. =AVERAGEIF([End Date:End Date], [End Date]@row<DATE(2019,12,31), Weeks:Weeks) It shows that this formula is an…
-
Group by Contact in report showing multiple contacts even though there is only Contact assigned
Hi all, I am facing a strange problem with a report I am creating, so we have multiple programs and we have the contact list field "assigned to evangelist" as one of the fields in the programs. I am trying to group by "Assigned to evangelist" and then group by program sheet. For some reason for some contacts, the group by…
-
How to create the formula for a workflow and automation
How to create the formula for a workflow and automation to monitor and execute a task on a birthday listing on an annual basis? Million Thanks in Advance.
-
Lock Vlookup
Hello, With the below vlookup, I'm pulling new employee's trainers. However sometimes the trainer changes midway through the class, is there a way to lock in the first trainer that is pulled? =VLOOKUP([Employee ID]@row, {New Hire Trainer}, 10, false)