-
Date ranges and symbols
I am looking for a formula to automatically change a symbol colour based on contract expiry dates. Here is what I need each symbol to signify about the expiry date column - Green dot = If the contract expiry date is greater than 365 days from today Yellow dot = If the contract expiry date is less than 365 days away from…
-
Formulas and Calculations
Duh!! I figured it out. It was simple. Dennis
-
Hotkey - Ctrl "R"
Hello Smartsheets Community, I am aware the developers tried to mimic Excel's functionality as much as they were able to, but a fundamental hotkey I use in Excel is "Ctrl" + "R", which allows you to copy any cell to the right of the selected cells very quickly. When I attempt to do this in Smartsheets, my browser (Chrome)…
-
Help with #Invalid Data Type Error
I have a RYGB column (Color Status) that has a formula =IF(AND(Done@row = 1, [Parent Check]@row = 1), "Blue", IF(ISNUMBER([Days Open]@row), IF([Days Open]@row >= 240, "Red", IF(AND([Days Open]@row > 119, [Days Open]@row < 240), "Yellow", "Green")))) which is working to give me the red, yellow, green or blue ball. In…
-
Formulas and Calculations
O.K. I have now inserted my formula to calculate a number of miles driven for a given trip. But now I want to copy the formula to the entire column. Right now the formula is just in row 1 of my SS and I know that I can grab the corner of row 1 and drag it down to copy the formula into the other rows but it puts a zero in…
-
Formulas and Calculations
I know this is a simple formula in SS and Excel but I am having trouble writing it. In one of my SS's I want to Insert a "Beginning Miles" and then insert an "Ending Miles" column and then finally a "Total Miles Driven" column. To me that formula would need to calculated the sum of two entries and then yield a result of…
-
% Date calculation
Hello, I need to create a % calculation for the number of dates meeting a 'launch' date. What is the best formula to use for this? I will have a long list of dates and I need one column to calculate how many of them are equal to or less than a launch date (25/03/2021). Any guidance would be greatly appreciated. Thanks,…
-
Show date as day of the week
How can I use this forumla =TEXT(A3, "ddd") ?? This formula calculates the day of the week for the date and returns the abbreviated name of the day of the week (Thu). Every time I try to use this formula, it says "not recognized".
-
vlookup vs. Match (identifying new form submissions compared to a static list)
Scenario: * I have a list of 200 customers that need to be surveyed by our team. * Some customers will receive multiple surveys, as they are served by multiple team members (our plan is to compile & analyze the results). * Although to meet our goal, only 1 survey per customer is needed * We are using a Smartsheet form to…
-
IF Statement to return a Date value
I'd like to create an nested If Statement to return a date based on meeting a specific condition. I'd like to be able to "hardcode" the date in the IF statement. Here is a quick example =IF([Value]1 = "Option2", 4/23/2019, IF([Value]1 = "Option2", 4/24/2019, 4/25/2019)) . If the date is quote wrapped ed "4/24/2019" then it…