-
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…
-
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…
-
IF statement with flag symbol
Per the attached screen shot. How would the formula be written so that the row2 flag turns red IF any of the flags(row3-row11) are toggled to red? Thanks
-
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…
-
Automating RYG balls based on several columns
I am trying to automate the RYG ball status column, based on several factors. Red - if not marked 100% complete in the [% Complete] column after the [End Date] or; - if less than 7 days before [Start Date] and [RS] and [WOA] are not both =1 Yellow - If greater than 7 days before [Start Date], [RS] and [WOA] are not both =1…
-
SUMIF Contact? Help please!
I'm trying to get the total of a column where the row contains a specific sales person. Can someone help me out? Here is what I tried: =SUMIF([Sales Person]:[Sales Person], "Kevin", [Appx. Value]:Appx. Value]) Screenshot attached...thanks in advance!
-
Calculating Number of Items in a Month based on System Generated date field
Hello all - Needing help with a formula to calculate how many requests are submitted via a webform for each month. 2 questions related to this: 1. Can a formula pull just the month from a System Generated cell: Created by (Date)? 2. Where are errors in this formula: =COUNTIF({Date Submitted}, MONTH(@cell) = 1) 'Date…
-
To stop the Counting Counter after One Column Value is changed.
I Have a project in which i have to Calculate the days. From the date form is submitted to the time it is approved by the internal team. I want to stop the calculating counter after the Status of the internal approval is changing. The Approved Column has different drop down list which changes and and thus the count has to…
-
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…
-
CountIFs EOM Formula
Is there and EOM formula that will use the Month Column instead of manually using the DATE (2019,1,31) format? Excel example: =COUNTIFS(Type of Lead,"Servicing",Date Received,">="&B5,Date Received,"<="&EOMONTH(B5,0)) Smartsheet: =COUNTIFS({Type of Lead},"Servicing", {Date},>=DATE(Month1),{Date},<=EOM(Month1)) Any help…