-
A leading zero is disrupting my formula.
I have a form that is asking for time. In order to calculate it I break the minutes and seconds out. It is often resulting in answers with a zero in front. This disrupts the formula listed here, =([(H) Hour]1 * 60 * 60) + ([(M) Minute]1 * 60) + [(S) Second]1. We have many operators and have instructed them to stop putting…
-
IF Function
Hi, I am trying to create a formula one which there is two calculated values. Here is what I created below. =IF(ColumnName1< ColumnName2 - 3 * ColumnName3, IF(ColumnName3 > ColumnName2@ * 3, "True")) Does not work for me... First half of calculation =IF(ColumnName1< ColumnName2 - 3 * ColumnName3 Second half of calculation…
-
sum a multi-line text and numbers cell
Hello all, I have a sheet need sum number in multiline cell like: A1 = 80 GB A2 = 100 GB and 1 TB A3 (Total) = 1180 GB or 1.18 TB
-
How to incorporate an OR statement in a =COUNTIFS statement
Hi team - I have a formula that works for counting "errors" on from source data: =COUNTIFS({Agreements out for Approval (C H M L) Exempt}, 0, {(Source Data) BDO Exempt}, 0, {Agreements out for Approval (C H M) main row}, 1, {Agreements out for Approval (C H M) Created}, IFERROR(MONTH(@cell), 0) = 10, {Agreements out for…
-
I would like to search in a parant/child and get the result from another column
In the example you see BE and IT, with specific items. I'm looking for example for BE, item 4 and then want to see result mail 2, or IT, item 6 result mail 5. I tried index and match but I can't get it too work, does anybody have an idea how to solve this? Thx for your support Hilbert
-
Check for blank cell in "IF(AND" statement isn't working
I have a formula that was working until I added a statement to one of the IF(AND sections to check for whether a certain cell is blank. I've also tried using ISBLANK and that didn't work either. The condition I updated that is causing the formula to fail is IF(AND([Temp Move 2 Move In Date]@row < TODAY(), [Perm Unit Move…
-
Add a column for todays date automation
Can I insert a column that will automatically update today's date? I want to use it to compare today's date and contract date and the number of days between the two.
-
Is there a formula where I can identify first item alphabetically in a list?
For example, if I have a list of names and projects, I would like to identify the first name alphabetically for each project. In the image attached, Alex and Jane should be the first people alphabetically for their projects. Is there a formula that could evaluate a text range and determine which value is first…
-
Using countifs with a criteria to count distinct values
Hello, I am trying to count the number distinct values with status colors that are red, yellow, or green. We have the same property IDs with multiple line items. Therefore, I am trying to count multiple property IDs as one distinct value if they have a status of red, yellow, or green. The logic would be count distinct…
-
Lookup and fill in information based on another sheet
I have a large database of about 600 records. I created another sheet that comes off our institution's learning mgmt system showing several columns of information. In my database, I would like to put a formula in that would fill in several of my columns information, based on what course numbers are chosen. Can someone help…