Conditional Formatting
Discussion List
-
Need help with seeing if a cell contains the quote symbol.In Formulas and FunctionsI want to locate " in a cell but Smartsheet wont allow me to run the following: =IF(CONTAINS(" " ",[Column]@row),1,0) Is there some sort of symbol that will allow me to reference this in the quotations of the formu…
-
how can i sync dates in a column with formula?In Formulas and FunctionsHello, below, I will explain to you the calculation of the termination notice period before the expiry of a contract and the sending of the reminder e-mail to the responsible person according to this notice period; 1- In the first step, I …
-
Column isn't an option to filter byIn Using Smartsheetfairly new to smartsheets, why aren't all columns available on the list when making a filter? I did not build this smartsheet but am the owner now so I am not sure if it's something on the backend I may not know yet. I need to create a fi…
-
Averaging a month and year of dataIn Formulas and FunctionsI want to average the month of April, 2022. I can't figure out the month, much less the year. I did look this up but I can't seem to get it to work. =AVG(COLLECT(Boiler Gas Usage}:{Boiler Gas Usage}, {Date}:{Date}, IFERROR(MONTH(@CELL)…
-
Crossing multiple data bases with a Partial Text/Number matchIn Formulas and FunctionsHello all! This is my first question. I am building a tracker called "My Project Tracker" that takes information from multiple "master sheets" built by different teams with different purposes. See screenshot for example…
-
Multiple IF / AND / OR Statements Help, Please.In Formulas and FunctionsThis is such a great community and a wealth of knowledge for a new Smartsheet user like me. I have done several formulas, but this one has me scratching my head. I have a [Target Date] column, [% Complete] column, and status column that …
-
% Allocation Formula for Assigned To columnIn Formulas and FunctionsHi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches greater than 100% allocation (from th…
-
Setting up a trigger comparing today's entry with the last entry.In Formulas and FunctionsOperators will enter Paint Code, Line Speed and the Date is created at the time of entry. There are MANY paint codes. How do I create a formula or workflow or BOTH to notify a manager WHEN the paint code has a lower line speed than the la…
-
Highlight a cell that has not been changed in X daysIn Using SmartsheetI want to highlight a cell named "this week's progress" if it has not been edited in the past 8 days so the viewing audience will know it has potentially "stale" information in it. Ideally the cell would tint yellow af…
-
CountIF for a multi-select drop-downIn Formulas and FunctionsHello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because i…