-
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…
-
Multiple IF statements with > / < constraints.
Hello all, I am trying to make cell A display the number of cell B and then put a prefix on it depending on the value of the number. Below is my criteria. <49 "not relevant" 50-89 "Minor" 90-124 "Major" >125 "Critical" To test this, I did this formula, just to see if I could get the formula working. =IF([Risk Priority…
-
Displaying Row Hierarchy in Reports
I'm using Reports to show action items consolidated from 4 different sheets and assigned to individuals (separate report for each assignee). I would like to maintain the row hierarchy in the report so that the parent row shows when one of its daughter rows is displayed as an uncompleted action item. I am maintaining the…
-
Listing cell contents from multiple cross reference fields in one cell (if statement, index/match?)
Hi, I am trying to do an if/index/match statement to pull the contents of a cross reference cell if it is not blank into a single cell. I need to be able to list several non-blank values with a paragraph break in between in a single cell and I am drawing a blank. Right now I have this: =IF({ParkingLotBlockedComm} <> "",…