-
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…
-
Conditional Formatting on Web Forms
Does anyone know if there is a way to implement conditional formatting on web forms? For example, if I have a web form to populate a sheet, I want to be able to implement rules to email certain people based on a specific value selected in a drop down on the web form. I did try to figure this out using Zapier, but couldn't…
-
Formula to change date based on adjacent drop down menu
I'm trying to set up a tool inventory, to help keep track of the location of all our big ticket items. I've created a row for each tool. Asides from various descriptive colums, I have one column set as a drop down list (listing the numerous job sites the tool might be pulled to). I also have a Date Pulled column, to show…