Conditional Formatting
Discussion List
-
Completed Tasks removed from calendarIn Using SmartsheetIs there a way to remove completed tasks from the calendar without removing them from the sheet? I have a done column that checks off and greys out the row but the information still shows up on the calendar is there a way for it not to sho…
-
How to calculate elapsed time between status changes ?In Formulas and FunctionsHello, Is there a way to calculate the elapsed time between two status changes ? I would need to know how much time it took for the status to change from yellow or red to green. Ideally, I would like to be able to calculate a mean per terr…Answered - Pending Review 74 views 2 comments 0 points Most recent by Nicolas Houle Formulas and Functions
-
Flag or Conditional Formatting?In Formulas and FunctionsI want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column&…
-
Creating a Formula for Dates and Traffic LightsIn Formulas and FunctionsHi, all! Our office is new to the SmartSheet community. I am having some trouble creating a formula for a sheet. I have the following columns: * "Initial Contact" - formatted as a date * "30 Days Since Contact" - fo…
-
Averaging RGB ballsIn Formulas and FunctionsI'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue …
-
Unable to Edit 1 Column on a SpreadsheetIn Using SmartsheetHello all, I am working on a collaborative spreadsheet on which I am an administrator. All I am trying to do update a vlookup function for one column, which references a different spreadsheet, on which I am also an administrator. The spre…
-
if formula helpIn Formulas and FunctionsI am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul NewcomeAnswered - Pending Review 22 views 4 comments 0 points Most recent by Mike Wilday Formulas and Functions
-
Copy , move or share selected cells / information with othersIn Using SmartsheetHi All How to copy/move or to share rows to another sheet with column of my choice . or to share some cells / columns of my choices with others but not all row information The reason is i donot want to share some information with others…Answered - Pending Review 31 views 4 comments 0 points Most recent by Leibel Shuchat Using Smartsheet
-
Create Summary SheetIn Using SmartsheetHi, I have been unable to create a summary sheet which I think will work better with charts on the dashboard. I created this report but want to do the same thing in a metric sheet. I am lost as to how to accomplish this. Any advice?
-
Add date to formulaIn Formulas and FunctionsHi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date&quo…
