-
time based reports?
I'm sure what I'm looking to do is not that difficult, I just can't find a way to achieve it. What I have is a sheet that consists of quote amounts ($) that are relative to a quote date. What I want to do is to look at how many dollars we have quoted that are on quotes a month old, 2 months old, etc. Ideally this would be…
-
Enhancement Request: Open new Report for editing
is there a reason that when I create a new Report (using the Create New button/menu) that the Report does not immediately open for editing? (I can't think of one) Craig
-
users feel intimidated by Smartsheet
I collaborate with many people who have no PM experience and/or prefer memo-style information over cell-based. Some people feel overwhelmed by the tool so they send emails rather than update Smartsheet. Beyond the training and show-me sessions we already do, how might I help people embrace Smartsheet? Do you know of ways…
-
Using Smartsheet data to populate project documents
I looking for opportunities to streamline the production of project updates / documentation by trying work out the best way to use data already captured in various smartsheets to populate project updates to our product development steering group. I presume there is no function in Smartsheets that facilitates the output of…
-
Reports / Master Calendar
Hi there, it's me again. So here's the thing... We are a small test facility. We are trying to track jobs that are nothing like eachother using the same equipment and people resources. Sometimes we have 2 people resources on the same job. I know there currently isn't anyway to put 2 people on the same job and that I would…
-
Display report data rolled Up?
Hi there I’m currently running an exercise where we are asking a group of 30 users 10 sets of questions each. Each set of questions has its own web form so there should be 10 responses from each user (300 separate rows in total). I have this working fine. The users have requested a ‘dashboard’ which would allow them to see…
-
Add Years to a Date
If Term_Effective_Date = 12/07/15 and Terms_In_Year = 3 Years. What is the formula to calcuate the New Date? I need to add 3 years to 12/07/15. =DATE(YEAR(Term_Effecitve_Date2) + [Terms_In _Year]2, MONTH(Term_Effecitve_Date2), DAY(Term_Effecitve_Date2)) I am getting #NUMBER EXPECTED as an error. Thank you for helping!
-
RSS Inbound Feed
I'd like to take an RSS feed and have it populate rows in a SmartSheet document. Is there a way to consume external data so it is automaticly added to my documents?
-
"Processing" Today date in date range.
Good day all, I am collecting information via a webform and need some assistance with the reporting side of things. On the webform i am asking among other things to provide me with a startdate and a finishdate. My aim is to have automated reporting in the backend that will check if date Today is in range of the user…
-
Historical Report Status
I am looking to increase my efficiency when creating statistical reports. Each week, we run a report to see how our projects are tracking (red, yellow, green traffic lights) but I what I want to do is keep each weeks statistics so that I can create a historical report of these figures. At the moment, each week I need to…
