-
Parent Child Numbering
With A LOT of help from the community I was able put this together but, I think there must be a better way. The last column is what I am trying to get to. Auto-generated Sequential number in this format T-00001 when Ancestors = 0 Auto-Generated Sequential number in this format T-00001.1, T-00001.2 (where T-00001 is the…
-
Filters, multiple users - do the filters stay seperate?
I have a large release plan and our users would benefit from using filters to pull out information specific to their department or the product they are assigned. My questions are if we teach everyone how to use filters, and someone saves the sheet with the filter turned on (but the filter is not shared), does the next…
-
Building contingency into project plans
What is the best way to manage tasks that have a high degree of uncertainty in the duration? An example might be resolving a design problem – sometimes they are quick, sometimes they take a while. A previous software we used, allowed you to put in a best case and worst-case estimate for each task – effectively adding…
-
Fix PDF print function with Latin Extended letters
After a helpless few months of knocking on Smartsheet support doors, our company finally got the answer, to why our texts randomly change from set conditions in PDF forms (font, font size, font weight), to a different text. As it seems, if the text in a cell has any Latin Extended letters (ą, č, ę, ė, į, š, ų....), it will…
-
SumIf Date Range
Hi All! I'm trying to use the Summary in a sheet to tabulate an object count between a date range. I'm trying to get a Sum of cells in a column "Number of Objects", if the "Date Imported" is between a range, 09/01/21- 08/31/22. The formula I'm using is returning "0". The formula is : =SUMIF([Date Imported]:[Date Imported],…
-
Extract the first word from a cell
Hi, In 1 column I have a string that has 1 word then 2 or more words after that, how do I extract from the column the first word only? In excel I'd use the following =TRIM(LEFT(A2, FIND("^",SUBSTITUTE(A2, " ", "^",1)&"^"))) In Smartsheet there's no TRIM.. The below formula returns the value of the first and second word,…
-
VLOOKUP Lag In Updating
Hi all - I'm connecting two sheets via a VLOOKUP to get a value (Status). I'm seeing a 2+ min lag in the delay in the update of the VLOOKUP - which I've never seen before. It's always been nearly automatic. Even though there are only a few formulas, the VLOOKUP spans only two columns and there are only 50 or so rows, the…
-
Flag duplicate titles but not if the title is blank
Hiya, I am trying to write a formula that flags entries if the content of the title column is repeated, but I need it to ignore entries that have a blank title. My current one is: =IF(COUNTIFS([Conference Title]:[Conference Title], [Conference Title]@row > 1, [Conference Title]:[Conference Title], [Conference Title]@row) =…
-
Index Match Function Help
Hi Smartsheet Gurus, I am attempt to pull information from one sheet to another given a set criterion that is present in both. I believe that either a VLOOKUP or INDEX function should suffice but cannot seem to get things to work. A little background: We would like to be able to have employees enter a form with data about…
-
Countifs Error for 3 references
I am trying to get a metrics report for a dashboard for a log with multiple test cycles and multiple data. My metrics are by Status (New, Open, Cancelled, Assigned to Vendor, etc) Each of the Status options has to be filtered by the testing cycle which is either SIT or Deferred to SIT (I know I will have to do the same…