-
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…
-
Unexpected movement of rows
Hello, A sudden shift of rows happened while using smartsheet. The detail is as follows: Three people worked on a same spreadsheet. One was changing the arrangement of rows, such as shifting row 2 below to row 5, while other two were inputing data in some cells. Then, suddenly some data appeared in rows where no one input…
-
Trying to create a report to use on a dashboard.
How do I create an 'At Risk' report, from a sheet, to include on my dashboard?