-
If Cell is not blank, equal date from different cell
I need the minds of the collective community! I am trying to create a formula that states: If "BCR Initial Approved Date" is not blank, then use date from "Estimated SFS date" or If "BCR Initial Approved Date" is Blank, leave blank. Attached is my attempt at creating the formula but it give me an Incorrect Argument set.…
-
Nested If Formula
Could someone please help me with this IF formula? Much appreciated! =IF([Total Individual Miles]1>350, "Five", IF(Total Individual Miles]1 <= 50, "One", IF(AND([Total Individual Miles]1 >50, [Total Individual Miles]1 <=150), "Two", IF(And([Total Individual Miles]1 >150, [Total Individual Miles]1 <=250, "Three",…
-
Using a hyperlink with a comma in?
Hi, I'm trying to use a Vlookup to bring up a link to file when a part no is entered. Unfortunately Vlookup won't bring a hyperlink through when it matches a cell, just the cell contents. So I've created a second cell with the raw hyperlink. However I've run into an second issue where Smartsheet won't recognise a link past…
-
Formula to Show Data from Child Row on Parent Row
Greetings - I am looking for a way to show the data from the first child row onto the parent row. Example: Parent Row = blank Child row 1 = blank Child row 2 = TEXT Child row 3 = TEXT The formula on the parent row would yield the text from child row 2
-
How to get Smartsheet to show the last 7 days of data without manually updating graph everyday?
Is there a way to get a smartsheet dashboard to show the last 7 days of data on a graph? I am trying to show percentage trends over the last week.
-
Sum based on the status of a check box
Hello! I have found another discussion on this topic, but it didn't quite get me where I needed. For the Sheet Summary data, we are looking to see the total of all of the kits needed and to have this number continue to reflect the "current" need as lines get marked complete ... so we only want it to count lines that are…
-
COUNTIF FUNCTIONS
I am sure this question has been answered but I have looked at so many variations that I think I am starting to confuse myself. I am trying to make a count IF one column shows one thing but then then another column has the word HOLD in it. So for example, I want to count the lines if Job Type says Burg and then Job Status…
-
Limit in Count Distinct Formula
I had this unpleasent experience using the following formula =COUNT(DISTINCT(data1:data1000)) It happens that the formula works only for the first 400 lines =COUNT(DISTINCT(data1:data400)) then the result will always be 1. Is it a bug or am I doing something wrong?
-
Display Year in a 10-Year Cycle
I have a sheet that is used to track where a store is at in a remodel cycle. Currently, I just have a column that takes the later date of two date columns, and adds ten years for an estimated remodel date. I'd like to add another column that displays the year in that 10-year cycle. In this sheet the Future AF column takes…
-
Conditional Formatting: Comparing one Date column to Another
I am trying to setup a rule to format a date Red if it is different from another column. For Example, I have two end date columns, the New finish date is the active date but I want to see where this is different from the Old Finish date we had previously agreed upon. Old Finish Date New Finish Date I want new finish date…