Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
How to automate RYG balls using two different column values.
I am attempting to automate the RYG balls using two different columns, the End Date and % Complete columns. The logic is as follows: 1. If the end date is greater than today, the RYG ball = Green IF([End date]2 > TODAY(), "Green" 2. If the % complete is greater than .99, the RYG ball = Green IF([% Complete]2 > .99, "Green"…
Dear Team, Kindly help with the date and email id validation. I want to put 10 digit number validation in mobile number column and @ in email id column.
Remove user from shared worksheets
Several worksheets were shared to a specific user (email) but is not part of our user list found on the user management page. Is there a way to update this by bulk and not going through each worksheet? Unfortunately, some sheets were outside of a workspace. Thanks.
Constants and Variables
I believe that there should be a way of storing a few Constants and Variables as part of the sheet but not as cells on the sheet. These could be invisible to the User apart from the Owner or Administrator, and could be accessed via the sheet menu as part of the properties of the sheet. In the first instance I would suggest…
Web socket error while implementing smart search of Qlik Sense
I have followed the following code on github and cloned the directory. Qlik Sense smart search | QlikView Whenever I try to run the code, I am getting the following error. As I am very new to Qlik Sense I am unable to understand where the problem lies, can anyone please help me out on this? Regards SarahJohn
Gantt Chart Task Percentage Color
How do you change the color of the percentage indicator inside the bar of an individual task? In conditional formatting, you can only change the color of the task bar itself and not the color of the percentage of the task. Thank you.
Live Data Connector on MAC OS
I want to connect my Tableau Studio to smartsheet via the Live Data Connector. As far as i can see there is only an ODBC connector for Windows available. Am I able to setup the Live Data Connector on MAC OS? Toon
Can I attach a document as help text in a webform?
Hi there, I need to include a budget template in a webform I created. My initial thought was to embed a link to the template, but it does not appear to be possible to put a hyperlink in a Smartsheet webform. Can I attach a word doc/excel spreadsheet to the webform help text somehow? Best, Molly
Calling All Email Marketers - Approval Workflows with Smartsheet
Any email marketers use Smartsheet to manage their email campaigns? I'm trying to create a workflow to gather approvals, lists, etc. and to stay organized! Can anyone share examples (screenshots) of how you set up your sheet to stay organized with your email campaigns? Do you use forms and alerts/notifications? Thanks!
Outlook 2016 - Cannot authenticate smartsheet in outlook 2016
I have installed the smartsheet plugin for office 365. I can authenticate the plugin via the browser version and use the app, but am getting permanent hang when trying to authorise the desktop version. I get as far as the allow/deny screen, then I get stuck on: https://smartsheet-outlook.herokuapp.com/outlookapp/closeMe…