-
Template for project management
I need a template for project management for land development projects wherein I use multiple people/employees with various tasks in order to obtain permits and complete engineering plans. There are milestones for completion, various correspondence such as emails etc which I would like be able to log and if possible open…
-
Sort while Filtered
Where do we stand with the ability to Sort while Filtered? I've seen this mentioned as a feature request before. This really is a shortomcing. This would be especially useful when dealing with Task lists. I don't want the completed tasks deleted, but I want to filter them out, then sort by due date. Unfiltering to sort,…
-
How to organize smartsheet for multiple column updates monthly
I would like some suggestions on how to use smartsheet for my application which collects data for a metric. For my application, I have 50+ projects that are spread across multiple businesses. For each project, each month the owner needs to enter 4-5 data values to report the monthly metrics for their project. We need to…
-
Retrieving Lost Data
I realize that this is a shot in the dark and I know it wasn't possible in the past, but does anyone know if it is possible to retrieve data that was deleted from a sheet after the sheet was then saved. If there's a way to get this back then let me know. Thanks!
-
Amazon Web Services
Is the S3 vunerability patched yet so that we do not have a repeat outage like we did at the end of February? Or are we still at the mercy of AWS?
-
Parent Date Roll Up
I currently have a sheet where i have multiple columns with dates thats that are going to need to roll up to the project level parent. I am looking for a way to roll the dates without using the predcessor function as it doesnt quite work right. In the picture below you can see some of the columns. I would like to have the…
-
Generate a word in a column if an item is added to a list
I am trying to build a formula so when a number is entered into the Lot Number column, the cell in the next column over (Lot Status) will automatically generate the word "Available". I have tried the following formula with no success: =IF([Lot Number]:[Lot Number] = 1, [Lot Status]:[Lot Status] = "Available") Please note,…
-
Summary Report of Multiple Sheets: Modified Date
Hello, I would like to creat a report/sheet that lists multiple other sheets, and returns information on either the "Modified By" or the "Modified Date" (or both), for each sheet. I'm trying to monitor all activity across 20+ other sheets, to tell when each sheet has been updated. I know our SysAdmin can run a Summary…
-
I cannot get the search query api to work - it gives partial matches
I've tried using postman and single and double quotes do not make any difference either I can filter the results but it seems like i must be doing something wrong https://api.smartsheet.com/2.0/search/sheets/798272320235396?query="'Elliott'" returns { "results": [ { "text": "White cottage", "objectType": "row", "objectId":…
-
ghost sheets auto loading upon sign in ?
A business partner gave me access to this site and originally created a smartsheet called GS Master Directory (View Only). From my understanding this sheet no longer exist and although each day I close it before logging out of my account, it still auto loads the next day. The sheet is not that large in my opinion however…
