-
Smartsheet Asian Server
Hi Smartsheet team, Is it possible for you guys to provide server in asia? Smartsheet takes longer to load here in the Philippines. Thanks, Dennis
-
Using Reports / Dashboards for Analytics Recaps?
Hey there! I'm currently tracking our sales analytics using a smartsheet. Column A lists all of my metrics and then i create a column for each week. As the weeks progress, i fill in the rows with sales data. I'd like to create a Dashboard that shows me the data from the last column (most recent week ending) on this…
-
Formulas Auto-Populating in a Newly Added Row
Everytime I add a new row in my sheet, I have to go in and make the formula go onto that new row. Is there a way to have the formula auto-populate whenever I add a new row into the sheet?
-
Attempting a formula with multiple criteria
Hi, can anyone help with the formula for the following required outcomes? * $0 if the management agreement has not started [Mgnt Start Date], * Equal to the chargeable amount [chargeable amt] if the Management agreement has started ie [Mgnt Start Date] in the prior month * Equal to the previous month [Jan 17] if the…
-
Publish Calendar to display working days only
I have a project that covers 3 months with 4 people traveling to various offices. My calendar indicates their locations throughout the months. I've defined Working Days, Non-working Days, and Holidays on a Project Sheet, which reflects correctly. However the calendar view indicates that the persons are in the locations…
-
Collaboration Error
Hi Smartsheet users - Has anyone ever experienced an error message when trying to "Send..." a row to another user AND CC themselves? The message says, "The collaboration service is not available". Any solutions? Thanks!
-
Restrict to login by ip address
Has Smartsheet got any functions to block by public ip address except single IP? My wish is to use only our local network in our office.
-
Best way to set up a sheet to track multiple IT projects
Our IT department has several projects we want to track. I need advice on the best way to set up the sheet(s) so that we can see the details of each project and have the ability to see all of the projects on one sheet. Which option would be the better set-up? Option A - Have one sheet that lists of all the projects with…
-
Can a Smartsheet form submitted auto-populate PDF then triggers DocuSign
Hi, I am trying to deploy a reimbursement system for my office. Once a person submits a form via smartsheet, I need to have a PDF pre-filled with all of the info including the ones that will be linked to other cells. Once the PDF is prefilled, I will need it to go thru DocuSign for signature. Once the user signs I will…
-
New row addition in sheet based on flag from seperate sheet
I think the request is best summarized as an example. I am using a sheet to track daily client updates. In those updates, I have a column that includes the client name and another column that includes a flag to mark if the client had an outage. When that flag is marked, I'd like for a row to be created automatically in a…