-
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],…
-
How to count the number of Flagged rows
Hi, I'm trying to count the number of rows on my sheet summary that are flagged on my sheet it seems my formula is not working it gives #INVALID DATA TYPE error Below is the formula : =COUNTIF(TBD:TBD, @cell) The name of the column is TBD as seen on the screenshot below :
-
How can I count a range of dates based of a condition?
I'm trying to keep a tally of how many cancelled dates per month for each state/country and I can't quite figure out the formula to make it work. Can someone please help me?
-
Seeking a formula that counts specific characters in a cell.
My project task sheet has parent rows for each department and child row for each project within the parent department. Each project row has a LEAD DEPT column with dropdown options that show the department acronym and business unit---DEPARTMENT (Unit). The LEAD DEPT options are; DCM (Marketing) DCM (Membership) DCM…
-
Weekly Comparison
Hello guys, I am trying to add a column that will provide me a %complete for previous week. I have this week's percentage and a PM is updating that weekly however I was wondering if there is a way to have another column that would be updated with previous week's percentage without the manual labor (think of 300+ rows). Is…