-
Data Loader Expression Input value
I am receiving a MS project file in an excel format and trying to load into a Project sheet in Smartsheet. I have a WBS column and from the WBS column by counting the dots I want to determine the level. The formula works fine in a sheet but when I write the formula on the expression input value as =LEN(WBS) -…
-
Ultipro to Smartsheet
I'm pretty new to Smartsheet and trying to figure out a new workflow. Currently all new job postings and job applications are captured in Ultipro. There is currently no integration between Ultipro and Smartsheet, what would my options be to move candidate data from Ultipro to Smartsheet so I can start building a candidate…
-
Exporting Red Yellow Green status to Excel (not using words)
When exporting a sheet that uses status symbols (such as the RYG status balls) to Excel, the symbols/graphics do not convert, only the words. How can I change this on the Excel document?
-
Manage Azure AD users in Smartsheet
Hi, Currently we have a Business Plan Suite, is there a way to manage our Azure AD users in Smartsheet? For example, We have our personal info filled in in Azure AD, how can I import this into Smartsheet? Thanks in advance.
-
Exporting graphs from a dashboard
Is it possible to export a graph from a dashboard? I'd like to be able to use the graph in a PPT presentation but can't find a way to export.
-
Importing Rules with Gantt from MS Project
Hi there! I imported my gantt from MS Project straight into Smartsheet but the end dates seem to be off by quite a bit, it isn't copying exactly in as I need it to. I then realised that have some rules in my MS Project that may not have carried over to my sheet. So currently in my MS Project gantt I have rules applied for…
-
Master Sheet - Exceeds Row Limit
I am struggling to figure out how to have a "master" listing of customers that can be referenced by various sheets via INDEX/MATCH cross sheet formulas when that list is too large. Here is my background: I have a master customer listing of 6200 customers. I use DataUploader to upload this into 3 sheets due to size…
-
Row Gap issue from Web Form entries
I have set up an estimating log, which is populated by web form, we are currently experiencing issues where certain rows of data are being populated between 2 - 20 rows below the last entry has anyone else experiencing this issue and can advise how solve the issue?
-
Reports Exportable to Outlook Calendars?
Hi there, Are customized reports able to be published to Outlook 2013? Thank you!
-
Forced dates when dependency is enabled
We are working to importa 1800 line project plan into smartsheet and have run into a dabilitating problem with the dates. What looks to be happening is that the “Duration” and “predecessors” fields are completely driving the dates for the tasks. Anything with a predecessor is automatically forcing the start date to be the…