-
How to calculate time
Hi. What's the formula to calculating time? For example, in one cell, I have my starting point of 6:00am. And in another cell, I have a finish time of 11:00am. What's the formula to calculate time between these two points? Thanks in advance.
-
Automation to "Change Cell Value" to embed a formula into the cell
Trying to set an automation to "Change Cell Value" 2 columns involved: "BARCODE" and "PACKAGE UID/LOT #" If "PACKAGE UID/LOT #" is not blank, then I don't want to override the data in the cell, however, in the absence of data in that cell ("PACKAGE UID/LOT #" is blank), then duplicate the data from "BARCODE" into "PACKAGE…
-
Formula to Hyperlink contents of a column into another
Hello, I have two columns, one with a URL, and one with text. Is there a formula, or automation / process that can hyperlink the URL and text into a new column? I have the need to hyperlink a few hundred rows of data and want to avoid the manual hyperlink method (copy URL, cmd K , paste link etc...)
-
How to calculate variance between dates with referenced values?
Hi all, I tried using the NETWORKDAYS formula and it appears it only works when you have date columns where you enter the date manually. I have a project rollup sheet which I am trying to calculate the variance of NETWORKDAYS (which considers the non-working days) of 2 columns which references dates from another sheet.…
-
Can anyone help me with my formula for ticking a box?
Hi Guys! So here is part of my database with the information I collect. My issues is my formula only picks up dates and I was wondering if anyone can add in kms too? So under Service required I have this formula : =IF(OR([Odometer Reading]@row > [Service Due KM's]@row, [Service Due Date]@row <= TODAY(21)), 1, 0) But lately…
-
Adding in a cell via if then?
Hello Community, I need help with a formula. I would like to add the totals into one cell based on the following condition but don't know how to write the formula. For example, if the Status column, has any of the following results, then add the amount in the "Amount" column in this cell. Any help would be appreciated.
-
I need help to calculate the overall Priority by using IF condition.
Hi, I need to fill the Overall Priority column. I use IF statements to get the result, but not sure what's missing. Please help me with Formula. I have got the Priority columns data by forms, need to summerize of all priority columns in one column(Yellow Highlighted). for intance, Test Project should show "Low"(1) Test…
-
Metrics sheet - Want to use formula to pull in date when column type is "text/number"
Hello, and thanks so much for any support with functionality or a work around. I am creating a summary page for the system I am building. I would like the summary metrics to form a grid like table for visualizing sections of data. First column is the title and second column is the data. The column type for pulling in the…
-
If cell equals this, then insert cell
Hello, I am looking to auto populate a cell with some information pulled from another sheet. So if Site Name equals 'Bury', Contract ID should populate with '0004' from other sheet. I'm struggling to find the correct formula in order to do this, if somebody would be kind enough to help please.
-
Nested IF Formula
Hi Everyone I need to create a formula for a workflow status that shows a set % for a workflow stage when the Status column is updated. I.e: if the Status Column shows "In Progress" the Status % column automatically shows "20%". I've tried various nested IF(AND) and IF(OR) formulas but can't get them to work. This is what…
