-
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
-
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…
-
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!
-
View today, including one day and multi-day items on sheet
We track all our promos on one sheet. Some of them run one day, some of them run for several days, some of them run more or less permanently. I need a view of everything running on a given day. The filters do not appear to permit this. Any ideas? Ideally, would like this to run in calendar and gantt views. Alternately, is…
-
Sync Smartsheet calendar to Outlook - help troubleshooting issue please
Hi everyone, thanks to the useful posts here, I was able to sync the Smartsheet Calendar to Outlook, but no events show up in Outlook. I am pretty new to Smartsheet, so not sure what information you might need to help me troubleshoot. Can anyone help please? Thanks, Patrick Here are two screenshots, showing Smartsheet and…
-
Allocations
Scenario 1 I have a task that happens every Tuesday but only takes 1hr of my time. I don’t want to create multiple rows to indicate this as one 1hr of the day, is there another way to do this? Scenario 2 I have task that happens with a span of 5 days but only takes 3 hrs how do i calculate that? Is there a way to do this?
-
Creating and editing schedules in Calendar View
Hi all, I am just wondering if there is a way to visually create and edit a schedule in Calendar view. Such as dragging dates and durations like we do with Gantt bars? Darin Schnitzer
-
Web Form "send user to this URL" function is broken?
I have an embeded customer facing web form on my website to gather client prospect information. I need to integrate tracking coding for my website's PPC ad campaign and google analytics. Since the webform is displayed within an iframe, there is no way for me to apply my tracking coding. As a work around, I've built an…
-
Sights - How to
Hi! I am learning how to use Sights and experimenting on how I need to organize my data in the right way to make Sights work. What tutorial/webinar/video have you found MOST useful in getting started? I'm hoping to find a link that has the best tips and tricks. Thank you all!
-
Sheet limit within Smartsheet
Hi everyone, I'm about to embark on a large scale server back up and am hoping to keep all of my data logs on Smartsheet for safety. There will obviously be a massive amount of sheets to hold and I was just wondering if anyone knew the limit on how many sheets you can host? I'm a licensed user and am part of a team…
