-
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?
-
Smartsheet Filter Won't Share
I clicked on Share filter on my worksheet, but my team members can't see it. Any troubleshooting ideas?
-
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?