-
Extract Text and Number in Varying position
I need to extract text and a number to provide me with my account number. In the screenshot below shows an example of the data I am faced with. The formula will go on this sheet shown. As you can see, sometimes there is no TDL #. Sometimes the TDL # is in the front, other times in the middle, and apparently at the end…
-
Auto increment count on Column based on values appearing in another column
Hello, I am trying to add a formula to Column SSI Ref that will count and increment based on the number of times a number appears on SSI# column. I have completed the SSI Ref column for reference as to what I would like to see. Thank you
-
Update one sheet based on two columns from another sheet
Hello I have a request sheet and a review sheet. The request sheet generates a task number after submission of a new row. That task number will be manually inputted into another sheet. Once a review is done of the request, the user hits review complete. I want that checkbox (once its clicked on the review sheet) to get…
-
Formula Question
I am trying to build a Finance sheet for a project and I want to be able to type in the project code and to pull the info from the Metadata sheet into the finance sheet. I am using a combination of the Project Management Office template set and ones I have created. I have tried to use the existing formula in the Metadata…
-
JOIN(INDEX cross sheet with multi select criteria
I am attempting to match multi select criteria in one sheet to the corresponding contact list in another sheet. The multi select column has over 100 possible criteria, though the average cell has 3-4 selected. There are some circumstances that the formula will need to return two or more names. I can't make JOIN(COLLECT…
-
Formula to mark duplicates with a Status of 2 or 3
Hi Everyone, Hoping I can explain this well so that someone out there can help me with this. I have built a solution that is quite complex and moves projects around to 3 different sheets. The intake sheet generates a project ID and then when the project gets to a certain stage, it copies to my Active project sheet, but…
-
Set Target End Date first and have predecessors fill in
Is there a way to set the Target End date in a project sheet first and have all the preceding dates backfill? When I tried it, an alert comes up that says "…will result in the removal of all predecessor relationships in this row". I've looked into the Workback Schedule using the Project with Hard Deadline and Gantt…
-
Dynamic drop downs- possible in smartsheets?
My boss recently challenged me to see if I could add some logic to our project plan smartsheet templates where if a user entered in an Assigned To column can dynamically narrow the values available in a Role column to show only the roles the person selected in the Assigned To column is eligible for. For example, let's say…
-
Sumifs- With a start and end date range Errors
I am struggling with this formula. My Syntax is correct, the lay of this formula works until I add my date range. I have tried having both my formula column and the referenced date column as date, dates restricted, as well as just Text/number. I have a years worth of data I want to calculate grand total of sheet, which is…
-
Any way to update formula criteria with drag-fill
Hello, I have a sheet with around 3000 rows all of which have a date received and I am trying to count how many were received per week. Currently I have a helper column which has the week number (1-52) and have =COUNTIF([Week number]@Row, =1) which works but I am wondering how to then extend the formula to automatically…