-
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…
-
Advanced User Training
Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.
