-
Smartsheet Roll Out
Does anyone have advice on how to successfully roll out Smartsheet in a smaller company (30 people)? We purchased the deployment package but I'd like to hear from other users what challenges you encountered and how you overcame them. Does anyone have a project sheet they used for deployment they can share?
-
Opening a Report from a Chart Widget
I have a dashboard with a Chart widget. The "Edit Interaction" behavior is set to open a Smartsheet item, specifically a report. Is it possible to open that report in a separate browser tab? This is my second dashboard, and I'm struggling to see how to make that happen. My first dashboard was prior to the last Smartsheet…
-
NETDAYS #INVALID DATE TYPE
I can't figured out why #INVALID DATA TYPE auto fill when I haven't pick a date for the start and finish date. If I do have those fill out then the formula works fine but otherwise it just fill the duration cell with that error. I do have the duration column under Text/Number. The only thing that I can think about is that…
-
Updating Rows on different sheet assigned to a user?
Dear All,new here, apologies if this has been discussed before, couldn't find anything. A question regarding the following scenario: Imagine a sheet (sheet 1) in which a user/department ads their requests assigning a task to a specific user/owner. Is it possible to update the sheet of the owner only when a task is assigned…
-
Google Calendar Sync
Hi, I have successfully exported a calendar to Google, however, it is not syncing properly with updates made in Smartsheet - and has an automatic disclaimer posted within the Google calendar Settings that reads: "NOTE: Smartsheet sync is disabled for this Google Calendar." How can I remedy this? Thanks for your help
-
Nested Formulas
I am attempting to use the nesting formulas to auto generate text showing the status of a project step that is co-dependent on several previous steps, but only when the previous steps have been selected. For instance,we have an "Assigned" column which is just a check box, a column which indicates if that task is complete…
-
Hyperlink to Cell in same Sheet
How do I hyperlink a cell in the same Smartsheet?
-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Forms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
Sort, Second Sort, Third Sort (then by, then by)
Trying to sort, then by, then by. Anybody find a work around, second and third sorts pushing tasks to the very bottom of first sort. When the first sort has exhausted all available data I would like items that meet second sort criteria to start in, not be pushed to the very end first sort.
