-
Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
-
Conditional Formatting on Linked Sheet
Hi Guys I have a sheet that is a programme sheet which holds all the high level data of each project within the programme of work. I have a cell called budget variance which I want to be formatted as filled red, large bold text across the whole line. I want this to occur when the variance data is more than £9999. Currently…
-
Helpful Things I've Discovered About Smartsheet (Long)
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…
-
Background Colors for Attachments & Discussions
I recently submitted a Feature Request and am curious if anyone else would like it as well. Reason: I am trying to increase feature adoption among my peers. I believe this ability will increase the visibility and awareness of Attachments & Comments. Request: I would like the ability to change the background color of the…
-
Conditional Formatting: "Today is in-between Start Date and End Date"?
Hi all, I built a filter to show my tasks that are due today with a green highlight. However, it does not capture tasks that last across several days (see the different shades of green in the attached image - bright green is a "today" task, and the woodland green is default). How can I extend my conditional formatting to…
-
ENHANCEMENT REQUEST: FROM YOUR CUSTOMER BASE
Open Topics Pending Product Reply on: * Fix the link to sheet bug not showing as a URL/link * Unable to unlink, delete and retype in text to fix * Ability to chance the background color in a Sight other what white/grey - fix to allow users to select a color or image upload * Ability to make widgets transparent and just…
-
Formula vs Conditional Formatting
I was hoping conditional formatting could solve this but can we do IF/AND on conditional formatting? If not, what would the formula look like? If the End Date is in the Past AND % Complete is NOT 100% change End Date Font Red. Currently, I have a formula that will flag "At Risk" column if the date is in the past and %…
-
Date-based RYGB balls automation
Hi, For the past couple of days, I have been trying to automate my RYGB balls based on Target End Date and Actual End Date columns. I've been reading this article, but I cannot seem to get the formula right. These are the conditions I am trying to satisfy: * BLUE = if the Target End Date cell and Actual End Date cell are…
-
Copy Conditional Formatting...
Is it possible to copy the conditional formating from one row to another row? For example I have rules setup for column A. Column B contains the same data... can I copy the rules about column A to column B?
-
Populating text cells that show minimum value
I am in the process of creating a sheet to populate low bidders. I have two columns; vendors and total cost. I've included a cell formula in the total cost column to automatically populate the low bid value : =min(cell1, cell2, cell3, cell4, cell5). My question is, how can I create a cell in the 'vendors' column to…