-
Smartsheet Reports are not getting saved and information is not showing
We are continously facing Smartsheet loading and saving issue. The reports are not reflecting and reports are not getting saved after we fill the details. Our entire organization is stuck at this point. PLEASE LOOK INTO THIS IMMEDIATELY. I have attached the screenshot.
-
Filtering Columns in Reports
I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the other data. 1) How do I restrict the datas in the columns that have to be shown 2) If out of 4 child rows, 3 pertain to one…
-
Smartsheet dashboard view
Hi Team, Can anyone suggest me how to create this kind of view in smartsheet.
-
Sales Pipeline - Period View
Hi, I have a few sheets of Sales Pipeline for each Manager. I have brought all of the estimates sales data together in a separate sheet and created a Dashboard using this. However, I would like to only see data relevant to the particular Financial Year in the dashboard. Any suggestions on how to go about this?
-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
Auto populate data and allow customers to update
Hi! I work for a membership based trade association and I'm trying to build a form that would allow me to share profile information on file with our customers (member companies) and then allow them to update outdated information. For example, I would auto populate contact information, # of employees, etc. and they would…
-
Integrate with Microsoft Access
Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
-
Integration with Oracle Primavera P6
Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6? We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible. However, rather than recreate the wheel, I'm wondering if someone has already worked…
-
Automatic roll up of the same Field?
I have an internally corrupted data base. Our people have been inputting the wrong/random ID numbers for the same Model #. I exported some of our data from our database into a Smartsheet to see if I could sort them. Below is snip of a 20,000 row sheet that I want to organize by model number and have all the same Model #'s…
-
Updating rows with multi_contact cell?
Hello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact column (with multi_contact enabled). I'm getting the error that I need to use…