-
How do I move decimal one place to the left?
Formula for calculating minutes in military time but the decimal in the Minutes column is in the wrong place. How do I edit the formula below to move the decimal one place to the left? =(VALUE(LEFT([Clock Out (Military)]@row, IF(LEN([Clock Out (Military)]@row) = 3, 1, 2)) + (VALUE(RIGHT([Clock Out (Military)]@row, 2)) /…
-
How do I count the number of checkboxes within a column range?
I am trying to count the number of checkboxes in a column range and am getting errors. I would like to get a result that provides a summary of a specific range within the Priority 1 column. I have looked at some of the other posts related to this similar topic without success. Any help or guidance would be greatly…
-
Using the YEAR formula to convert a DD/MM/YYYY column format to show YYYY in another column
Hi All, I am trying to create a formula to take the date column (DD/MM/YYYY) called "travel in date" and convert it over to YYYY in another column called "Year". However, the following formula =YEAR([Travel In Date]16), it is converting over but showing the value incorrectly as 2022 when the date in the referenced cell is…
-
How do I make the word "false" stop showing in my JOIN formula
I have several formulas in different sheets with a JOIN formula. I am running into false showing in the column with the formula and am experiencing staff confusion with it saying that. How can I make that go away? This is the current formula: =JOIN([NURSE TAKING ORDER/ VO AND TO ORDERS ONLY]@row:[Verbal/Telephone Order…
-
Help with Formula
I need help creating a formula within the Sheet Summary. The formula should read: The total number of rows where the Original Workflow Session date is past today AND the Review Status is set to Approved. Thank you!
-
Help needed with formula
I have a column that brings in whatever was typed into the PO field on an order form. People mostly put in their name, and often some other text to indicate their region or department. I need to find a forumula to extract just the name and display it in last, first format. This is an example of the data: JAMES MCDONALD…
-
Comparing cells in two columns
I need to compare two date columns. If Column A contains a Date and if column B does not contain a date then count, otherwise 0. I have tried =IF(ISBLANK([Date CMI filed in compliance]@row), IF(NOT(ISBLANK([Date form sent to FE]@row), 1, 0))) but it is returning an incorrect argument, can anyone help me please?
-
Pull data from one sheet to another when a box is checked.
Hi SS Community, I'm trying to figure out the best way for data from specific columns in a sheet to get copied to cells in an control center intake sheet. Thanks, Kyle
-
Setting up Automation to "Request an Update" from a contact within the row.
I am wanting to set up an automation to request an update to a specific field from the person whose email is in the row. How do I do that? I have selected "Send to contacts in a cell" but the only dropdown option I have is "Modified By." I would like to send it to a different Column Header: "email address". Is this…
-
CONTAINS: What's it all about and how does it work?
I personally am still getting used to the new CONTAINS function, and I have noticed a few others on here looking for clarity. I figured I would start this thread in an effort to hopefully combine knowledge and do some collective brainstorming on how it works and some good examples of use cases. I'll be revisiting this…
