-
index match quandary
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 #INVALID DATA TYPE I've used this INDEX MATCH and this type of formula before and I'm not sure why its not working
-
Annual Calendar by Day Template
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 current calendar, the formula is not easy to update. Row 373 holds the date the year is generated from and starting in the…
-
Removing Unsubscribe Option from Automation E-mails
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 rendered the automation workflow disabled. Thank you in advance!
-
What formulas should I use to count two criteria (including from a multiple dropdown option)?
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 multiple criterias selected. Screenshots below: You can see that even though 2 fit the criteria, the sheet summary only…
-
countif with dates
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 number of fields that have a date in 2018. Thanks =COUNTIF([Date Completed]1:[Date Completed]14, "=>1/1/18")
-
Whats the most reliable way to automate data collection by student/client name?
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 sheets one that gets raw data from a form filled out by multiple therapists for between 60-80 different students and another…
-
Deleted Rows
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 level with edit access but no ability to delete rows or make it impossible to delete a row if any cell in that row is locked…
-
Can I hide predecessor lines in a gantt chart?
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 or turn off not the predecessors, but the predecessor lines? Thanks!
-
% Variance between 2 numbers
I am trying to figure out the % variance between 2 numbers ($40,190,187 and $40,279,091) I just need the formula can anyone help?
-
Compile a list of unique values
I've been playing around with this all day. I'm trying to figure a way to compile a list all the unique values in a given column (in this case, business entities/customers). I'm matching that against an "Inactive" checkbox and trying to end with a list of all customers with currently active projects. Ideally in a report so…
