-
#circular reference
Hi everyone, I am still learning the way of smartsheet but I do feel that I have a good general understanding of how it works. I am currently struggling with a circular reference that just wont go away. Well sometimes it does. Here is what happens: I have 2 sheets one sheet is called controls and the other sheet is a…
-
How to add multiple IF statements to WORKDAY function?
Hello trying to add multiple cities to a workday function. This is to subtract our ship day from the expected arrive by date. Currently, this is what I have =WORKDAY(F3,IF(OR(K3="CITY1",K3="CITY2),"-2","-10"),Sheet1!B$2:B$49) I want to add 2 more cities. The function can either be from another column/sheet that has the…
-
Average Collect Unique Formula
Hi, I am looking to pre set a data frame for Tableau Dashboards after form submissions and I need to do an average by a unique Risk Area. First a calculated the average Business Unit score for each Risk Area and now I want to take those average scores for each Business Unit in a Risk Area without duplicated values. How can…
-
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 :)