-
Cross reference sheet formula with date limits
I'm trying to count the number of complaints for Family Medicine within the last 30 days on a metric sheet referencing the source sheet Complaint Tracker. Here is the formula I think should work: =COUNTIFS({PR - Complaint/Grievance Data Collection Range 2}, "Complaint", {PR - Complaint/Grievance Data Collection Range 1},…
-
Data reference from one sheet to another Formula not working
Hello community, I was trying to reference some data from one sheet to another via formula but it doesn't seem to work error in cell: " #unparseable" , here a breakdown of my goal and the formula I am trying to use: have 2 separate sheets, in the main one named request for information where people will submit their request…
-
Inventory and Barcodes
Hey there! I have a question regarding inventory management and barcode scanning. Currently I have a sheet called "inventory tracker". We have various different lab supplies that need are deployed depending on the need. Currently, we are manually counting how many supplies we take out and whatever is not used, we count and…
-
Monitoring Ongoing Duplicate Entries
Hi I need some advice in being able to track people who have registered for more than one program. We run multiple programs and need to track if a person registers for more than one for compliance reasons. We have a system where people register and then I use Data Shuttle to upload them into Smartsheet. Currently on the…
-
Using the Work Day Formula to Calculate Due Date
Hi All, I am trying to generate a formula that will calculate a due date (MM/DD/YYYY) based on working days of the month. My problem is that our team uses WD1, WD2, WD3, etc, to denote a due date, not dates in a date format. For example, WD1 in November would be 11/1/2024 and WD2 would be 11/4/2024. Does anyone have ideas…
-
Option to convert to column formula greyed out
Hello, I am new to Smartsheet and having some trouble applying a difference between dates formula to an entire column. The formula concerns 4 columns - Complaint Status (dropdown format column), Date Complaint Received (date format column), Date Complaint Closed (date format column) and Days Open (duration column). If…
-
Why is my percent complete not updating?
I have a project plan which pulls in data from a other referenced sheet. We track our development in a tracker, and have a dashboard and reports that help us understand where we are with progress for development. The percent complete pulls in automatically from a reference sheet into SubTasks in the project plan. However,…
-
How to quickly find a column by it's name in a sheet?
I have a very large sheet with many columns coming in from a form and many additional helper and result columns. I have created documentation of how it is working where I document the column named, its purpose and the formula used. (In addition to adding information to the column description). I am curious if there is a…
-
Pulling Value to Create Dynamic List
Hello All, I have a sheet created for time sheets for employees and I am looking to pull certain metrics from it on a separate sheet. What I am trying to create is a list based off of the the most hours worked at the job in the previous week. I am assuming that it is an index/collect/count function, but not being able to…
-
How to compare 2 dates automatically (no helper column)
Hi all, I need to compare 2 dates in 2 different columns. I would like to compare the "deliver by date" to the "appointment date"; when the appointment date is occurring after the deliver by date, I would like to highlight this in red. I don't want to add a helper column because that defeats the purpose of me setting this…
