-
Track time an item was open (active)
I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ? I have ideas but have found it makes most sense to run it by one of you first.…
-
Vlookup Limitation?
Hi I would like to understand about this limitation in vlookup: * Each sheet can include no more than 100 distinct cross-sheet references. * There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total.…
-
Formula to check a box when date entered + 2 days
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically complete. This is the formula…
-
Does Smartsheet have a way of showing hours spent working within the account?
I work at a manufacturing company & have implemented Smartsheet to be used within every department. Right now I am currently the only admin who creates and/or updates the sheets, reports & dashboards etc. We have over 300 active sheets. Needless to say, it has become a full time job all by itself. Unfortunately, I also…
-
Resource Loading
Hello - The manufacturing site I work at uses Smartsheet to track site priorities. I would like to do resource loading analysis, similar to the functionality that is available in Microsoft Project. However, to do that all resources must have a business license before they show up on the resource list. This is cost…
-
Notification
Hi, I have an action plan with an action column, a delay column, a referent column, and a progress column. I would like to create a workflow that sends a notification (mail) to the referent of the action 3 days before the date entered in the column "delay" if the progress is not "finished" in order to remind him to finish…
-
System Column - Last Modified
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
-
Sorting sheets in a workspace
As of this morning, I have found that Smartsheet is defaulting my sort order to Name. I can change to Last Update on a specific workspace, but when I click into another workspace, it defaults back to sorting by Name. Previously, the sort would stay with the last setting. As I prefer to sort by Last Update to quickly see…
-
Seeing user activity as an admin
I am an Admin of our account and want to see what smartsheets are owned by each user and the activity on each sheet (date/time). Logs only shows me logons. I need to verify that licensed users are really using the product. I put a ticket into support a week ago but never heard back. Hopefully I can get a response here.…
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
