-
Email based on cell value?
Is there a way to send an email containing the data from a row automatically based on the value in a cell? For example if they choose "Accounting" from a dropdown list or contact list in the "Department" column in row 1, then it would email the data from row 1 to the address on file for the Accounting Department.
-
Google calendar tab hyperlink from home page
Mike here from Australia - can you tell me is there a way to hyperlink from the Smart Sheets home page I want to make a google calendar tab that hyperlinks directly to my google calendar and not via a cell in a sheet - see attached image and tab, I would like to be able to click the tab to open an external link - any way…
-
Moving specific cells from a row via Zapier
Curious if anyone encountered such problem or simply has a solution for it. We use Zapier for automation and in particular cases when Zappier is triggered to move a row to a different sheet we only need certain cells in that row to be moved. Is such thing possible using Zapier? Any help is highly appreciated, thank you in…
-
Sporatic Error, using the API.
Hello Everyone. I have another weird error. the spread sheet I am making is 35 columns across and 270 rows down. I do batch updates exclusively. And I also time my updates to the most updates are 160 a minute to not overload the Server(a 200 ms delay between updates). sometimes mid way through the updates Im getting *…
-
A Formatting Glitch, using the API.
Hello. I have developed a Script (Powershell), that will create a complete smartsheet. This smart sheet is created with colours based on various times on the source data, (Late, ontime, etc. ). My problem is when I update it again, the first column will keep the shading of the previous entries. even though I specify a…
-
feeding SmartSheet data to Google Earth
Hi, I'd like to take survey data entered into rows of SS and output it to Google Earth. Obviously I can do this with exports from SS and imports into GE, but I'd like to be realtime. Is this even possible? Is anyone doing something similar?
-
Smartsheet App - Loss of Predicitve text on iOS
Hi all My team and I use the smartsheet app on mobile devices and find it amazing and quick for what we need....until the recent app update. The predictive text section has disappeared and has been replaced with an option to scan barcodes, again a highly valuable tool for what we need, but the predictive text loss is…
-
@Mentions needs login
If I mention someone in the comments, does the collaborator need to login and be shared to be notified or even notified without an account, as with updates requests?
-
hh:mm:ss Time Tracking in Smartsheets? (Probably not possible)
Howdy everyone! I've got a pernicious little problem that I'm wondering if anyone has any ideas about. My team and I currently track all of our break/fix help tickets in one dedicated "backlog" sheet. Each task that we need to complete is added to this sheet, gets prioritized, gets worked on, gets clarified (if needed),…
-
Gmail add on issues (Chrome)
We are heavy users of this feature, and today it is not working. When you select an existing task or try to add a new task from an email, the circle will spin for a few seconds and then stop with no action having taken place. We've rebooted to no avail. Is this a known issue and is there an ETA for a fix?