-
Finding Average of Cells in Another Sheet
Hello, I am trying to find the average of "% completes" percentages from one sheet to another that meet a certain criteria. Here is the formula I have attempted however, I am receiving an "Invalid Operation". Is there a way to accomplish this without selecting each cell individually? =IF({Team} = "Marketing", AVG({%…
-
IF Formula - 2 Conditions and 1 Flag
I have a column that houses a flag to notify if the billed hours breach the budget. But I am trying to use two conditions where it doesn't run if Contract Type contains T&M. My first attempt right now: =IF([Billable Consultant/Developer Hours]@row > [Consultant/Developer SOW Hours]@row, (IF([Contract Type]@row,…
-
workflow to be triggered when cell is changed to specific value
Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
-
Count previous month items
Hi i am creating a metrics for a Dashboard and i just need a count of new items that were created in the previous month. I am using as base the "created date" column. For your reference i already have one that is counting the items created during the current month and it is working. What i don't know if where to include an…
-
How to count number of tasks and due dates of another sheet
Hi, I'm trying to make Metrics sheet which I would like to calculate the number of tasks of each person by name and also their past due tasks I did some formulas but they seem to be #INVALID Below are the formulas I did for tasks : =COUNTIFS({Name of other sheet Range 1}, FIND("Name", @cell) > 0) Formula I did for past due…
-
*urgent request* - Days until Formula
Hello SmartSheet World, I am wondering if there is a good formula that can provide me the number of days until a date is reached? In the snip below, there will be a date added to the "CO Date ..." column and next to that column I want to create a formula that tells me how many days there are until that date arrives. Is…
-
Networkdays and If formula help
Hello! I could really use some help. I've reviewed previous Q&As and can't get my formula to work. I want to calculate net workdays based on a specific status selection and have it stop counting days once the status has changed. Status is in dropdown selection box. I've automated the start date to populate when the…
-
IF function in column formula not working
Hi Community, I have an IF function that I have working on a row but if it try and copy the formula into row below or convert to a column formula it does not work and gives #unparable. Formula is below. Am I missing something obvious? =((IF([FAS Time]@row > 0, "FAS, ")) + (IF([FSE Time]@row > 0, "FSE, ")) + (IF([Cust Care…
-
How to count number of Past Due Tasks
I use the formula below to track my past due tasks : but it is not giving me the correct number currently my sheet does not have any late task according to my filter below : Which formula should I use to make it possible ?
-
How to Track Someone's Past due Task
Hi, I have tried to write down a formula at the sheet summary that tracks the number of past due tasks assigned to a specific person on my sheet but it is giving a #UNPARSEABLE error below is how I have done it : =COUNTIFS([Is Past Due?]:[Is Past Due?], "Yes", Status:Status, "In Progress", [Assigned To]:[Assigned To],…