-
Apostrophe added on mass insert thru CDATA
Hello, We are currently using a third party tool CDATA to upload excel data to a smartsheet. When any numeric data is entered, an apostrophe is always added to the beginning of the string. Upon checking the logs, CDATA is not sending an apostrophe to Smartsheet. The only thing I can think of is Smartsheet is adding the…
-
Formula for Actual duration excluding duplication
Hi Community, I am trying to calculate the actual duration starting from a list of Start and End dates. What I am trying to achieve is to exclude duration overlaps in order to get the actual effort days only, but including not contiguous time ranges. Please see example: Start: 01/10/2019 End: 04/10/2019 = 4 working days…
-
Jira Connector only allowing one project to one sheet
Hi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects. We have a single sheet which is collating all enhancement requests (using a web form as a front end) which will place enhancements into the relevant Project…
-
Created Date Formula for Forms
Is there a formula that will capture the created date for new entries on a form? Once the form is completed, I would like a column to automatically populate the day that row was added from the form so I can track response times. Is there anything like that available other than the audit log?
-
Smartsheet Event Reporting McAfee MVISION Integration
The Smartsheet platform helps organizations transform work into dynamic work by unifying collaboration, workflows, and content management on one flexible, secure platform. It was built from the ground up with security requirements and protocols to secure your data and give you control of user access to safely share…
-
#CanDoCommunity Live Q&A: IT Administration and IT PMO
Are you an IT Administrator or do you use Smartsheet for your IT PMO, or are you looking for the best ways to use Smartsheet in IT? Join us Wednesday, July 15, from 10-11 a.m. PDT for our #CanDoCommunity Live Q&A! We'll have a special guest team of IT experts on hand to answer your questions about the evolving roles of IT…
-
*NEW: Proofing using Reports
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design requests via Reports so that they only see what tasks and designs are assigned to them.…
-
More customizable/specific sharing options
Hello all, I'm new to Smartsheet and am discovering the limitations when it comes to sharing. First, I'm surprised that sharing folders isn't possible. I understand that Workspaces are intended to make up for this but I guess what I'm lacking is the ability to choose specifically what I share within a workspace. What I'm…
-
Need admin approval while logging in Smartsheet
When the free users try to log in Smartsheet via app.smartsheet.com with Microsoft company account, some of them gets this notification. "Smartsheet needs permission to access resources in your organization that only an admin can grant. Please ask an admin to grant permission to this app before you can use it." Who is this…
-
Auto send a completed form to an email address
Hi, I am fairly new to Smartsheet, and was able to create a sheet and a linked form to replace our old HR blast process. My question is this, I created a form, and we have a list of users who needs to get an update/notified of all fields in the form when it is completed, however everytime the form is created I have to type…
