-
Sheet Row Limit - Automation Recos / Suggestions
With one of our clients, we are running into the 20,000 sheet row limit, and I was wondering what others have done to work around this issue? My first instinct is to createduplicate a sheets, and then use a report to pull it altogether in the end. It's a pretty manual solution, so I'm looking for something more automated…
-
Is there a function that counts a cell if it contains a value rather than equals that value?
Is there a function that counts a cell if it contains a value rather than equals that value if you have cells with "dog", "cat", "cat dog" and you want to count "dog" using excel you can use this formula =COUNTIF(A1:A3,"*dog*") but the * doesn't seem to work in smartsheet
-
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…
-
Touch screen capability for Smartsheet Cards
Currently, Smartsheet does not support the drag and drop feature for Card View on a touch screen. I have a ProLite T2736MSC touch screen monitor and I would like my team to be able to physically drag and drop my Smartsheet cards by touching the screen. This is a feature which is possible on Android/IOS and probably not…
-
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) =…