-
Duplicate Columns in Report
Hello, I have four different promotional calendars that I am trying to merge into a summary. Each has month/week/day/date columns. When I create the report I want one set of those columns and then the promo/notes/$ etc from each individual sheet. Is this possible? It's very unsatisfactory to have four rows of dates with…
-
Calendar View in Insights?
Can anyone tell me if there is a way to include a report that is using the calendar view in Sights? When I add my report, it only shows the Task Table view and not the Calendar view. Appreciate any thoughts or suggestions. Thx!
-
Best or Easiest Way to Report on Milestones or Summary Tasks?
I know that SmartSheet can distinguish between tasks that are regular tasks, or milestones, or summary tasks (because of how it represents them on a Gantt chart), but how can I leverage this information when I am trying to build a report on just milestones or just summary tasks? Is there some way to tell a report to filter…
-
New data from Web Forms lands outside analysis range
We have a number of Smartsheets that gather data using web forms. Once the data has been gathered we analyse the responses received via the smartforms using formulea at the botton of the sheet (COUNTIF) This works really well and once we have this data in we can use the charts available in Smartsheet labs to present the…
-
Invalid response from JIRA. statusCode: 400 during Smartsheet for JIRA Workflow sync
I have set up a Smartsheet for JIRA Workflow and keep getting the below error message (screenshot also attached) for any rows created in Smartsheet (vs. ones originating in JIRA): Invalid response from JIRA. statusCode: 400, reasonPhrase: Bad Request statusCode: 400, reasonPhrase: Bad Request What I want to do is use…
-
Smartsheet for Social Media Client Approvals
Is anyone out there using smartsheet for social media management and client approvals? We are dealing with a high volume social media content calendar that requires client approval on social media copy and any design work. The process touches multiple persons throughout the process and we have an extremely difficult time…
-
Autofill a value
Hi. I'm new at building formulas in Smartsheet. I have a numeric column that I want to autofill a 1 if no value is entered. Can someone help me with this?
-
One Sheet with Many Projects vs. Many sheets with One Project?
We're new to Smartsheet and our web and content team are going to have multiple tasks that are going to be repeated again and again. We're going to create a checklist of steps for each one, for example, steps for creating an e-book. Since we're going to be creating lots and lots of e-books, should we create a new sheet…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
advancing dates (roll over)
I have a number of simple tasks that re-occur regularly. Is there an easy way to roll due dates over monthly, quarterly, or yearly?
