-
Sheet size limits - workaround or alternative?
Hi all. We are tracking data with SS and constantly run into space limitations (on the 200K cell limit, I believe). Also, the size of the sheets are bogging down to the point of unusable for some. Anyone have an idea to work around this or is there a SS alternative that can handle a large sheet? Thanks in advance.
-
Email INTO a sheet
We would like to have specific email addresses to add items to lists. Is this possible? For example, an Intern inbox of tasks. The subject line would go to the Task Name and the body of the email into Description or Comments. I guess this is a feature request... Rob.
-
SUMIFS for multiple criteria
This should be fairly simple, but I am spinning on this syntax. Trying to sum my "Invoiced" column if the Year Column = "2019" and the Type Column = "Expense". I have tried a few variations, but this is what I think should work? =SUMIFS(Invoiced:Invoiced, Type:Type, Expense, Year:Year, 2019). I have tried quotations around…
-
Cross Sheet Formulas For Children Rows
Hello. I´ve spent all day trying to look for how to do this, I found some info but wasn´t exactly what I needed, plus, I´m new using smartsheet. What I need is to bring info from another sheet, but only what is inside a children row. I have a budget sheet with several ancestor, parent and children rows; I need to use…
-
Number formatting in Sheet Summary
Hello all, I'm using sheet summary to get rid of the top row on our master project list. Formerly, we used "=SUM(CHILDREN())" to add up all projects & sub tasks.The top row was only there to add everything up. We moved this function over to the Sheet Summary & it's working fine. My issue is the number formatting. The…
-
Rotate Text?
Can titles of columns be rotated so more can be squeezed into view?
-
Master build schedule to sync with other sheets?
I am not having any luck searching for a solution to this. My company has a production schedule in Excel. It changes daily. Builds get added, removed and moved around on a regular basis. We have two different engineering departments that are managing their work load in Smartsheet. The two departments have very different…
-
Only excluding the first weekend
Hi, I'm currently using a formula to spit out a certain number of days between two dates. I want to exclude the first weekend if it falls within the first 3 days, but otherwise include it. Currently to exclude weekends entirely I'm using =NETWORKDAYS([SALE DATE]21, [OUTPUT DATE]21) - 4 I'd like the formula to work like…
-
Finding Value in a Cell In Another Sheet
In Sheet 1, I want to COUNT instances of value across a range of cells in Sheet 2, with some cells containing multiple values, separated by commas. Let's say Sheet 2, has the following values in a range of rows: SHEET 2 1: | blue | Group 1 2: | blue, red | Group 2 3: | green | Group 1 4: | red, yellow | Group 1 5: | red |…
-
Gantt chart timeline settings
I have admin access and have set the Gantt settings on a particular sheet to Primary heading: Months Secondary heading:Weeks I have shared the sheet with another user and given them Editor - can share permissions but they are seeing a different view on the Gantt chart. Why is that? What do I need to do for them to see the…