-
Project Phase Gaps and Overlaps
Hello, I have seen similar questions posted elsewhere, but I can't seem to make this work for my situation. I need to flag any project phases that overlap with other phases and any gaps of more than Xdays between the end of one phase and the start of another phase. In the project plan, there are official phases (marked by…
-
Automated Workflow Notifications
Hi everyone, Is anyone having issues with notifications? Since yesterday, I've had a few automated workflows that, when triggered, are not sending the email notification or even alerting the user via the Notification bell.
-
Line chart is not displaying percentages correctly on Y axis
I created a row report which displays each team members' allocation % each month. I want this represented by a line chart with each line representing a team member, plotting their allocation percentage each month. I created a line chart, and the lines for each team member are being plotted correctly, and when I hover over…
-
Moving row from one sheet to another
Hi Here is my challenge. One of my team enters projects into Sheet1 using a form which results in new rows on Sheet1. Once projects from Sheet1 are approved the manager checks a checkbox which triggers the move of the specific rows to Sheet2. Sheet1 has columns that do not need to be copied to Sheet2. How do I prevent…
-
Display actual date among 3 date columns (forecast, planned and Actual dates)
I have 3 columns in Smartsheet. They are forecast date, planned date and actual date. I need a new column such that the condition should be if only forecast date is present display that. If both forecast and planned date are present, display planned date. If all 3 dates are present, display actual date. I tried to use this…
-
Report Sort Order Seems Broken
I have a list of products by t-shirt size, (S,M,L), i wanted the specific line items to be grouped and sorted by t-shirt size, but it only sorts them as L,M,S in alpha order. So i created a helper column called sort order which assigns 1=S, 2=M and 3=L. When i sort the report by sort order it works, but as soon as i group…
-
Where is the Owner field in Browse? It went away.
I believe this is due to the asset management changes happening. But is there any way I can get the sheet owner/project owner to show up in Browse again? I sort sheets by owner all the time and am now unable to do that.
-
Copy Rows to Another Sheet - Select Row Movement
Hello - I'm curious if there is a way to configure the Copy Rows automation to only included specific rows when moving to another sheet. My understanding is that when a row is copied, all columns are included in the move. Although I can hide not applicable columns, I was wondering if there was a different way of…
-
do I have to grant access to the source grid for others to view reports?
Hi, lets say I have a sheet with 10 columns. 7 with general information, 3 with sensitive data. Now I want to share the general information with others. So I create a report with the 7 columns and share it accordingly. The people I´m sharing it with keep saying that they are looking at blank pages. They might see the…
-
Sorting grouped report
HI Guys - i have report that is grouped by the primary column (which is the product code), it seems to only allow sorting by that primary column. Is that right? I used the SORT function and chose desired field and descending, but it does not work.Is there any work-around when rows are grouped? thank you