-
Dis-aggregate SS start and end dates in exported Excel
Hello, I am trying to see if any of the Excel wizards here can help me with a script or other macro that will disaggregate my SS exported project sheet data that contains start and end date columns (along with the usual duration column) information into individual rows for each day/date that is bounded by the SS start and…
-
Can you make reports from reports?
I'm trying to flither information from one report to another and combining certain information. Is there a way to do this without starting with a new report?
-
sending comments to users emails
I'd like to have all "comments" between users be cc'd to the users gmail accounts. How do I go about that?
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
Jira smartsheet workflow optimizations
Hello, I have some suggestions for adding to the workflows * - If a smartsheet column has the same name as a jira field directly select it in the dropdown; * - The posibility to add field templates to select in the workflow, this way you can add a predefined list from jira fields; This would make adding workflows a bit…
-
Smartsheet API Webhook basics
I want to update a note in Nutshell CRM when a smartsheet comment is updated. I'm just focusing on the smarsheet webhook at this point, and I have read the webhooks section on the smartsheet API documentation and I still have no idea how to send the request. Where does this stuff go? curl…
-
Linking OneNote
Hi, Is it possible to link notes taken in OneNote to a project sheet?
-
Accessing HomeRessource of specific Users via JavaSDK
Hi there! I'm developing a statistic tool for monitoring file creations with smartsheet in my company. First of all, thanks for the brilliant Java SDK, that makes live so much easier when trying to integrate Smartsheet in other applications! Currently I'm at the point where i have to access every user's home directory, to…
-
Continous Merge (Real-Time)
Hi everyone, I am new to Smarthsheet, and I just figured out how to merge a Smartsheet with a Google Doc and automatically send it out in an email. Do you know if it is possible to do this in real time and not as a semi-batch process? Once a new smartsheet row is added I want it to automatically merge and send via email if…
-
JIRA Integration: automatically fill in "Start Date" when a Status has been changed?
Hi Smartsheet Community, We've integrated JIRA into Smartsheet. We're looking to automate some more fields. When using the gantt charts, some of the field we are manually filling are and Start Date and End Date. Is it possible to accomplish the following? 1) When a JIRA [Status] has been switched from To-Do --> In Progress…