-
count number customers briefed by quarter
Hi, I have a date column which shows the date we briefed a customer, I want to determine how many customers we briefed in each quarter and eventually by month. The column property is "date" and I cannot change that. =COUNTIFS([Date Briefed:Date Briefed], >DATE(2017,07,31), [Date Briefed:Date Briefed],<DATE(2017,11,01)) I…
-
Copying rows w/ checkmarked cell to different sheet
Hello, I am trying to find a way to link rows between sheets, but the 2nd sheet should only show the rows from the 1st sheet with a checkmark in one of the columns. Sheet 1: list of skus with descriptions and details. One column has a checkmark for the critical skus Sheet 2: auto copy (i.e. link) only specific columns for…
-
Import from GitHub issues?
Is there a nice easy way to import issues from GH into rows in a SS? Ideally 1-way sync so I can keep running it and it picks up new issues without recreating already-imported ones? Thankyou.
-
Dashboard Charts - Using Reports
Hi The new dashboard charts are a great addition to Smartsheet. Will you be introducing a way of charting against reports as well as sheets? Or is this functionality out there and I am not aware of it? Many thanks
-
Best way to add data to a project
I have all kinds of data to add to a project, .From address to the people outside the group who's information we need. Size of building, no of seats, building inspector name and contAct information etc. I home one project smartsheet per project
-
Report Sheet Scope Limit
I am receiving a notice that our reports have 302 sheets in scope and that it is recommended that the scope be reduced to 250 for better performance. Does anyone have insight into what performance issues having too many sheets create, and any workarounds? Is there the ability to improve whatever is causing that limit? We…
-
odd behavior - unwanted "0" showing up after form submission
I have a formula in a column called "Template" that looks like this: [apple]1 + [pear]1 + [grape]1 Three different forms allow the user to select a dropdown value for one of those dropdown types. For example, on form one, you can select "red" from the apple dropdown. On form two, you can select "purple" from the grape…
-
Automated Reminders showing all dates
I recently noticed that all dates including columns that are hidden are showing with my automated reminders. I have a number of calculated dates that I don't want to display. However, all of them now show on the reminders. This is a fairly recent development. I have emailed "Help" but, they have not responded in over a…
-
Linking rows
Hi guys, I'm new to smartsheet and I'm trying to figure out it can help me become more productive. So far, I have always used excel. I am working with a lot of minute by minute schedules tailored to the needs of the different departments in my company. I have one large file displaying all the small activities that happen…
-
Auto reply to a form
I was wondering if there is a way to have someone reply automatically to a form when asked for a reply
