-
Pivot Table App: Formula + Additional Issues
Greetings, Issue 1: I have created a pivot sheet using the Pivot App within SmartSheets. Once the pivot is created I am adding additional columns to the pivot sheet, which have formulas embedded. I noticed that when adding a new row of data the formula does not propagate in the pivot sheet, I am forced to manual drag it…
-
DevOps and Smartsheet integration
Looking to bring over epics into Smartsheet as a way to report on the portfolio of projects since DevOps is very limited in its view. Has anyone executed something like this?
-
formula help again
Hi again... I'm looking to count checked check boxes by the person who completed them based of a date previous month. i have 6 check box columns labled CPT1 Approved, CPT2 Approved, CPT3 Approved, CPT4 Approved, CPT5 Approved, CPT6 Approved. One column name CPT 1-6 completed by column One Closed date column. I'd like to…
-
Sending Rows with WorkApps
I can send a row if I launch the sheet from a Dashboard, but if I launch it directly from the workapp, the option to send is not present. Why is that? The screenshots below show the same sheet, one is launched from a dashboard in the workapp and one is launched directly as a page in the workapp. Note the missing option to…
-
Transfer Bulk Items -Dynamic View
Hello, Can I transfer my owned items in dynamic view in bulk? I understand I can transfer on the individual level, just need to know if I can in bulk, as I have a couple hundred items to transfer. Thank you!!!
-
How do I save a sheet I created
How do I save a sheet (board file) that I created and then add it to my dashboard? I tried many times to add it, but it doesn't appear when I try to add a report.
-
Open Row Attachments in Native Application?
For some reason our ability to open attachments (from Google Drive) to Smartsheet rows in their native application - .DOCX in Word, .XLS in Excel, .PDF in Adobe, etc. - has suddenly stopped and Smatsheet is only allowing us to open in Google Applications? Has anyone else faced this and how do we resolve this problem...
-
finalizing a formula help.
I'm almost there.. i want to count each checkbox but i'm getting a 1 when all the boxes have a check and a zero if i remove one checkbox. I want to total the checks every month. please help. with the below I'm getting 1 when all 6 boxes are checked and if I uncheck one the count goes to zero. thank you in advance - Anyone?…
-
Intergration: connector question
Hi Team, A quick response will be great help. I have a sheet 'A' which gets data from another sheet 'B' and its a link in form of cell linking or a column formula. and now this sheet 'A' i am creating a connector to transfer this information to Salesforce so i have this data(link) copied into Salesforce account. So my…
-
Jira Integration - Need to create burndowns for Epics
I am new to Smartsheet and even newer to the integration tool we just purchased (This week). I am, however, relatively proficient with Excel and have been using it to create burndowns for years. As I attempted to duplicate my Excel efforts within Smartsheet, I noticed that some of the Jira fields I use are no longer…
