-
Formula Expert Help Needed (Number of days for Oldest Ticket, Count all except blank & Closed status
Hi Smartsheet Formula experts! I spend a lot of time scrubbing the community board for formula help and thankfully I usually find my solution. (Thank you all!) However, I'm trying to build this sheet summary out and after about 2 + hours, I'm reaching out to the experts in the community. Screen shot of the metrics I amโฆ
-
How to count number of entries that fall between two dates
Hi! I have a sheet that has a date column to enter the initial date of contact. I want to count how many of those entries fall between 2 dates (by month) i.e. I want to know how many of the entries have a date between 1/1/22 and 1/31/22. This is my formula but it's not calculating correctly as I know I have 2 entries withโฆ
-
#INCORRECT ARGUMENT
Hello Community, Having a hard time trying to figure out why my formula broke. Initially, the "As Built Accepted?" column was a checkbox and the formula was working correctly: Column changed to date and the formula breaks. Changed the 1st condition to be a date, and added a couple of status additional to "Job Completed"โฆ
-
Need help with a formula to calculate accrued PTO based on # of pay periods
Hello, I am seeking help with a formula to calculate accrued PTO based on the # of pay periods per person each year and if they are full-time. Example 1: Nikki started on 7/1/22 and accrues 3.5 hours each pay period (twice a month) so I need a formula to let me know what she has accrued to date. Example 2: Laura started onโฆ
-
I am trying to add traffic lights to my Smartsheet but I cannot get the formula to parse
I am trying to add Green, Yellow, Red stop lights to my Smartsheet. I am trying to add the following formula and keep getting a parsing error: =IF([Intel Forecast Acceptance Date]17 < โ10/15/2022โ, โYellowโ, IF(AND([HPE Financial Qtr]17 = โQ3/2022โ,[Intel Forecast Acceptance Date]17 > โ07/31/22โ then "Red", Green"))) 17 isโฆ
-
NETWORKDAYS - glitch
Good afternoon, I'm confused about the NETWORKDAYS formula, as it's not working accurately or I'm using it wrong? I have coverage start date and end date , where I need to returns the number of working days (excluding the holidays) in the last column as shown below. =NETWORKDAYS([Coverage Start Date]@row, [Coverage Endโฆ
-
Not allow checkbox to be 'yes' if another cell is blank?
Hello - We have one process which allows people to assign themselves to requests. Can I stop users from clicking the Complete checkbox if they forgot or neglected to select an assignee on that request row? I have setup conditional formatting to highlight the occurrences, but can not figure out a formula or other workaroundโฆ
-
How can I count more than one status in a column
=COUNTIFs(([BTA Deployment Status]:[BTA Deployment Status], ="On Hold")([BTA Deployment Status]:[BTA Deployment Status], ="Credentials Needed")) Where there are more than one status... "On Hold", "Credentials Needed", and "Complete"... but I only want to count the ones that are not complete
-
How to get email notifications when am using card view and card is moving from one lane to another?
Hi, We are working in Kanban model using Card view and have different lanes like Dev, QA, UAT etc. I do get standard notifications when tagged in comments however when any card is moved from one lane to another (Dev to QA for example) how can I (or whoever is assigned as owner for card) get notification that it is moved soโฆ
-
Formula Syntax Help - Identifying suffix on number.
I have a sheet tracking orders. Each order has multiple order lines (each item on an order has a separate line with a decimal suffix). I would like to identify each primary order line (order line ending with ".0" but I'm struggling with the formula. I currently have this keyed as a formula =if(Orderโฆ