-
sFTP as Source Location for Data Uploader
Hello, My organization would like to be able to use an sFTP site as a place to pull Excel files or data uploader. Is there a way to accomplish this. We currently only see Smartsheet attachments, Google Drive, and OneDrive.
-
Numeric Field instead of Text in MS Forms to Power Automate to SS
Hi, I have a MS Flow (power automate) that adds a new row to SS when an MS Form is submitted. I have additional columns in the SS that are not in the form for formula purposes. When the Opex and Capex cost come in I think they come in as text instead of numbers (field is numeric field in form). Complete price is supposed…
-
For Jira Connector, I would like to be able to create Workflows for others as well as assign them
I'd like to create workflows for others to use and also be able to hand over ownership of the workflow, the same as you are able to do within SmartSheets.
-
How do I create a more complex Bar chart and get it into a dashboard?
I have a multi-metric Bar chart that so far works well in excel. It currently has 3 reported metrics: Prior Period Milestone, Current period Milestone, and Target Milestone. I used the transparency and stacked graph features to make this work in excel, which I could not figure out how to use in Smartsheet. I could use some…
-
Archive only if Project is in the Past
I was trying to set up an archive rule that has a condition of if the project status is Complete and if one of the dates in the profile data (the end date plus one year) is in the past.. can't seem to figure it out. Obviously, the completion status is just weather or not blah is "Complete" or "100%" or whatever you key off…
-
Dynamic View
I am trying to use dynamic view for clients to approve their own tickets that are coming through. I have shared the dynamic view via the domain name - but the users in that domain cannot see anything in the dynamic view. I have tried it myself and it works fine. Any thoughts or ideas?
-
How do you pull information from the selected sheet when building a project using Control Center
Here is the situation: We have setup Control Center to build a project workspace from sheets. There are also several dashboards and a separate summary sheet. We are pulling information from the separate summary sheet into the dashboard. A number of other sheets (currently 5 but this will grow) have been identified as a…
-
Control Center API
If there an API for creating projects using with control center ? Let's say i've a matchin row in the intake sheet and user doesn't need any specific information to be set and i would like to create the project through the api, and once created to edit some information reative to that project. Is it possible, and if yes…
-
How do I change chart data in a dashboard from sheet data to summary sheet data
I am building a dashboard and initially using sheet data to build a chart. I want to add another chart to the Dashabord referencing the same sheet but this time round use the summary sheet data. I don't see an option to switch from sheet data to summary sheet data in the sheet. I only have an option to use the sheet data.
-
How do I fix this
This is the message I keep getting when I try to log on to smartsheet with the addon through gmail suite. "This action is not supported while logged into multiple accounts in the same domain or multiple consumer accounts. Please log out and try again." How do I fix this?
