Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Sort by month?
I'm looking to create a report of products that will ship by month. I can't get a report to sort by month, is there a better option?
Default Cell Formatting
I have this weird issue I hope someone can help with. One of our PMs had used a background fill color on some rows. We wanted to pull a report of these rows but did not want the coloring in there. We reformatted the sheet to sheet be a white background fill and pulled the report. This worked great except for the system…
Filter to see hours per person
Hi Smartsheet, I have a column 'Assigned to' that lists employees name for specifc tasks. I also have a column that is 'Outsourced Hours'. When I filter on a specific employee it does not show me the total hours they have been outsourced. I would like the ability choose an assignee and see their total hours. Any…
Customize tab order
I have several projects that I am into every day. How can I have these auto-populate the screen instead of other irrelevant tabs?
Web Forms: Capture confirmation email into a column
Hi all, When using web forms, I'd like to capture the email address entered in the confirmation email field into a column in my smartsheet. Does anyone know if this is possible?
iterate same smart sheet set up for a new year
Hello, I am very new to smart sheet. Can anyone advise on how to iterate the same current setup/template for a new fiscal year set up? Many thanks
Calendar
Our tradeshows are listed by week i.e. Week 1: 5/1-5/5 in the Grid view. When I switch to Calendar view, the trade show isn't listed at all? Any sugestions on how I can see all of our tradeshows in a given month? Thanks.
COUNTIF Formula Help
Set up a set of columns: lead, support and stage. I can get the COUNTIF formula to work for me to count the names of the people assigned in the lead and support columns, but I need help figuring out how to get it to also look at the stage column and NOT count that name if the cell in that column says CLOSED. This is the…
Conditional Formatting
Is there a way to apply conditioning formatting so that the result happens to the parent row if the condition in the sub-task row is met? As an illustration, if a due date is not marked completed within 30 days, I'd like the parent row, not the sub-task, to highlight. I use sub-tasks so that I can keep them all collapsed…
User e-mail used by another account
Hi, We are a software development company that discovered smartsheet through one of our customers. They use smartsheet internally to manage part of a project we are collaborating on; therefore created us us users with their account in regards to the management of the project. We have now purchased licenses to use…
