-
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…
-
I would like to send my sheet to users for viewing purposes and only want them to have the ability t
I'm sharing my sheets w/ external vendors and want them to view all the data but only update their comments (1 specific column). 1) The update request does not allow the abiity to change some fields from edit to view only. 2) The update report is ok but does it send a request to the spreadsheet owner? So far i'm not…
-
Reports Now Have 500 Rows (instead of previous 100)
Didn't see any announcements but Reports now finally have more than 100 rows. This is useful as I use special Report Templates for bulk updates (so cuts down the pasting). Performance seems pretty good for pasting 500 rows as well
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
Individual Task List Report (aka "Look Ahead" Report)
We have about 12 projects underway that are using Smartsheet. I'm planning to send each resource on the projects a "look ahead" report that shows all the tasks they are responsible to complete over the next 2 weeks. I've created the report. consolidating the sheets, but have two questions: 1) It looks like I need to create…