-
Freeze a row?
Has anyone discovered a feature to "freese a row"? I'm aware of the freeze a column option but have not found a way to freeze a row
-
SmartSheet Calendar App
First off - love it. Totally has changed how we are communicating with internal project teams and external vendors. What isn't working that great: Speed - super slow to access Email Comment Notifications: it would be great if the email notifications could show the comment and thread (if any). Nice to be able to get a quick…
-
Dashboard Color
Any plans in the future for letting us update the dashboard background color to any color we'd like? I'd love to be able to use black for dashboard backgrounds, as well as the backgrounds of the widgets, so that when on TV sets around the office, graphs are floating in black instead of a white background.
-
Scheduled Reports Not Generating
I have set up several recurring scheduled reports to be run this week, and NONE of them have run. I am using the "Send as Attachment", "PDF", "Schedule to send later or on a recurring basis", I set it up, then hit "Send", and the recurring event appears in the "Sent to" field with the circular arrow icon to its left, but…
-
Percentage Complete Calculating Differently on 2 sheets
I have a smartsheet that is pushing data to another sheet. Percentages complete are part of the data that is being pushed. On the source smartsheet it shows 45% for a section. On the Target sheet it shows 63% complete for the sames rows. Can anyone explain why I am getting 2 different percentage completes calculated?
-
Exporting Gantt View to PDF
Hello, Is there a way to export a Gantt chart to PDF and also include an image in the file? Thanks! Andrea
-
if function for 3 criteria
Dear, I am planning to write an if function for 3 criteria. IF(AND([In Progress - Late]1 >= 1, [At Risk]1 >= 1),[In Progress - On Track]1>=1,) "Red","") I know I am writing it wrong. Can anyone help me structure the formula please? Cheers!
-
Opening Drop Box attachments via cell phone app
All attachments for my Smartsheet program are from my Drop Box file on my computer. Staff with access have not had issue accessing them within our network. A staff member has indicated he was unable to open a file from the job site via his cell phone. I have reviewed Drop Box Help and SS Community and have not found the…
-
Option to create Multiple Parent Roll up functionality? I created for Actual timeline by using Proje
Hi, Can anyone help me on this. I have enabled Parent Roll up functionality for Actual timeline by using project setting as refer to 1st screen shot. Same way I tried to add duration and timeline for Planned Time line but it is not auto calculating as i notice at single time we can setup parent roll up functionality for…
-
Countif on filtered list or a range based on a value on another column
I use the following function to count "=COUNTIF({Cell Range 2}, 0)" numerical values from a column. However, I should only count the cell values when a cell value in the same respective row but in another column is blank. Not sure how to proceed.
