-
I want to add a formula to my sheet where i can calculate the current month last working date
I want to add a formula to my sheet where i can calculate the current month last working date from the date entered as the last working date
-
Return the max date looking at multiple criteria
Trying to add the most recent training completion date (column is date/non-restricted) using mulitple criteria, to include: email address, training type ("refresher", or "intensive") and status ("attended") to a designated column (date/non-restricted) on another sheet. The formulas below are pulling the same date into each…
-
Help Extracting data sets that meet criteria to new sheet.
Hello, I am new to smart sheets. I have spent the last week trying to find a solution with no luck. I am sorry if I am asking a question that has been, probably, answered a slew of times. I have a form built that collects data on visits to one of four locations. "Activity Tracker" is the name of the sheet where the…
-
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…
-
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…
