-
How can numbers only be extracted from a cell which may have text, numbers and symbols?
I have a column of ID's extracted from a larger string. I need to extract the numbers ONLY. The column looks like this: The numbers will not always be exactly in the same starting position, nor will they always be the same length. There can be anywhere from 3-5 numbers. The preceding text may be between 5-6 characters. I…
-
Inactivate a task
Is there a way to make a task or group of tasks inactive in a project plan? In Microsoft Project there's a function called Inactivate that's used after you select tasks that you want to make inactive. Doing this does not affect resource availability, the project schedule, or how other tasks are scheduled. I know this…
-
Past due formula keeps providing #INVALID DATA TYPE error
Hello, After much research and experimenting, I am still stuck on a formula for my status log. I am trying to create a formula that counts how many business days a task is past due. Therefore, the formula must check the due date, closed date, and status columns. The formula currently reads as this: =IF(ISBLANK([Due…
-
Cross Reference and Multiple Columns
Hello Smartsheets! Trying to find a solution when matching rows across sheets. Is it possible to say, if multiple criteria in columns match criteria in multiple columns on another sheet to check a box? For example, if I have identical rows on two sheets (sheet A and sheet B) of matching information, check a box on sheet A.…
-
I am trying to get the last Monday of the month from a date using a formula.
I am working on a project where I want to use a formula to return the date of the last Monday in a month. For example, if I have a cell that says 4/11/2024, I want a formula that will then return 4/29/24 (because that is the final Monday of this month).
-
Multi-Select formula using the selections as the criteria.
See attached document for details, but I need to select email addresses from an external sheet where the contents of a multi-select column is used as the criteria. This was my attempt. No errors, but it doesn't return anything. =JOIN(COLLECT({Email Address}, {Dealer Name}, HAS(@cell, DEALER@row)), CHAR(10))
-
Looking for a formular to help with a rooming list...
I have lots of passengers on separate rows. I have a heading row of dates. I then have a sequence of 1's in a grid that show which nights a person will check in for 1 over night stay. In the first example, my traveller will check in on 17/06 and check out on 24/06. I am currently having to update the columns manually when…
-
Copy row to another sheet by COUNT until COUNT = 0, or other Parse option
Hi folks, I've got rows that collect courses for students into the COURSES REQUIRED column separated by commas. I've already setup a formula to count the number of courses found there What I'd like to achieve is that for each student/row containing multiple classes in their required list ... parse that students row such…
-
Automation help or formula for connecting rows
AW Placement request form below takes in all of the school placement requests via a form. Once the column AW REQUEST STATUS is 'approved by leader' it is automatically moved to Students/Instructors - AWI The ANCHOR ID transfers over from AW placement request sheet to students\instructors - AWI - when approved by leader…
-
Index Match Help
Good afternoon, I'm trying to get my Index and Match formula to work, it was working correctly and has now broken and I'm not sure why. I Have a "Weekly Metrics" Sheet I'm Trying to pull information over to the "Weekly Metrics 2" Sheet I'm trying to get the data from Weekly Metrics to Weekly Metrics 2 by matching the dates…