-
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…
-
Is there a prettier way to write this formula?
Is there a prettier way to write this formula? =IF(MONTH(Finish@row) = "1", "Q1", IF(MONTH(Finish@row) = "2", "Q1", IF(MONTH(Finish@row) = "3", "Q1", IF(MONTH(Finish@row) = "4", "Q2", IF(MONTH(Finish@row) = "5", "Q2", IF(MONTH(Finish@row) = "6", "Q2", IF(MONTH(Finish@row) = "7", "Q3", IF(MONTH(Finish@row) = "8", "Q3",…
-
Is it really free in app store?
On the website, it lists the pricing as the following But in the MS app store, it is listed as free: The only thing that is blocking me for trying the app is that it requires a work email and my phone number to proceed. Can someone clarify whether it is indeed true in app store? And what is the "price" to pay? (Giving out…
-
How to restrict by Filter in Dynamic View?
I remember there being an option to restrict a view in Dynamic View by a filter that is in the source sheet. It is no longer where I remember it being in the settings under general info. Can you tell me how to find this? I changed my filter so that it is not shareable. Will this result in the viewer only seeing the…
-
Favorite a Form in the App
Hi is there a way to favorite a form in the app.. every time there is an update with the app - my staff lose the forms in their recent tab and i have to send it again. so is there a way to favorite the form so i don't have to go through this exercise with 500 people every time there is an update. This form is important…
-
Project Provisioning into its own workspace
I have a question regarding provisioning a project into a work space using control center and tiles. Here is the scenario Lets say I offer 10 different project types. So I have 10 different workspaces that then can get created specifically for a client based on what project type they purchase. Client purchases project type…
-
Copying data from Smartsheet to Excel with Power Automate
Hey all, I'm trying to back up my smart sheet important data by copying it into an Excel sheet. The issue is that I get array of rows that should be the column of the row that was copied from smart sheet. See attached pictures. I don't understand why I cannot get a variable for each column in specific row Data On smart…