-
Formula to return results based on workweek not calendar week
I have this formula =COUNTIFS([EOD received]:[EOD received], "no", [Attendance for]:[Attendance for], (TODAY(-1))) It tells me how many end of day (EOD) emails have not been received by an employee for the previous day. So on Monday I check the attendance for the previous Friday, on Tuesday I check the attendance for…
-
Formula to indicate the duplicate dates
Hi, We had dates for contracts captured in 2 different systems and I want to do a compare of which contracts have conflicting information. My worksheet has the contract number, the "Expiration Date in LR" and "Expiry Date AER", and I just want to compare where the 2 dates are duplicates, to work through the remainder. I'm…
-
How to generate an ID number, incrementing by 1 the last ID number created in previous row?
I have a sheet with already multiple rows created. I have a column with ID numbers for each row. I want to set up an automatic way to generate an ID number for all future rows added. For exemple, the last row created has an ID number of 2300. How to automatically generate an ID number of 2301 for a new row added?
-
Greetings from New Jersey!
Hi Smartsheeters, I am fairly new to Smartsheet. I've been using it since November 2023. Just earned my Core App certification. I'm hoping to increase use of Smartsheet at my company and find ways to automate processes and integrate data from other systems. On the weekends I'm busy doing pottery and riding my ebike.
-
Trying to find values within a dropdown list on another sheet
So I'm trying to to "find" if a value has been submitted in a form where (for ease of form submission) submitters can submit the form for multiple properties. I'm not sure if it's possible without arrays, but seeing if anyone could crack this for me… My formula on the target sheet is this: It's trying to find a hotel code…
-
Formula Issue
So this Formula works =COUNTIF({Skills}, [Primary Column]@row) and this works as well =COUNTIF({Month}, 5) but when i combine them =COUNTIFS({Skills}, [Primary Column]@row, {Month}, 5) I get #IncorrectArgument Set. Why is this?
-
Nested Formula based off dates
Hi, I am trying to make my sheet highlight rows using the Yes, Hold, NO RAG symbols when dates in specific columns are in the past or the row has not been approved. So far I have the below formula but its coming up as unparseable. Can anyone help? I cant see where I'm going wrong. If all dates are in the future it can be…
-
Count formula help
I need to count number of tickets in a few columns, independently, and present the calculations in a metrics sheet to be used later. I need to calculate weekly and monthly numbers. I have tried many iterations of formulas and continue to get errors. Would love your thoughts. =COUNTIF({Week #}:[Week #], ${Week #}:$[Week…
-
"Number of Days Without Incident" Formula
So I need to create a formula that is essentially an automated version of those signs in factories and warehouses that say Number of Days Without Incident: ##. See attached screenshot. I want to know when a team has hit 30 days without an incident. But I want the number to reset if an incident happens. See attached…
-
COUNTIF not working when trying to count with a % in the dropdown options.
I ran into an issue where I am looking for a work around to make the system count a column that has % options in the drop down. So it is a column with these as drop down options. 0%, 3%, 4%, 5%, and 7%. I have tried the normal =COUNTIF(Percentage:Percentage, ="0%") making one for each option, but it always returns as 0. I…
