Conditional Formatting
Discussion List
-
#UNPARSEABLE using COUNTIF for text objectsIn Formulas and FunctionsI have a Form which allows the recipient to answer a question via a drop down list: Example: Where would you like to go for vacation? List includes: U.S., Europe, Asia, Australia It's a pick many list so users can select any number of answ…
-
Converting a formula to a "column formula"In Formulas and FunctionsI am trying to convert this formula into a column formula. It takes selected cells from a row to populate the overall "Status" column. If tasks are "Not Started", the overall status will be "Not Started". The…
-
Filling Columns based on a Selection From DropdownIn Formulas and FunctionsI am working on a formula and cannot get it to return correctly, I need to be able to select one of two options in a dropdown. I was using a vlookup and kept getting the N/A for all of them even if the condition was met. I think I missed a…Answered - Pending Review 21 views 3 comments 0 points Most recent by Aimee Peyton-Greene Formulas and Functions
-
Formulas & Filter Assistance for a To Do ListIn Formulas and FunctionsHi, I have tried a few searches and haven't quite found what I need to perform the function within my smartsheet. Hoping some of the Formula wizards can help me out. I am using Smartsheet to manage my to do list. The filters are great bu…Answered - Pending Review 23 views 3 comments 0 points Most recent by Bassam Khalil Formulas and Functions
-
Flagging a Date and Time OverlapIn Formulas and FunctionsHello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as…
-
Countif todays date and by someoneIn Formulas and FunctionsI want to count how many times someone completes a form today I was able to count if yesterdays date with: =COUNTIFS({Store}, $Name6, {Created}, TODAY() - 1) but can't find a way to calculate todays entries
-
CheckBox FormulaIn Formulas and FunctionsGreetings! So, I have a "Done" column and a "Status" column. Status column values = Not Started , In Progress, Complete Done value = Checkbox The Goal: When I check the "Done", I would like to have the Stat…Answered - Pending Review 61 views 2 comments 0 points Most recent by Melita Clark Formulas and Functions
-
Is it possible to send specific columns of two spreadsheets to a third one?In Using SmartsheetHi everyone I have two spreadsheets and I want to take some columns of sheet 1 and others from sheet 2 and put them in a third one and that every time an update is made in sheet 1 or 2, it also apply on the third one. Including new rows, d…
-
SUM cells with formulas not workingIn Formulas and FunctionsHello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the sec…
-
Formula QuesitonIn Using SmartsheetI have 2 columns - one Engagement and one Desired Engagement - If the two columns are not equal, I want the cell color to be yellow as an indicator. If the two columns are equal then, do nothing. How can write that formula in smartsheets (…
