-
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…
-
Preventing Modified by and Modified when rows have formulas
Hello! All my sheets have automation (formulas). I am having difficulties keeping track of who has modified records. We do not have access to sheet history because we are on the Team Plan only. This is a huge problem because we have issues with managers not updating project status on a timely basis. I have no recourse.…