Formulas
Discussion List
- I know I can view who marked a check box through view cell history but I'm looking for a way to display the person who marked an "approved" or "Done" check box without all the extra clicks; I need a v…
- I get a "#INVALID COLUMN VALUE" error from this formula.
- I need to schedule work on a particular route. Within my records I have a column named "Route" that shows the route number. EX: 10402. I have a DATE column called "Target". I want to add a column call…
- What function can pull this math but only for cells which have the date in it? I'm just trying not to see an invalid alert on everything - only some projects will have data in the cell referenced for …
- Hi, here's the situation. Sheet A is a master list of employees with their title, supervisor etc. Sheet B has a column that is set up as a dropdown list of names of said employees. When I choose an em…
- I have a drop down column that captures the study status and I have another column that is a check box indicating the information has been reviewed. Is there anyway to have the option to select the "i…
- 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 …
