- 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
- Invalid Value Error in some rows of a Formula Column
I have an inventory transaction sheet that I have been working on for a little bit now. Looking at my Stock Alerts column again, it looks like there is an issue. The purpose of this column is to alert if the quantity requested is greater than or equal to the current quantity. If there is an error, then flag that the item…
- 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
你好,我有一张日期辅助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)),…
- A way to place the Row ID (for APIs) into a cell value with formula?
For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would…
- 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,…
