-
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…
-
Workbook template set for new project
Hi there, My first post to this forum and somewhat new user to Smartsheet. Can anyone advise if below is possible and if yes, how to do this or point me to help on this topic. Thanks a million! *** I want to create a template set for a suite of document that I need to create for every project. What I do today is use an…
-
How do you make a Program roll-up
How do you make a roll-up of multiple indivdual projects. Wtihin each of the project dependencies is turned on.
-
Rookie Help with Due Date and Overdue
I have a start date column, due date column, completed date and would like to have overdue flag column. How to set formula that if due date passes, no completed date and have flag come up in overdue column?
-
Change Status Bubble Color Based on Percentage
Have tried using conditional formatting to achieve this with no luck. I have a column of % complete with percentages in increments of 5. I then have a seperate column of status that I am using a gray, red, yellow and green ball image. I'd like to for the color of the ball to change based on the percentage chosen (i.e. gray…
