-
Index Function Help
I am trying to index data by date and have applied the formula to the column. The problem I am running into is the last data entry is repeating to the end of the dates I have listed for the year even though those dates have not occurred and are not even listed on the sheet I am looking to. =INDEX({Census}, MATCH(Date@row,…
-
Why would a formula work on one sheet but be #unparseable on another?
Hello All, I am trying to use a formula I use on one of my sheets to collect data. It works great, but I made a new sheet to capture the data as the other one is messy as I was still learning. My Formula works great on the original sheet, but when I use the same formula on my new sheet it comes back #unparseable. This is…
-
Flagging a Date and Time Overlap
Hello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as many as 6 to 8 classes in a day, but only have 4 conference lines. I'm trying to write…
-
Cells auto adjust based on forms submission
If a column has the wrap feature activated, it currently will not wrap if the data is submitted through a form. The only way around this is to refresh the Smartsheet. We currently use the form feature to have users submit information to our command center (control room) so we can see and address issues in real time. The…
-
Can I alter this formula to generate a date based off a deadline of the 4th Friday of every month?
As a form submits answers to my Smartsheet, the submission date is recorded under a column titled "Created." This information is submitted to a committee meeting on the 3rd Wednesday of every month, so I needed this formula to specify at which meeting date each response row will be considered. I found the formula below on…
-
Manuscript Tracker
Does anyone have a template for a manuscript tracker? Ideally I am hoping to build something that I can later publish for others to view and be able to search for themselves to see which publications they are either a byline author, group author, or in the acknowledgements.
-
Salesforce Connector Requirements
Does anyone know if there are version requirements for Salesforce to utilize the connector? My IT team is about to upgrade SFDC to Lightning and they want to know if the connector works / requires lightning.
-
How can I best organize lots of different 'tags' to sort through
I'm moving a sheet over from Google Sheets. Right now we have a column for 'Specialties' for different medical providers and it contains keywords we need to be able to search by. I need to be able to sort through this data quickly. I don't necessarily want it as a drop down because there are over 100 different…
-
Healthcare staffing templates?
Hello, I am very new to Smartsheets, and I would like to know if there are any healthcare templates that we can use for our agency. We track referrals from the sources. We monitor the status of the referral based on the clinician's acceptance to treat the patients. So we input a lot of data, which sometimes can be…
-
WEEKNUMBER and WEEKDAY
I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) to see who's "on duty" at that time. That contact's name is pulled into an "Assigned"…