-
Need to set a date with formula whenever new task is entered
Hi. Among the other columns i have 2 columns named "Task Name" and "Start Date". What i would like to create now, is whenever new line is entered to "Task Name", the current date will appear automatically to "Start Date" row and date should remain as date when task was entered. I tried following: =IF([Task Name]5 > "0";…
-
Calculating complete dates with calendar days but....
I've brought this up before and at one point I thought that I found a great work-around. I would like to use calendar days in my date dalculations but, not have an end date land on a weekend. I created a complete column and with the use of a formula I tested the end date for a weekend and if it was a weekend I boosted it…
-
More functionality for for rules
The rules feature is nice but it is very limited and only allows to change things from different fonts, colors, strikeouts, etc. I would like a rule that allowed more detailed changes. For example, if column a says completed, changed column L to 100%. There are many different scenarios. We are unable to use the…
-
Spreadsheet Filters vs Report Filters
I have a text column that has formulas and conditional formatting already added to it preventing me from changing the column type to a dropdown list. It is spread across several years of spreadsheets making a larger conversion to a list time consuming. I have a request for Report Filters to have the drop down list similar…
-
Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
-
IF And
Good Day, I need so assistance, I am trying to do the following I want to change my Project stoplight Status Column (RYGB ball) to yellow if the following condition is met if my "# of Days" column is > 138 and my "% Complete" column is < 50% Here is my If condition - =IF(AND(([# of Days]2 > 138, ([% Complete]2 < 50)),…
-
Countif formula suddenly stopped working
Hello, I have a formula that has been working perfectly for the past 8 months. It's a very simple count if formula. Below is the formula that I copied directly from smartsheets. Anyone have an idea why this all of a sudden returned an "invalid opeartion" error when it has been working before? =COUNTIF(Status:Status, "Red")…
-
Formula help - if cell range contain any text, check the checkbox, otherwise uncheck
Hi All, I'm new to Smartsheet and was hoping someone might be able to help. I'm trying to build a formula where if a range of cells with that row contain any text, a checkbox is checked. But if anyone of the cells in that range has not been filled out, the box is not checked.
-
Common Picklist
Is there a way to define a picklist with values and then leverage that sinle picklist on more than one sheet?
-
date formula referencing specific date cell
Hi, I am working in a date column that has the Effective Date: 05/13/2019. I want the Project Kick-off Date to reference the Effective Date - What formula do I enter so that: (i) the Year is always the year listed in the effective date cell, (ii) month is always January, and (iii) Day is always 01? I have tried this…