-
Reports and folders
Hello, I'd like to ask if reports are pulling data from sheets in folders just the same as they pull from a workspace? Assuming the report set for 'Where' as the whole workspace and I move sheet from the workspace to a folder inside the same workspace, will I see the same data in the report in those two options? ...Looking…
-
Don't want dates showing
Hi, we are planning a home construction project and are not sure of dates. Is there a way just show days without dates, and exclude Sat/Sun?
-
Report on multiple projects
Hello everyone, hoping you have an excellent day I need advice with the following situation. Projects registered with this info: personal information of the client is classified, the services requested and the phases of the project itself, creating task´s and subtask´s all this is one document. However, we need to see…
-
Need Help - Can't Wrap my Head Around SS Logic
I'm trying to build a metrics table that can be used to generate a graph on a dashboard. I am a consultant and would like to track client hours from a master sheet that logs all clients, dates of services, and total hours. Let's say I wanted to track the hours of utilization from a particular client from YTD, Last Month,…
-
Why a 10 Sheet Limit on Individual Plans? 10 sheets cost $168/year. 11 sheets cost $900/year?????
I love this service but it is killing me that in order to have 11 sheets, the Yearly Cost jumps from $168 to $900. How does that make sense? And if I want to have a template, that template counts towards the 10 sheet limit? I can see myself paying for this service for years and recommending it to everyone (I have stopped…
-
Updating exciting sheet with imported data
Hi I'm building a report on a sheet, I'm looking to update this sheet with imported data weekly so the reports will update automatically. I can't seem to update the existing sheet with an import or have the ability to save over the sheet. is there a way of either, importing data into an exisiting sheet or being able to…
-
Project tasks in order but not date dependent
I am trying to set up a sheet that uses a gantt chart to track the timeline for a project with multiple steps that must occur in order. My goal is that the tasks must be completed in order and nothing can be done on the task until the previous task is signed off as completed by the owner. Ideally there would be an alert to…
-
Help with Weighted Average w/ a Nested If Function
I have a Text/Number Column with the following nested 'IF' function generated Percents based on a status column: IF(Milestone3 = "Proposed", "0%", IF(Milestone3 = "In Progress", "10%", IF(Milestone3 = "Assigned to QA", "20%", IF(Milestone3 = "QA in Progress", "30%", IF(Milestone3 = "Ready for Staging", "40%", IF(Milestone3…
-
Date Fields
As the owner of a Smartsheet spreadsheet, I have set my regional preference to English (United Kingdom) so the date is dd/mm/yy I have Admin that update a date field where the column property is set to 'Date' and restricted to 'date only'. This column is locked to Admin. We have a number of Editors (in the USA) who are…
-
Give Specific User Editing Access to a Locked Column
I am looking to give a specific user access to editing a locked column. The background: We have a list of projects that are NOT to be started until our finance director approves said project. As the project manger, I am owner of these sheets. To prevent other users from approving projects of their own will, I have locked…