-
Filtering Gantt chart on mobile app
Hi I have a sheet with a number of preset filters, and on my pc, i can apply the filter on the Gantt chart views, while this does not seem possible on the IOS application. Anybody can help with how to do this on the mobile app? Thanks Eid
-
New sheet based on filter?
I created a filter which only shows the launch dates. I'm trying to export these dates to iCal but whenever I do the filter is not applied within iCal and it includes every subtask. I figure a work around would be to make a new sheet with only the filtered launch dates and export that to iCal, however I can't figure out…
-
SUMIF with OR condition
Hi. We have a calculation that will total various costs based on a manager. It works fine if we only need to include costs for a single manager. However, it doesn't work if we want it to total costs that might be related to more than one manager. We're using an OR condition when checking for the manager. Can you please…
-
SIGHTS - WOWZA!!!
My workplace just moved up to Enterprise, and I'm loving what I'm learning about Sights! Finally, a place to share information without having to share the underlying sheets. Beautiful work, Smartsheet!
-
Formula for RYG based on % complete
Trying to get RYG symbols for % completed on tasks. I am getting #UNPARSEABLE =IF([% Complete]4 = "100%", "Green", IF([% Complete]4 = "50%", "Yellow", IF([% Completed]4 = "0%", "Red", " "))) Can anyone please help?
-
Option to Open to Today's Date not saving
Hello, Not sure if anyone else has seen this but when I select the Timeline Display option to Open to Today's Date, the option doesn't save. I need to select the option each time I open the sheet. Seems like a bug or I'm missing something. Thanks
-
Alerts & Actions - Update Request
With the new feature to send update requests automatically (Awesome feature by the way), I've noticed a few draw backs to this option: * the request no longer grabs the primary column information but the sheet name. This makes the request pretty generic to the recipient instead of specific to that row * There is no ability…
-
Unable to access specific sheets
Hello, Has anyone lost access to a sheet due to a generic Ajax error and had it successfully fixed? We have a Enterprise account with hundreds of users, yet none of us are receiving timely communication or any resolution plan from Smartsheet support. Have any of you run into this before? I am very concerned we are going to…
-
Community Suggestion: Submit Product Enhancement Requests
Every once in a while, I get an idea and wonder why I did not think of it before. When you see a post on the Community that asks for a feature, enhancement, or bug fix you want, click on that "Submit Product Enhancement Request" link to the right. Capture the link for the post you are referencing and say "See this post"…
-
Highlight work starting on a weekend
I was planning to use =IF(OR(WEEKDAY([Start]1) = 1, WEEKDAY([Start]1) = 7), "Weekend", "Weekday") to highlight work starting on a weekend.Where 1 is Sunday and 7 is Saturday. And then use Cond Format as suggested by Greg Gates. Says "Unparseable" My Start is Date job starts column and Weekday is column indicating weekday…
