-
Getting Data From Another Sheet to Populate in Another Sheet when Conditions are Met
Hello, I currently have 2 sheets that I am working with: the first is the "Original" sheet and the other is a "Metrics" sheet, which pulls data from the original (being used for Dashboard charts). The "Original" sheet has an "ID" column, a "Status" column (either "OPEN" or "CLOSED"), and "# of Days" column. On the metrics…
-
Return "Yes" if a date range includes a certain month
I am trying to return either a "Yes" or "No" value in columns for the months of the year if a date range for a project or activity has dates in that month. For example, if a project starts on 2/15/2022 and ends 4/15/2022, I would want to have "Yes" in the February, March, and April columns and "No" in all other month…
-
Add data based on project owner?
Hello, Hoping for a simple add of data based on another columns drop down selection. Looking to add up my minutes based on when my name is selected Looking to do this from another sheet Please and thank you
-
Duplicate Values: =If(Countif doesn't work with concatenated formula.
I am trying to identify duplicate values in a column titled [Program ID]. [Program ID] is the result of a concatenate formula: =[Site Num]@row + "." + ProgNum@row The result of the above formula is a decimal number like 7.1, 8.4, 50.3, etc. I am using the following formula in a helper column to identify duplicates in the…
-
If formula with Date and Time
Hi. I created the formula below to close a dynamic view on Oct.30th. =IF(TODAY() <= DATE(2024, 10, 30), "Open View", "Lock View") How do I adjust that formula so that the view can be locked at 5pm on that day?
-
Hello, can someone please help with a formula?
I am trying to build a formula based on if the drop down of one column (Event Type = Pop Up) is completed based on another column (Completed = True). I have this formula to count the number of events that are Pop Ups, but I cannot figured out how to add up which of these is complete. I appreciate your help! =COUNTIF([Event…
-
Permissions for non-licensed users
Hi All - I have a Smartsheet license and built out a project plan in Smartsheet which I'll be sharing with my team members who are non-licensed users. They will have editor access either way. Does anyone know if they will be able to enter or change formulas in cells which I've created as the admin? Thanks for your help in…
-
Countifs Formula Including Keyword Search and Date Range
Hello, I am attempting to build a live chart that tracks the number of open items from a smartsheet and also organizes them into date ranges based on todays date. I am currently using the countif function to organize the data into 30+ days outstanding, 60+ days outstanding, etc. but I would like to exclude any items that…
-
Status column not updating correctly
I have a status column that needs to update based on the date in the [Date Revised] column with a date formula that uses helper columns [BLANK],[Due in a Week], [Due in a month], and [Due more Than Month]. The formula I have currently is not working when it hits the Due in a month and Current parts. Not sure where I went…
-
Help with formula
I am creating a Metric sheet to count if three column criteria are met on the source sheet. The sheet references I have made are all caps. I have tried variations of the below: =COUNTIFS({TYPE:TYPE}, "HM", {ROLE:ROLE}, "Physician",{REGION:REGION}, "South") Does anyone know how this formula should be written?
