-
formula if date entered into a different cell if not left blank instead of invalid data type.
Hi I am using a formula which works really well to calculate worked days based on dates entered in two different columns, however if dates in those columns have not yet been entered, the cell showing the calculation shows invalid data type, i want the formula to work if date is in a column and show nothing if the date is…
-
Scanning QR codes
Hello everybody! Ive got a QR code that has 3 lines of text, and when scanning it, they are merged into one string w/o spaces. Is there somehow I can scan the code, so that the 3 lines are put into 3 different columns instead of them being put into one column as one string?
-
How i can add a other currency like THB (Thai Baht), Currencys which are not listed?
Hello Community, I would like to add other currency, THB Thai Baht, Currencys which are not listed? Thx in advance S.Carlo
-
IF Function (related to dates)
Hi @ all, I have a formula issue where I would like to get your help. As you can see I have a delivery cell which I would like to link to my "Financial Year" cell based on the following condition: FY2020 = starting 01.01.2020 until 31.12.2020 FY2021 = starting 01.01.2021 until 31.12.2021 FY2022 =starting 01.01.2022 until…
-
Dynamic numbering
Hi, I wanted to know if its possible to have the entry number as the Function + RAID item(R,A,I,D) + number. What I am looking for is for the R,A,I,D items to be named as per the functions- i.e. if its the 'first' R in Funciton1 , the result should be - Function 1. R.1 and if its the 'third' A in function 4, the result…
-
Task Dependency
Hi Team , As part of Program of Work sheet for a project , i have created a task which is a collection is set of sub tasks that can be completed if only the subtasks has been completed .However ,i am facing this issue where in my end task completion date gets auto filled as even if the only one of the sub task activity is…
-
A Single Formula to SUM a variable range of cells in a row
Hi, I am trying to write a formula that will SUM between one and twenty columns in a row, based on the number in another cell in the same row. If the number is 20, I want to sum all 20 cells in the row. If the number is 19, I want to sum the first 19 cells. The range is always contiguous, and the cells to be summed always…
-
Identifying Duplicates
Hello again! Trying to use formula to call out any data in a column that are duplicated. I referenced another post to try and solve this, but I cannot get this to work. See screenshot below. I have (2) duplicate numbers in this sheet (first 2 rows and last 2 rows), but this formula its not identifying them. This formula…
-
#INVALID COLUMN VALUE
How can I get rid of the error I'm getting using this formula? I realize that one column type is a checkbox and the other is a text/number. Is there a way to eliminate the "#INVALID COLUMN VALUE" that is displayed. The formula is doing what I want it to do other than that. Appreciate any help I can get on this.…
-
Check a box based on another cell not being blank
Hello! Looking for a way to check a box in column 2 based on column 1 not being blank. I've found variations on this theme, but nothing that quite gets me what I am looking for. Column 1 = Delivery Date Column 2 = check box I want column 2 to "automatically" be checked if a column 1 has a date populated / is no longer…
