-
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.
-
Project end date - Metric
Hi I am trying to create a metric for a Sight sheet to show countdown in days and another in weeks until a project starts can anyone help ? Cheers Neil
-
Smart Sheet Expert User
Seeking a smart sheet expert user able to to offer consultancy services. Wishing to use the software as a database to read and report on a number of sheets.
