Our clinic managers perform a monthly Joint Commission readiness walk-through for each clinic (approx 125). I have built a form for them to document their results for each question - Compliant vs. Non…
I'm using this formula to return a student specific date from another sheet based on a student code =INDEX({Student Code from info sheet}, [Student Code]@row, {IEP date from info Sheet}) it says #INVA…
Hi, We used the Annual Calendar by Day Template and it works great for the current year. However, we want to continue using the sheet in 2019 below the current year. When I copy the rows to below the …
Hi all, Is it possible to remove/hide the "Unsubscribe" button from automation e-mails? We had a team member accidentally unsubscribe from alerts that were imperative for them to be getting and it ren…
I want to count "Enrolled" from "Case Status" AND "Medicaid" from "Insurance Type." I used the COUNTIF formula, but it seems like Smartsheet isn't counting the Medicaid cell if it's within a cell with…
Can anyone tell me what might be wrong with this formula? I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the …
I'm pretty new to Smartsheet and I have a pretty big set of data for each one of my 60-80 students I am trying to use it to track. I manage a therapy department at a special ed school. I have two shee…
RIGHT NOW: Implement a pop-up warning to alert someone and verify that they want to delete a row. You do it for unlocking rows, and that's nothing compared to deleting a row. SOON: Give us a new user …
I have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide …