-
I am trying to return a value based on a couple of criteria. I'm using the index/collect method.
I have 2 sheets. Sheet 1 has a list of names. Sheet 2 has a list of locations, dates, and who is there across 6 columns. My goal is to have sheet 1 list where these people are currently located. Sheet 1: Sheet 2: Formula for "Current Site" field on Sheet 1: =index(collect({Sheet 2-Column1},{Sheet 2-Column30},"Yes",{Sheet…
-
Weekday Function that displays last 7 days
Hello, I currently have a date column with =Today() that tracks the current last 7 days plus the current day, this is paired to data that occurred on the corresponding day in order to display metrics on a dashboard. As you can see there are zeros on the 25th and 26th as it was a weekend. I am trying to utilize the =Weekday…
-
Filter and Count Formula
Hi! I am having a little trouble with a data field I am trying to create. (See below) I have figured out the formulas to calculate the first line (Master) What I need help with is a CountIFS formula for the others. These are on a master sheet and there is a column for workstream. I need to pull out only those Workstreams…
-
Create alerts various dates
Hi all, I am new here and this is probably such a simple query. I have looked at some of the previous discussions and still cannot get my head around what I need to do. I have created a basic marketing CRM. I want to create an alert for myself to remind me to call 7 days after an initial contact has been made for potential…
-
COUNTIFS
Can anyone help me figure this out. I'm trying to add a COUNTIFS to my sheet and I'm getting an Unparseable error. =COUNTIFS({Sales Ops Support Ticket Tracking with Form}, [Group Name/Portfolio]:[Group Name/Portfolio], "Gift & Home", [Salesforce Item]:[Salesforce Item], Account Owner Mass Update)
-
Nested IF Formula
Hi All, I'm trying to create a shift overview for an upcoming project, and would like to be able to enter a Start Time and End Time into 2x cells, and for the formula to fill in "1" into the corresponding cells to create a calendar view. Example below (just 1s filled in until I know what the formula is!!). I've tried…
-
Count: status is one of multiple criteria and due date is past
This discussion was created from comments split from: COUNTIFS function with multiple criteria.
-
How do I make a column formula that automatically checks the box if another column contains 1.
I am trying to make a checkbox column automatically check its box if the column1 contains 1. It may be equal to one but in some cases, it could be 1 high or 1 low. How can I check to see if the cell in column 1 of the same row contains 1. I have tried =CONTAINS(1, column1@row), but the boxes aren't checking.
-
How do I set up my sheet to reflect changes made in another sheet?
Hello! I am new to Smartsheet and trying to figure out how (and if it's possible) to set up a workflow or formula to reflect changes made in another sheet. Currently, I have one sheet set up that's linked to an intake form. I am using this sheet as a "master sheet" to track all submissions. Additionally, within this master…
-
Checking a box using an IF/OR statement
Hi, I am trying to check a box if either of these statements are true, but I'm getting an Invalid Data Type error. The "Operational" statuses are from a drop down. Data Upload is "Operational" OR Retail Survey is "Operational" This is what I have: =IF(OR([Data Upload Status]:[Data Upload Status], ="Operational", [Retail…