-
Extract a MM/DD/YY Date from M/D/YYYY HH:MM
I'm looking for some formula help to convert a date format. The date column I'm referencing is coming in from another source, and is formatted as M/D/YYYY HH:MM - here's some example data from the sheet: I need to compare these dates to a user-set date (column = Prior Run Date) in my sheet, which is a Date column typeā¦
-
Copy formula to the entire column
Is there an easy way to apply a formula to an entire column? I am using this formula to calculate days between two assignments columns: =NETWORKDAYS([Review Start Date]@row , [Review End Date]@row ) I am calculating the days on the next column. [Days Open] I can click and drag the formula to the other cells in the columnā¦
-
Formula to Calculate Time Taken Between Two Date and Time Columns Stored as Text
Hi Community, Iām trying to calculate the time taken between when something was ready and when it was picked up. I have four columns: Ready Date (Date column) Ready Time (Text/Number, format like 4:05 PM) Picked Date (Date column) Picked Time (Text/Number, format like 4:05 PM) The challenge: Since the time columns areā¦
-
I have a formula that works on one cell but I cannot apply it as a column formula. Need help.
=IF(HAS([Product Training Type Requested]@row , "Tourlock- 1 Day"), 1, 0) + IF(HAS([Product Training Type Requested]@row , "Turnlock- 0.5 Day"), 0.5, 0) + IF(HAS([Product Training Type Requested]@row , "Circlelock- 1 Day"), 1, 0) + IF(HAS([Product Training Type Requested]@row , "Lifeline- 0.5 Day"), 0.5, 0)
-
Use index, match and left to match a set of strings from another sheet
Hello, I am using the formula below in order to match two data sets together. It works fine. For my next task I am trying to limit the match to only the first 12 characters of the string. I am trying to fit in the left function and using 12 as the character count, but I am getting errors. Here is the current formula I amā¦
-
Formula in Sheet Summary returns different count result than filter
I am trying to count new entries in a list added during the previous week. If I filter data on "Create Date" between the dates for Sun-Sat last week (eg 8/3/2025 and 8/9/2025) I get result A (65). In my sheet summary I used this formula: =COUNTIF([Create Date]:[Create Date], IFERROR(WEEKNUMBER(@cell ), 0) =ā¦
-
Ensuring that an address field in a cell has no wraparound
Hello I have Users who enter their address into a form/cell. Usually they use carriage returns/hard returns when entering it. This data then gets mapped to a field in DocuSign. I'm finding that even when the wraparound is turned off, the field in DocuSign is still 'stacked'. Is there a formula to breakdown the address soā¦
-
MILITARY TIME FORMAT FORMULA
Hi good day im just new here just wanna seek some help regarding ok my formula though it was already working but the result is 12hour format and not 24hour format heres my formula =IF([Case Type]@row = "Internal Service Issue", "ISI", IF([Case Type]@row = "External Service Issue", "ESI", IF([Case Type]@row = "Agency Debitā¦
-
Indexmatch (retrieving date from one smartbook to generate in main sheet) with a condition
Good afternoon I would like to use the Index/match function between these two sheets but there is a condition. I was provided with the great formula (thanks to @jmyzk_cloudsmart_jp ) but now i have another request. One of the employees was transferred to a different department which means he is now under another costā¦
-
Simple Index Formula - Invalid Op
Hello. I have a simple index formula just to get one cell down from 9 columns over. I've tried many different options using the Index formula page and am having no luck. The column type the formula is in is the same type as the column I want to pull from (though the destination column is a formula, so maybe that is whatā¦