-
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…
-
Date that works with drop down list
Is there a way to create a if statement that works based off the selection of a drop down list, and if that selection hasn't been made by a certain date is displays "incomplete"
-
Filter rows based upon unique value
I created a report that retrieves the Assigned To column field for all of the rows in a project sheet. There are several rows where the same resource name is shown in several rows. How do I filter all of those rows into a list that includes just the unique resource names for all the project rows? Do I need to do some…
-
Multiple Assigned To with Actions
With the new ability to put multiple names/users in an assigned to field is there a way of getting approvals from all of them. I'd like to say, request approval from all names in the field and store each of the approvals in a column. Thoughts? Scott
