-
Counting Based on Two Items
I am making a sheet to track the number of proposals we send out and how many turn into projects. I want to be able to count them by which Project Manager did it. So I have a PM field for the Project Managers initials. I was using fields for each PM's Proposals. The formula I used was COUNTIF(PM:PM, "RM") for example and…
-
Milestones in Report not printing to PDF correctly
I have a report that shows milestones and tasks. When I print to PDF the milestones are not showing as milestones but as very thin tasks. This is odd as the report shows a diamond black milestone but the problem occurs when I print to PDF. Any suggestions?
-
Reminder emails
Hello all - can anyone else explain how you set reminders for every action owner on a sheet at one time? We had previously been able to do this, but now it seems you have to set individual reminders for each person, per action - which takes ages and wastes time. Any advice would be greatly appreciated, Thanks so much Ferne
-
Epic to story issues from Jira
Hey all, I recetnly created a workflow with smartsheet and jira. All the issues seem to be imported with the stories under its respective epic indented. Later, when i linked some issues to its epic in jira and then refresh smartsheet i dont see those stories to get automatically indented under its epic. Do i have to do it…
-
Formula help!!
Please view the screenshot I have provided below. I am attempting to create a formula here that takes the whole assigned to row and the end date row. I want it to show the number of times it shows a certain name, in this case Dean, and if that task is one week past the current date. I would also like two weeks and three…
-
Advanced Notifications
Still loving this new feature but I am finding a couple of anomolies and I am unsure if it is something I am doing wrong. The email notification tells me that changes are highlighted in yellow, yet some are and some are not. Can anyone offer any advice? Many thanks Natalie Gorman
-
Share a Smartsheet folder to auto update added sheets/reports on Sights
Hi, Is there a way that I can share a folder with my team? I want to add the folder on Sights so that when new sheets or reports get added in that folder that it is already accessible in that sights folder without me have to go and add it manually everytime? Or any other suggestions on how new sheets/reports can be…
-
Cells are not aligned in the same row.
Hi, For some reason, there seems to be a misalignment between the first two cells in any row with the corresponding rest of the row. As if there is a split between them. The split grows as I scroll down. A very strange thing. The screenshot below shows the issue. I have selected multiple distinct horizontal rows. This is…
-
Google Contacts (G Suite) integration not working
I've added Smartsheet to my G Suite domain but I've not been able to get contacts to automatically populate when attempting to assign people to a task. When signing in to Smartsheet I do so using my Google credentials. It feels like I've failed to authorize some setting. Or maybe there are some limitations to the number of…
-
% Complete issue
I am seeing what may be a bug but perhaps another set of eyes can help here. I have a task which has 2 children. Those 2 children each have children of their own (grandchildren). The Children are showing the correct % complete rolled up from the Grandchildren. However the parent is not. It is my understanding that the…