-
Counting dates as entries
I am compiling a metrics page, and need to count a date field, teh automated "created" which stores date and time the row was created. I want to count a total of "01/XX/19", XX meaning i dont care about the days, i just want all of January 2019 entries. I am refrencing another sheet (hence the metric sheet), so i need toโฆ
-
Formula to auto populate a number based off cell input
I'm looking to see if there's a formula or other means to have Smartsheet auto populate a quote number and duplicate that number if the same name is added later on. I am working onย buildingย a quotes log where weย input a project nameย in Job Nameย which then auto fills toย the Job Name Master. Next to the Job Name Masterโฆ
-
Exclude summary row from count
Hello, How do I exclude the summary row in the following formula? =" Yellow: " + COUNTIF(Risk:Risk, "Yellow") + " Red: " + COUNTIF(Risk:Risk, "Red") Basically, the summary row RYGย ball risk indicator should NOT be included in the risk count of the child rows because it causes a count that is one higher than the actualโฆ
-
Joining the Results of Boxes Checked on a Form Entry (2 Solutions)
Edit: I had used numbers as my column names which in turn populated my first row. Another user made a good point that the number 1 in the first row will not actually duplicate my column name, but will read as "true" since it is a checkbox column. The column names and formulas have been updated to account for this. . Iโฆ
-
Formula RYG automation with using Complete% and rest of date by end date.
hi I'm trying to create Formula. It's almost completed. However, one last rule doesn't work. Can someone suggest to modify my formula? Currently the following conditions and formula is working fine. - If Complete% is 100% = Green - If Complete% is upper 60% = Green - if Complete% is under 60% and Today is less 5โฆ
-
Working Days Counter Based on State, Lock # when completed
I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and stillโฆ
-
IF THEN help
I'm trying to make this work but I keep getting errors. Help!I IF([Document Needed]1, =BO, THEN [Date Initiated]1+30), IF ([Document Needed]1,=LOC, THEN [Date Initiated]1+10) Thank you, Kelly
-
COUNTIF is double counting rows with multiple assigned contacts
Hello all, I am trying to count rows for one department. This department also has sub-departments. In some rows, it has multiple sub-departments assigned to it. This is my formula: =COUNTIFS({Requests Range 2 - Status}, Category2, {Requests Range 4 - Department}, (FIND("Merchandising", @cell) > 0)) For example, one row hasโฆ
-
IF THEN statement in a symbol column
Fairly new to smartsheet, so not sure if I'm doing something wrong. I have a priority column in my To Do sheet which is a symbol column (High, Medium, Low). I would like to create an IF statement that will automatically change the priority to "Low" once the task is completed (doing this for the purposes of a report I amโฆ
-
Needing Help with Multiple Logical Expressions Formula
I am working on a formula that will look at a few different cells and make a calculation. I need the formula to look at ETA to Ready = [terminal ETA] + [# of days] The [# of days] is determined by which [Terminal] So I need the formula to look at the value in the [Terminal] column, then add the associated [# of days] toโฆ