-
How can I count the number of incoming calls per month using the "=countif" formula
I've had a chance to look around and found some information on being able to count the number of calls for a given month. However I'm stuck as the formula I'm entering is not working, stating it's an incorrect argument. Here is the formula. =COUNTIF({Call Flow Tracking Range 1}, >=DATE(2021, 8, 1), {Call Flow Tracking…
-
IF AND OR Formula
Hi, I need a formula that will default to a specific value if two criteria are met. If "Approved" and "Not Started" Or "Draft" Change the final status to "Excluded" else use what is in the other status from Service Now. =IF(AND([Exclusion Status]@row = "Approved", [Service Now Addenda Status]@row = "Not Started"),…
-
How to create Harvey balls to show progress of work
Hello, Please I need help creating Harvey balls that will show “Green” when work progress is FULL show “Red” when work progress is NOT FULL and End Date is less than TODAY show “Yellow” when work progress is less than FULL and NOT EMPTY show “Gray” when work progress is EMPTY and End Date is BLANK Would also like the…
-
Formula Question
Hello: Below is a formula that was written to change the verbage in the "Status" column based on the % Complete Column. The original formula was =IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", IF([% Complete]@row < 1, "In Progress"))) and it worked just…
-
Check for duplicates and exclude blank cells
Hi. I am trying to write a formula that will check for duplicates in a column but skip the blanks. The normal formula I use is Countif([Column Name]:[Column Name], [Column Name]@row) this counts blanks. I have tried =IF(ISBLANK([Column Name]@row), 0, IF(COUNTIF([Column Name]:[Column Name], [AColumn Name]@row) > 1, 1)) I…
-
I'm trying to find the number of cells that meet a criterion within a specific date window.
=COUNTIFS({Access Request Range 5},>=(2021, 7,1),{Access Request Range 5}, <=(2021,9,30), {Access Request Range 2},"Approved")
-
Notification - Alert the person in the cell
Hi Team, can you help me finding the correct automation setting to alert (only) the person in the cell. I can choose specific person but not related to the a cell. Can I do this? Below a screen of what I mean. If the box is ticked - the line manager who is in that cell should get a notification. Thanks for you help :)
-
Set checkboxes for all children - multi parent heirarchy
I want to set a checkbox for all the children through multiple heirarchy based on the value in another column. If you look at the attached examples, if the parent value for active is N/A then that row and all it's children should be checked, including any parents with children within that heirarchy. I have three additional…
-
I am needing a sub for A "SUMPRODUCT" formula I use in Excel.
I have costs and associated QTY's hosted in a separate sheet. The "A*B=Total" column I just added here to help explain what the "=SUMPRODUCT(A4:A10,B4:B10)" formula nested in E3 is performing. I could easily add additional columns in my smartsheet and then just run a formula to total the columns but I was trying to keep…
-
Date format on charts
Hi there, I want to track the amount of tasks / date. When I convert my report summary into a chart I think the dates are reformated into numbers. My data set looks like this: And my Chart looks like this: As you can see there is an issue with the date format... I've tried everything but couldn't find a solution. Thanks…
