Hi! I seem to have a major problem here and hope for you expert advice. My situation is as follows: 1. Team A and team B work collaboratively in Masterfile on first phase of the project with over 200 rows from all countries. 2. Team A also works with the other 7 country teams on a second phase of the project. 3. All teams…
It would be helpful if you could scroll through the Gantt view of a report, separately from the Task view, when looking at a report that is embedded within a Dashboard. Today, there is only a single horizontal scrollbar and you can quickly lose sight of the associated tasks as you scroll to the right to see everything in…
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…
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!
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…
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…
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…
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…
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?