-
Smarsheet as a payslip app.
Is it possible? I need to automate my timesheet into a payslip afterwards. Tell me how can I do that? Thanks.
-
One tab, multiple reports?
Smart Sheet has proven to be an amazing tool. In using it, I have built several reports that are starting to take up too much space on my display. Some of these reports are very similar (Quarterly reports, for example, are taking up four tabs per year) and I want to consolidate them into one tab. How do I create multiple…
-
Consolidating names in a Columns
We use Smartsheet to manage several projects, with multiple and repeat customers. We need to create a report that reviews (2) columns (distributor and customer) from serveral sheets. We would like the end report to combine the (2) columns from all of the sheets and remove any duplicate names from each column. I have gotten…
-
Live Data Connector
We're considering upgrading to the Enterprise license so that we can use the Live Data Connector, but before we do, wanted to confirm if you can build reports against "Resource Views" data? From what I've read, can certainly author reports against smartsheets, and I suppose I could reconstitute the data that appears in the…
-
Updating projects when parent & child rows are involved
Hi, I have built a large projects register for my organisation which uses parent rows to express the Project Name, and children rows for each Stage of that project. So for example Row 1 would be "Park Upgrade". Row 2 would be "Initiation/Planning". Row 3 would be "Design/Development" etc. Also on the each children row, I…
-
Trying to get a formula to work
I am currently trying to get a formula to work in Smartsheet that will count the requests we have outstanding that havent been completed and are over 41 days old. But that will also take into account when new lines are added to the document. The formula I have got working in excel is: =COUNTIFS(B:B,"<"&TODAY()-39,C:C,"")…
-
Combined Reports
I have a combined report that is pulling information from 10 different smartsheets. The columnar information is the same from each of the smartsheets. I have it grouping by the smartsheet the information is coming from, but I would like the "title" of the smartsheet to show up at the beginning of the data from each sheet.…
-
What reports are most useful to you?
I'm looking for some input on what reports you've found most useful. We've been using Smartsheet for about a month for 12 projects run by 3 PMs. The project plan functionality is working great. We are just getting going with reporting. Here are the initial reports I'm planning: - Individual "Look Ahead" Task Lists for each…
-
Time zone for recurring emails from S/S
What time zone are emails sent if I setup email as an attachment for a report within Smartsheet? It offers to select a time that the email is sent, but I'm unclear if it's sent at my local time zone, or based on some other time zone (Pacific?)
-
Hiding Completed Projects in Task Report
Good morning, I'm creating seperate reports for each of my users which pulls in all of their tasks. I'd like to remove or hide the tasks that have a '100%' listed in the '% Completed' column. I've added the '% Completed' column to my report and set up the 'What?' to exclude anything in which the '% Completed' cells contain…