-
Problem Saving Blueprint
Hello Smartsheet, Reposing in hopes that you can assist me. I've added a new sheet to my Blueprint (I've done this before). The sheet has one profile field (Project Name). I don't need anything on the sheet to report out to anywhere. When I try to save my Blueprint, I receive an error "add more column(s) to reporting…
-
Assigning Multiple Tasks to an Entire Team
Hi I am new to Smartsheet, and hence am unable to perform the subject activity in it. I have a set of 25 tasks called "Proofreading Tasks". And I have around 15 people in a team which is called "Team - Proofreaders" . This team is supposed to perform these -- and only these -- tasks. Now how do I set it up in Smartsheet so…
-
forms and cell linking to a secondary sheet
Hello I have created a Time sheet form that i sent out to 11 employees to gather all the daily info. This form fills in the Time sheet Smartsheet. We want to keep the Time sheet Smartsheet as a master sheet and strictly for data collection so that no one messes around with it and looses anyones time. Ive been trying to…
-
Problem Saving Blueprint
Hello Smartsheet, Reposing again in hopes that you can assist me. I've added a new sheet to my Blueprint (I've done this before). The sheet has one profile field (Project Name). I don't need anything on the sheet to report out to anywhere. When I try to save my Blueprint, I receive an error "add more column(s) to reporting…
-
Report Column Names / Labels are not same as Smartsheet Column Names
Hi, I have noticed on reports created from the original smartsheet that the Primary Column Label and automatic numbered columns don't have the same smartsheet column name. When you pick the reporting you want to include it uses the original default titles as opposed to column titles used in the smartsheet (if you have…
-
Creating a link that automates adding new cells into the sheet
On the current project I am working on, I am trying to use smartsheet to recreate an existing Microsoft Excel template that my company uses to collect data. At the bottom of the template, there is a cell that will create more cells at the bottom of the data set (ex. one region is working in 4 schools in quarter 1, but then…
-
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…