-
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…
-
import csv or other file into existing project
We have been working with Omni Plan and would like to import existing project management schedule files into our SmartSheet projects that have already been started. Eventually we'll do all the project schedule management ( we're a construction company) as part of the sheets but we're new at this and I don't need to stress…
-
Smartsheet for Outlook is here!
Today we are excited to announce Smartsheet for Outlook (beta) for Outlook Online (Office 365) and Outlook 2013 desktop (Windows) and Outlook for Mac (Mavericks or newer)! This app allows you to create or edit Smartsheet tasks directly from your Outlook inbox. You can also add e-mails and their attachments directly to rows…
-
Identifying Main tasks & Sub tasks / Identifying last child nodes in hierarchy
Hi All, I'm new to Smartsheet. I would like to know how could I get to know a task is a Main task or Sub task using Smartsheet APIs, My requirement is to consider all the Subtasks (Child rows) in a smartsheet for some calculation purpose. When I see a smartsheet, I can do indentation and I can recognise which is Main task…