-
Merged: formula in a report view
This discussion has been merged.
-
COUNTIF using OR
Hi, I'm trying to count how many check boxes (out of a possible 4) are checked on a row (basically, countif w OR x OR y OR z is checked). I've tried many variations of the following formula: =COUNTIFS(OR[PNS]@row = "1", [EIP]@row = "1")) Thank you!
-
Calculate number of days and years from start date
I need to see how long staff have been with us, their tenure. I need this for any given dates, meaning "today". I have the start date, how do I get the days from that in years and days? Example: Start date is 06/01/2020, today is 08/23/2023 so the Tenure should be 3 years, 2 months, 22 days. I would take 3.2
-
I need help creating nested formulas to pull data from multiple sheets.
Hi Smartsheet Community, I am working on creating a training matrix based our training documentation. Here is the set up of the training matrix: peoples names as columns and the trainable documents in the rows. I added the helper row because I couldn't figure out how to use the columns in a formula. This is the separate…
-
Assist with Date Helper Column Formula
Hi, I have a sheet with a Date helper column that is being generated from a Primary column with a MM/DD/YYYY text format. I can get the helper column (set as a date type) to show up as MM/DD/YY without issue using this column formula: =DATE(VALUE(20 + RIGHT(Primary@row, 2)), VALUE(LEFT(Primary@row, 2)),…
-
Date and Product formulas
I'm referencing a sheet and I need to see how many product a have an end date between 30 - 60 days. Thank you!
-
The $ Formula
A consultant I worked with was tasked with building a graph showing our portfolio growth over time. The graph needed to be a 12-month trailing horizontal axis which uses the (already recorded) dates for when any new project is triggered for provisioning. On the vertical axis, we wanted to track the sum of the project sizes…
-
Number of weeks countdown from today to start date
Hi! I've searched other threads and haven't found a formula that works for me. I'm trying to create a countdown in weeks for events on a sheet to pull into a dashboard. I want to display the number of weeks from today's date to the event start date. I tried this formula: =WEEKNUMBER(TODAY()) - WEEKNUMBER([Start Date]12)…
-
Help for Status Change and Tracking
I am trying to create dashboard widgets from data that I am tracking. For this widget I am wanting to have a graph show the number of people in each status section I have listed: "Not Started", "In Progress" and "Completed". Each employee has an individual sheet with tasks listed along with corresponding start/end dates,…
-
Countifs statements for date fields that are in the past
Hi there, I am looking to summarize data from a master sheet for inclusion into a dashboard via a project metrics sheet. Within the master sheet I have an “Opening Date” that is populated when the opening date is decided. I want to populate the Dashboard with the number of sites that HAVE opened each month (past tense).…
