-
Using formulas for Date validation within 7, 14 and 30 days
Hi, I am trying to use the following formula: =IF[Due Date] <=7, "Red", IF[Due Date] > 7 and <=14, "Yellow") IF [Due Date] > 14 and < 30, "Green") How do I do that, I tried to create a new column to show the colors, but I keep getting Invalid Operation. =IF(([Due Date]1) > 7, (AND([Due Date]1) < 14), "Red"), IF([Due…
-
Formula Question
I would like the column "Done" to be checked automatically if the % Complete is changed to 100%. I am using the formula below which is not working: =IF([% Complete]3 = "100%", 1) Any suggestions?
-
Linking Two Sheets to update dynamically When columns are added and removed.
I have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were to add in a row between two and three with a value of 2.5, I would like this to update on…
-
extracting the email adress of a contact
Hi, I'm not able to use the email adress of a contact in another cell. I need this for building a specific link in another cell. e.g. https://blabla.com/#browse/profile/john.doe@gmail.com ="https://blabla.com/#browse/profile/" + contact2 will not work :-(, it returns the name of the contact. Any idea how to get this…
-
Two new functions released (COUNTM & HAS)
Hi everyone, I noticed that two new functions has been released. COUNTM and HAS Here are the details. COUNTM Counts the number of elements in a multi-contact or multi-select dropdown column cell or cell range. Returns the total number of elements found. https://help.smartsheet.com/function/countm HAS Search for an exact…
-
#INVALID DATA TYPE with a VLOOKUP formula
I need to turn a column of dates into two additional columns, one with the month name and one with the year. The year was easy. But when using the MONTH formula, it returns the month as a number, 1-12. No big deal; as a workaround, I set up a "helper table" in another sheet with the numbers 1-12 and their corresponding…
-
Formula Help - Countif in Multi-select column
Hello - Two formula questions: 1. I am trying to input a countif formula into a Summary field that will count how many times the name of a specific team appears in a column that uses a multi-select dropdown. This column also has some fields that are blank. Below is what I have tried and am receiving an 'Unparseable' error.…
-
Formula HELP!
Hi! I am looking for a way to make my report of action items look better. I want to add a column that automatically can make my report look like the screenshot (attached). Does anyone know a formula that could help me? Thanks in advance!
-
If Cells not blank equal max date
I have a sheet with 7 columns that have dates (was checkboxes but could not get it to work) I want an 8th column to populate the max date from the 7 columns ONLY if all columns have a date entered. Basically I am tracking when people submit multiple documents, once all are submitted (i.e all dates entered) I issue them a…
-
Auto Populate
Hello all! I am trying to have a cell auto populate information based upon values in another sheet. For example, in Sheet 1, I have the columns "Customer" and "Notes". In Sheet 2, I have the same columns. I would like to enter a formula in Sheet 1 in the Notes column which would auto populate the notes from Sheet 2 when…