-
Date Logic - Weekends versus duration
I'm hoping someone in the community can help me understand the business logic behind the way durations are calculated over weekends in Smartsheet. For context, my sheet has out-of-box settings for working days and hours - Sat and Sun are non-working days, M-F are 8-hour durations. Looking at the attached example, I think…
-
Embed a short survey in email signature
Hello, I don't know if I can do that but I thought I'd check with the community. I want to embed in my email signature a short survey "How did I do: Great/Good/Poor" with three buttons. But I don't want the form to pop-up, I want each button to feed directly into the Smartsheet. For example, clicking on the "Great" button…
-
Creating a Master Sheet Composed of Dependent Dept Sheets // Sheet Linking // Sub-Sheets
Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here is that while only I may have access to the the "Company All" the dept heads have access to their respective Department…
-
Web Content Widget - Having to keep logging back in
Hello, I'm pulling in specific information from an online excel doc to a dashboard I created. Each day or every other day, I keep having to log back in to view the data in the dashboard. Is there a way around this? Is there a setting I need to update? Thank you, Sean
-
C# API Add Records from MS SQL Server
Hello, I'm trying to get records from a SQL table into Smartsheet using C# and ultimately SSIS (via script command). I'm stuck on how to add the rows into Smartsheet. 1. I want to add the rows dynamically without having to code the column id. I see that there is Bulk Operations but very little documentation for it. This…
-
Smartsheet API - document generation and attachment to row.
Been struggling a bit with recent smartsheet api development and was hoping for some insight as to how to handle the following situation: To bypass the restriction of 5000 rows per sheet, I'm developing an app using NodeJS sdk that will run on a scheduler in the following fashion: If row count is 4500, next time this app…
-
SmartSheet - JIRA Connector
I'm using the JIRA-SmartSheet connector to export data from JIRA into Smartsheet. I use this frequently with a lot of success. However, I just noticed something that seems a bit odd. Sometimes, I will export data utilizing a workflow with a filter of 'Labels include...x, y, z' so that my sheet will include only a limited…
-
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…
-
Looking for a Guru to Build a Smartsheet + Quickbooks Solution
Hi I have a small engineering company 15 people that has not been able to find a real good Portfolio management solution so am considering creating my own with Quickbooks + Smartsheet. I use Smartsheet for managing commissioning projects so would expand this to include all of the 125 projects we currently have on the…
-
SignNow integration
Anyone successfully integrate SignNow with Smartsheet? What can be integrated? Can forms be autogenerated from data in Smartsheet, and form creating/emailing (using email, named, etc. in Smartsheet) and signing via SignNow be recorded in Smartsheet automatically (e.g., activate merge in smartsheet via a trigger, which then…
