-
RYG balls automation
Hi, I went thru existing discussion but could not find my exact need. I would like to automate the RYG balls to change color based on two dates columns. For exemple if "date issued" is blank I need a yellow ball, if "date issued is not blank but "date released" is still empty then show a red ball and finally if both dateā¦
-
Background and Font Color Default
I would like the ability to set the default color for the background and font to colors that I use on a regular basis. I have already submitted this enhancement request to Smartsheet but I was wondering if anyone in the Community thinks this would be useful.
-
Live Data Connector
Just want to express my disappointment that the live data connector is only available for Business and Enterprise level accounts. There should be another option for purchase (or -- radical idea if you want to retain customers -- make it available for free) for users at other account levels. I guess I'll have to useā¦
-
Custom Jira fields not in Jira Connector
Hi - I have a new Jira custom field I want to pass over to the smart sheet, but when i come to configure the connector between jira and smartsheet, the field is not available. Other jira custom fields are. What could the issue be?
-
Webforms in Workspaces?
Is there any way to add a webform into a workspace? They seem to sit out separately on the mobile app, so you have to name them with the same name as the workspace for them to be useful.Ā
-
Webforms - Email advice
I like the fact that webforms can be set up with a notification to automatically send an email to a contact. When you complete the webform, it offers you the opportunity to have a copy sent to you. When the notification goes through to the contact (e.g. a manager), the format displayed in the email is a copy of that row ofā¦
-
Number Range Logic
I am trying to craft a formula that sources a numericalĀ value in a different column and, based on that value, prints a skill level. Here's the formula: =IF([Points]1 <99, IF([Points]1 <199, āApprenticeā, IF([Points]1 <499, āAmateurā, IF([Points]1 <999, āProā, IF([Points]1 <1999, āVeteranā, IF([Points]1 <= 3999, āExpertā,ā¦
-
customizing the email address for a request for approval
Has anyone played with the Request for Approval option? I'd like to be able to send this request to a client to approval work in progress. However, the email the client receives comes from "automation@smartsheet.com." I'd like to customize this so that it comes from me (like notifications do) so the client will recognizeā¦
-
Avg of Parent not matching up to Avg of Children
Hello, I'm trying to roll-up % effort at the project level based on % effort entries at the task level. I'm using the formula avg(children()) at the highest level to get the roll-up total. As a check, I'm calculating the avg % effort at the highest parent level throughout the plan. I'm running into a situation where myā¦
-
Integrate Shortlink generator with Smartsheet
Hi all, I use Smartsheet as a master content hub where content that needs to be promoted through social media channels are submitted by multiple usersĀ through the Smartsheet webform. After the submission, the content is compiled into the SmartsheetĀ where it is posted toĀ the proper social channelĀ by an admin. I was curiousā¦