-
VLOOKUP Error
I am trying to create a timecard that auto fills cells based on a table of job numbers, cost codes, phases, and job names. I am using the VLOOKUP function and it is giving me a #NO MATCH. =IF([Job Number]@row = 120403, VLOOKUP([Cost Code]@row, [Job Number]33:[Phase (Area)]45, 3, false), VLOOKUP([Job Number]@row, [Job…
-
are elements of a multiselect field in another multiselect field?
Hi all, how can i find out if all elements of a multiselect field are contained in another multiselect field? Example 1: Multicell Field "Value1" has: "a d" Multicell Field "Value2" has: "a b c d" Answer: true, all values from "Value 1" are in "Value 2" Example 2: Multicell Field "Value1" has: "a d" Multicell Field…
-
#DIVIDE BY ZERO Message/PERCENTILE Formula
I am using the formula =PERCENTILE(Agree@row / $[Total # of Surveys Completed]@row, 1) when the column Total# of Surveys Completed is 0, the message is returned #Divide by Zero. I want to show 0% instead of "Divide by Zero. It does show 0% when any number of Total# of Surveys Completed is <0. I'm sure there is a simple…
-
Reference Codes
Hi, I am looking to have a single reference code or number that is attached to an update request that contains multiple rows. Is there a best way to do this? My first thought is to have a value added to a cell when the reference goes out, is there a way to make this a rolling serial number as each update request is…
-
Can a submitted Form have the date (today()) in the Tittle of the e-mail?
Hello Brilliant people! Here is my Query.... Scenario: I have a form in which users populate their tasks for the week. The form is call "my tasks for the week". When they enter/complete the form, they can request an e-mail copy of their entry. Should they do so, they will receive an e-mail with the tittle " Confirmation -…
-
Check box IF date in a list
Hi, I'm trying to figure out how to create a column that has a checkbox when a date in one cell is one of a list of dates in another sheet but it doesn't seem to work. See below, 21-11-15 should be checked as this date is in my list. Here is the formula I use : =IF(CONTAINS([End date]@row; {Férié Plage 1}); 1; 0)
-
Need help in converting the data sets to "K"s and "M"s
Trying to build bar graphs with large set of data and looking for help to convert the values to K's and M's. The Dashboard has a lot of key information that I would need to represent and hence it is congested for me to write all these numeric values as data values I sincere appreciate any help to round a number to "K"s and…
-
Increase the value based on checkbox
Hallo all, column Team has different types of values (Requirement, Infrastructure, Developemnt....) column Active will represent whether they active in project or not Problem: ~ If i select Active column checkbox for any member then Active Help column should show their team name and count for ex. Requirement Team 1, if i…
-
Return all rows that match any names in a master list
Hi! I have been trying to return set of rows from a data set (separate sheet) with one of the columns (Action Owners) being the criteria range. However, the criteria is not just one value, but I want it such that if the name in Action Owner matches any name my "master list" of names (separate sheet), it will return those…
-
Adding info from One column of a sheet to the column of another sheet
I am collecting info at 2 different times from different individuals on two different sheets. How can I add input from one column of one sheet to the column of another sheet? I will then use the info to populate a dashboard. Any help would be grateful. Or any other work around.
