-
Sharing Sheet with Filter only
Enhancement Request: Our company needs the ability to share a sheet with two or more providers and due to confidentiality we need that information to be filtered and locked in the filter so they are unable to see the general sheet. But we still need for the provider to be able to make changes to the sheet with their…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Please move "Refresh" to the toolbar, and give me a keyboard shortcut.
I would really like to see "Refresh" added to the toolbar. I think a lot of other people would too. Synchronizing changes with other collaborators in near-real-time relies on hitting refresh repeatedly. It's hidden behind a drop-down. Getting new users to refresh (or save) consistently as a matter of best practice has it's…
-
Project Management - IF(OR(AND())) - Formula Help
I've been working on this for some time and just can't seem to get it to work the way I need it to. I am attempting to build one sheet that will allow me to track the status of all the projects in my section, while also tracking the progress of tasks within each project, for both current and historical projects. I have…
-
Trying to add a Sheet Data widget to a sight
Hi, I'm trying to create a Project management Dashboard but for some reason, when I click on "add a widget", I don't see the option to add a Sheet Data. Does anyone know why and how I can do this? THanks! Carine
-
Project Management Plans - allowing for annual leave days
Hi all I am currently compiling a project plan to manage various peices of work within my team. I have columns for start and end dates and a duration (in days) column. What this doesn't take into account are days that my team are out of the office (on annual leave, for example) and not working on the projects. What would…
-
Smart Sheet Freelancer Required
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be able to use the advanced functions of cell linking and formula to create forecasts.…
-
Mobile App Update Requests
Is it possible to track update requests in the mobile app? I know we can send update requests from the app. But, I don't believe we can view update requests that have already been sent. Please prove me wrong! Thanks, Dustin
-
Need help with date range overlap formula
Please see attached screenshot. I use the "Duplicate" column to show whether or not there is an overlap in the date range between new entries and the "Start Date" & "End Date" columns. In Excel, the following formula works great: =SUMPRODUCT((D2<enddate)*(E2>=startdate))>1 I know that Smartsheet doesn't support SUMPRODUCT.…
-
Duration Calculation not accurate on my sheet
Duration column on my project includes Hours and Days depending on the task. However, the duration count is inaccurate.
