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.
Discussion List
File links uploaded into Google form are garbled in Smartsheet
I have an existing Google form and one of the options is to attach files. When the form is submitted, the values I'm getting in Smartsheet are garbled, something like: "0B6fDccPdKcYeY0tlcjJnVTlMYWM,0B6fDccPdKcYeQi1Malg1YXVDMmM,0B6fDccPdKcYeZkIxVURBU3hjbWc" This column is supposed to be populated with Google Drive links.…
How to Trigger Formatting from Comparison / Nested IF?
Hello! I have project sheet, with dependencies enabled. This requires manually updating the % Complete value. I would like to add conditional formatting to remind myself to update the % Complete. IF [Completed]1 is not blank and IF [% Complete]1 does not equal 100% Then Format [% Complete]1 Cell Fill Yellow (screenshot…
Update Request that uses cell color
Good Morning, I am using Smartsheet to track students that are Below Grade Level, On Grade Level and Above Grade Level. The cell color for Below Grade Level is red, On grade level is light green and Above Grade level is dark green. When sending an update request for certain rows to one of my teachers, the colors in the…
Smartsheet Team Plan Offline and No Response from Support
Last week we cancelled a recurring PayPal payment approval on the PayPal site, so that we could register a different card as our preferred SmartSheet payment method for our annual plan. Although we didn't make any changes on the Smartsheet website itself, our Team Plan instantly disappeared and all Users were downgraded to…
Is there a formula for averaging the remaining?
Hello again! I have been trying to figure out a formula for averaging the remaining. This sheet has all business days through Dec 8 and a certain number of tasks to complete each day to be finished on time (Dec. 8). There are two columns. One has the number of tasks due to be completed each day (labeled Average) and the…
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.
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.…
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…
Emailing out of Smartsheet
How do I email to one or more email recipients out of SmartSheet attaching previous Attachments that I have made on various rows in SmartSheet?
Problem with date cell being blank
I am thinking this should be easy but can't seem to figure it out and would really appreciate some help. In working with our customers, we first create an estimate with the goal of turning it to a work order if the customer decides to make a purchase. I have a column entitled 'Estimate Creation Date', and I want to have my…
