-
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?
-
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…
-
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
-
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…
-
Terminating a Team account
We have a Team account but no longer need to use Smartsheet. I've received a reminder that we will be receiving a renewal invoice in the next couple of weeks. I tried to follow the instructions in the help files to cancel the account via the Plan and Billing Info section of our account page, but there is no option…
-
Formula for Duplicates
I am looking for a formula that does not count the duplicates so that it can count unchecked boxes. Does anyone know of one?
-
I would like to be able to create reusable templates for "Send Update Request" similar to the Form f
I routinely use the Send Update Request 20 to 30 times each month for updates on items we are tracking. This process gets repeated across several other teams as well. My request for "Send Update Request" all contain the same columns which takes time to fill out as the Smartsheets have 40 to 60 colums to search thru each…
-
SUMIFS - Contains value in cell from another sheet
Hi All, I want to create a "Total Vendor Paid Amount" column on our "Main Dashboard". This column will need a formula that pulls information from another dashboard called "REO Vendor Invoicing (3)". I want the formula to sum the total invoices paid, in the "REO Vendor Invoicing (3)" dashboard, of jobs that contain a cell…
-
Limited Access to Report Builder
We have been using a very simple report to pull information from a single sheet. The report has been working fine for several months. Today I was notified (& verified) that I am the only person who can still edit the report via report builder. Everyone else is stuck viewing the information I last searched for and cannot…
-
Resource management at the project level?
Hi, From what I gather about Smartsheet's resource management feature, I can show which users are allocated (and over-allocated) given how they're assigned tasks in a project. I'm wondering if Smartsheet can do a higher-level allocation synopsis, whereby I can see simply that someone's completely allocated as a resource…
