-
Year over year with Year-to-date calculation
Id like to create a formula to calculate year to date 2016 vs 2017 Example 2016 - I have total of monthly sales for all 12 months (jan-dec) 2017 I YTD have sales for Jan- march I want to look at Jan-march ytd 2016/vs 2017 % change year over year Thanks for any help! Tina
-
Question about tracking project budgets in Smartsheet
Hello all, I'm working on a task where I have multiple project budgets that we want to track in one sheet. I thought the best way to do this would be by using individual sheets and then running a report to include data from each sheet but our Finance department is asking for a way to do multiple jobs (projects) and…
-
Website migration project
Hello, I'm a new Smartsheet user, managing a large health care website redesign project. We have a large amount of content to move from an older CMS to a new one. We're also moving from a static to a dynamic site environment. Are there any users here who have used Smartsheet to manage and track a large content migration…
-
Report Builder "What?" with multiple criteria
I am trying to create a report to find all tasks that are not checked as done or does not have a status of Complete. See the attached screen shot -- what am I doing wrong? I have 88 items in the list; there are 5 where Done is checked; there are 7 that are marked 'complete. That means when I run the report, I should have…
-
Sending a Row
Is there any way to see the history of ROWS that have been shared? When you send someone an Update Request, its documented in the Update Requests tab with who it was sent to and the date sent, etc. Is there a similar history shown anywhere for the individual rows that are shared?
-
Publishing Gantt Chart
We have a Gantt Chart, we have many columns for various items and the standard Start/Finish/%Complete....... We don't want to share the sheet with a lot of people they don't need all those extra columns, we really just want to show them the Primary/Task Column and the the Gantt Timeline that is it. Is there a way to…
-
MS Project Budget Reports and Smartsheet
At my organization we are currently trying to transition from MS Project to Smartsheet. Currently, using MS Project we are able to use a resource pool (every resource is added based on hourly rate, etc) and we are able to generate budget reports automatically. Is this feature something that is available on Smartsheet as…
-
Eloqua & Smartsheet Dashboard
Hi there, My company is new to both the Eloqua and Smartsheet community. I am looking for an easy integration between the two in order to have Eloqua metrics ported over to smartsheet for an easy and clean exporting process. Any suggestions on how this would work or if it is doable? Thanks so much!
-
"Pretty" PDF export -- Google merge, something else?
Hi all, We’re hoping to be able to export a fairly complicated styled PDF from Smartsheets. Imagine a sheet of movie reviews, where Column A is movie title, B is review, C is reviewer and D is date. Each movie can have multiple rows depending on how many reviews it’s received. We’d like to get a PDF that would look a…
-
How to count a text in a column?
Hey there, I'm trying to count a specific initials in a column with multi initials in each cell, but it doesn't work. Please check out the image. Is that a limitation? Thanks.
