-
Use triggers from Smartsheet?
Working on a new workflow. Today's workflow is manual and based on emails. I'd like to use the webform to collect the required data (done) and then, based on specific conditions in the sheet fields trigger actions in other system - from generating email to open a service ticket etc. I watched the movie of the docusign -…
-
Editing rows from Calendar or Gantt view of report not working
When I attempt to edit rows by double-clicking a row in Calendar view or Gantt view of a Report, I receive the error-message attached. I have searched the forums and guides, and cannot see anywhere why this should not be possible. It occurs with all my reports in both Gantt view and Calendar view. Re-login does not help.…
-
How do i get count of values against specific names
I have three columns . What i need is a formula to get details - If range responsible person is selected, what is the sum of target for each person seperately and in a similar way on the actual column what is the sum of actual by each person. The result i am look for should look like the one below. responsible person…
-
how to define who the approval is from multiples
I have migrated our Engineering change to smartsheets which is working fine. I now want to progress this by adding approval requests. We can get changes approved by 3 different people, so I have created an approval request which gets sent out once a box is checked to declare the change is ready for approval. At present…
-
Attaching OneDrive File
I'm having trouble attaching OneDrive files, but have basically narrowed it down to not being able to attach files that were shared to me from someone else. Problem is my boss creates the main folder then shares it with me and we work like crazy out of that one folder. So does this mean that unless I am the creator and…
-
Using Addition and Multiplication in the Same Formula?
Hello everyone, I am trying to calculate an amount based upon the sum of two numbers. If you look at my screenshot, the highlighted Hotel and Transportation budget amounts are based upon the # of Days Onsite plus # of Travel Days. I need the system to be able to add those two numbers together and then multiply it by the…
-
Post api call to import into smartsheets. 502 error
Hi - I have an Excel sheet of data that I' m using to convert into json and then import into smartsheet. It is authenticated and runs fine till it has to actually import the data. It errors out at uploading the data with 502 connection was reset by a peer. I truly appreciate any/all help. Thanks Mythili
-
Numbers importing as Scientific Notation
I am working with PO#'s in a smart sheet and joining this data with a SQL database to combine a few tables. I use a visualization program called DOMO that I use to import the smart sheet data and the SQL data and join within the program to make one dataset. The problem I am having is when I import the smartsheet the…
-
Parent Row Roll Up
I am looking to create a formula that will do the following: If all child statuses = Complete, it will say "Complete" If at least one child says in progress or complete, the parent row will say "In Progress" If all child statuses say Not Started, or are Blank, it will say "Not Started" I tried using this as a shell:…
-
IT Portfolio Rollup
Hi Community, There have been numerous posts about how to essentially rollup multiple smartsheet projects into a portfolio/dashboard to show overall status information about the portfolio. I get the essence of the various posts, but before going down those paths to figure-out how to build something from scratch, I'm…