-
Conditional Formatting
I have never had this issue but currently I have conditional formatting set to make a cell 'red' if the due date is in the past. The date is calculated based on a formula from other cells but this is a date column. The conditional formatting will not work. I have several dates in the past and none are following the…
-
Building an if statement off a specific ancestor
We use smartsheet to manage our content planning across several channels and teams using parent/child as an organizational method. I'm trying to build a filter out to show only projects and tasks that fall under a specific top-level (level 0) project. I'd like to build a formula (likely an if statement?) that returns the…
-
COUNTIFS With Multiple References
Hi all, I'm clearly not understanding the @cell and other references quite right. I'm working to create a summary sheet referencing the same data sheet, but using multiple columns to compare. Example here: Data sheet columns: Assignee [user name] Finish Date [date] Summary columns: Assignee [user name] Ticket Count Ticket…
-
Report Grouping Work Around
I have a list of SOPs and their supporting documents (Forms, Logs etc). As you can see in the Excel example, we have the SOPs in Green and the supported docs below. Some, like the SOP Training/Retraining Record, are used for multiple SOPs. I tried: Using Gantt functions, added a Predecessor Column but I couldn't run a…
-
Count Number of Cells within 2021 or specified Year
Hey Folks, This comes up alot and I tried my best. I am building a metrics sheet for a dashboard, and need to reference the ship date column on my other sheet. I need to count the number of ship dates in 2021 YTD (so Jan 1 - TODAY). So I can count total shipped YTD. Here is what I got, getting Unparseable. PM Backlog Range…
-
Formula returning 0
Hi Can anyone help me with this formula? Should be really simple, but i am having an off day it seems! The formula is looking for any elitebook g3 devices that are in northampton, but gives me the result of 0 instead of the correct number? Any ideas?
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
-
Event Request - block date(s) when event is full with a formula
Hello! I am creating a form for people to sign-up for an event. There are only so many spots available for these events, so I want to have a date option be greyed/struck-out when the event is at capacity. Is there a formula or conditional formatting that will do this once the event is full? Thinking to use Sheet Summary to…
-
COUNTIFS
Hi, Not sure of the best method or formula, but I am trying to sum up (in column61) the total number of days worked in the last 2 weeks for everyone when the data looks like this: I can do a countifs statement that returns the number of weekending dates that are within 2 weeks of the current rows weekending date, but not…
-
Formula for 2 columns - checkbox and a date range
Hi there - newbie here. Looking for help with a formula. I am trying to drive a metric which shows the percentage of activities on 'THD Brands' in the past week. The 'THD Brand' column is a checkbox, so essentially I need to count anything that is ticked in this column, and also the 'Last met?' column has a date within the…
