How do we set up our Smart sheet in MS Teams so when comments are made and a user is logged on, the comments will track date/time stamp and the user name? Currently, if a comment is added thru teams it only shows published user.
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…
im using this for the 1st time to fetch data from a one drive excel sheet, if i choose replace as a option on uploader the data is not refreshed when the source data changes, however if i pick replace, then all the data is refreshed, but the formulas i create a now deleted as its a replace (even linked cells to another…
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.
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…
Hi, Has anyone part of the community done any sort of integration between Smartsheet and the online accounting software - Xero? I have come across websites like Zapier that can do the job for me but they require some sort of manual intervention in between. I am looking for an automatic synchronisation of our finance data…
I'm creating a new view in Dynamic View and I have enabled new item submission as well as user can display and add attachments. Unfortunately when actually drafting a new item submission I do not see an option to add an attachment the same way I would in a traditional form PRIOR to submitting the item. The attachment…
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?
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…
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…
Hi all, I'm hoping that someone has solved for this, or that I'm being blind, but I can't see a way to easily read a array of objects using Bridge, where those objects contain multiple fields, and then loop through those objects. I have an example below that I was able to make work by combining columns and extracting from…
I have a smartsheet that contains task records for for different departments. I would like to create a Dynamic View for each department that everyone in the specific department can see that only contains the records associated with that department. I can create the filter without a problem, but when I try to Restrict view…
It says I have 101 records to add. But I get this error message: error code: 1302; message:
Help shape the future of Smartsheet. Share your ideas and feature requests.