Formulas
Discussion List
- 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 fo…
- 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…
- 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 …
- 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 …
- 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 arr…
- 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 #Incorrec…
- 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…
- 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 i…
- 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 …
- 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…