-
Live Data Connection enabled for GE account?
Is the live data connection enabled for the GE account? I've been trying to access it as described in the help guide without sucess. Regards Christopher
-
Sending notifications to a specific user for any row changes
Hi, I want to send email/mobile notifications to only the "Assigned To" person when anything (including attachments/discussions) changes for that particular row. Please think of this scenario where a particular task is assigned to a specific resource. Now any changes to that task need to be notified to only that resource…
-
duplicate values
HI I have a project for procurement products I want to make an highlight the row if the same data is available in some other sheet. Can some one help me.
-
Cell linking - finding the next empty row on another sheet
Hi, Looking for a way to link a cell in each new sheet to the 1st column of the next open row in a summary sheet. I have a template sheet and summary sheet. I would like to create a number of sheets from the template and then display some info from the sheet in one row on the summary sheet. It looks like this is commonly…
-
Dynamic hyperlink from cell to external URL stopped working
Hi guys, I have been successfully using a formula to enter a hyperlink in a cell, using, for example, syntax like this: ="http://ServerName/Default?queryStringParameter=" + [Column Name]rownum This approach enables you to use the [Column Name]rownum syntax to dynamically create the URL based on the contents of other cells.…
-
Website form integration using API
I am attempting to use the API to add comments into a new row created by a form submission. I am currently adding new rows to sheets through forms on our website that integrate with (amung other things) the Smartsheet API. Our website utilizes C# so I am using the following code (partial) to submit to a sheet. Cell[]…
-
Copy links
I use link between sheets a lot. Sometime I have to link to the same cell a lot of times - but it is not possible to just copy another cell with a link. Could this be a possibility? It would make my work much easier, since it takes time to make the link to another cell in another sheet. Thanks.
-
RFI integration
Do you know if RFI chips in folders could be integrated with SS? Thanks for the info!
-
Any way to change the "predecessor"'s values via the API?
I know that such functionality is not supported, but I was wondering if maybe there are work-around. I am creating an script that bulk edits various sheets by starting from one sheet (useful if you want to synchronize multiple sheets) - https://github.com/EffEPi/smartsheet_bulk_edit The problem that I am having is that…
-
Microsoft PowerBI
Hi All, I just started using the data connector for Power BI and it is pretty slick. The one problem I'm having is that in smartsheet columns are formatted as text/number but can't be defined as a number only, power BI does not recognize these fields as numeric so it can't perform additional calculations on the data such…
