Add Ons and Integrations

Archives for January 2020

Date in Dynamic View not editing
Hello, I have a couple of Dynamic Views where the date columns in the source sheet have the same setup (see figure 1), however one of the dates field in the view is showing as not editable (figure 2): Figure 1 Figure 2 It's important to note that the setup of the field in the DW it's not as "Read-Only", and the columns in…
Date field will not show any data
Hi, I have a date field that will not accept any data. If I type anything into it, it disappears after 1/2 second. The cell is supposed to get it's date from the predecessor column. This line should start the same time as the predecessor. Code in the predecessor column is "7SS" which should mean that THIS line starts the…
Live Data Connector
Live connector claims to provide "industry standard" connectivity to data sources. I have exhausted ways of trying to successfully use a UNION query in Access using linked tables. I would prefer not to use Access, but ODBC forces me to use Access or Excel because those are the only tools available enterprise wide for my…
Is it possible to post to the Smartsheet form with a third party tool?
I am trying to add data to a smartsheet using a post to html integration to the Smartsheet form. Is this possible. I get a success message when testing but no data is entered.
Calendar App - multi-select filter
Hi, can someone point me in the right direction? Can a category filter in a calendar be multi-select, so you can see all selected categories activities in the resulting calendar view? We have a category filter on market priority and would like to be able to offer a multi priority view. If possible, how do we set this up?…
Date Field not editable in Dynamic Views
i have a date field that won't is not editable in dynamic view and it is not a calculated field. Any thoughts?
GMail/SmartSheet fields not carrying over into SmartSheet
Hello, I've been using the GMail/Smartsheet add-on for several months and have not changed anything but today one of the fields in the add-on is not carrying over into the Smartsheet as it always has. It is working for some of my staff but not all. Any ideas on what may be causing this and how to fix it? Thank you, Heather
Is Dynamic View faster than a regular sheet
Hello, I have run into the issue with a Smartsheet being slow due to the complexity of formulas I have created. I was wondering if anyone knew if using Dynamic view results in less lag than just filling in the sheets. Just wanted to double check before I spend the time building it in case it has no effect. Thank you
Is there a way to make google sheets exports go to a specific folder on your google drive?
Is there a way to make google sheets exports go to a specific folder on your google drive?
Datamesh from a summary report
hi! I am trying to build a means to automatically forecast vendor costs, based on a count. I have a large sheet that contains an intersection of many Locations and the Scopes that will be applied to each location. I have different vendors servicing my various locations. I have created countifs formulas to count the number…

Trending in Using Smartsheet

Flagging this Month or Last Month
I am trying to create a helper column to flag something as occuring "This Month" or "Last Month" This is the formula I'm using. =IF(Date@row = MONTH(TODAY()), "This Month", "Last Month") It is saying #INVALID OPERATION. Not sure what I have wrong here.
PDF Attachment Downloads
We used to be able to click one time on the PDF symbol to open our documents, but now have to click on the three dots and then get this menu and select open in new tab. The single click still works if we are opening a Word document, just not with PDF. Is there a way to get this function back?
Percentages not displaying correctly in Report Summary
Hi, In this report. I want to total up a number of percentages coming from different sheets. Sometimes the percentages add up as percentages, sometimes they display as an fraction. The source sheets are all from the same template, so should be formatted the same way, though I have noticed that certain files seem to be…

Add Ons and Integrations

Discussion List