-
Count if Not Formula
I am capturing data from a form that collects data around car seat distribution and what county we distribute to. I want to capture when there is a date range for the date of distribution and the submitter is not from the following 5 counties: Haywood, Buncombe, Madison, Henderson and McDowell. I keep getting an…
-
Date calculation formulas are not working properly.
Hi, community. I have a weird problem with my metrics sheet and the dashboard linked to it since it is displaying fault information with a specific formula. I have tried a lot of workarounds, including the update of both source and metrics sheet and a lot of different formulas but I can't still fix it. Formula is as simple…
-
Counting specific values in multi select cells
Hello! I've read through several different posts about which formula to use to count specific text values in a multi-select cell however, I'm still getting errors on my end. I'm trying to get a count for each virtual event my team has selected. The formulas I have tried are: =COUNTIF([Virtual Event]:[Virtual Event],…
-
How do you get your source sheet to automatically send attachments to your target sheet
I am currently working on a project in which I would like to get my attachments on my source sheet to send to my target sheet once I click a checked box. I tried using Data Mesh and that worked for how I wanted my information transported over to the new sheet, but the documents did not copy over with it. Is this something…
-
Count number of each day of the week occur in a certain month
I want to type the month/year in a cell and have formulas to tell me how many Sundays, Mondays, Tuesdays etc are in that month. I'm currently entering that manually. Is there a way?
-
Advanced Vlookup
Hi Guys, I am looking for the formula to return value for a cell which is in the range. I have one smartsheet like above in the second smartsheet I have cell with date and for example if I have there 08/02/24 I want formula to give back Q3 FY25. Any ideas how can achieve this?
-
Updating dropdown list across various sheets
Hi all, I have a same column across different sheets, and the column dropdown needs to be updated frequently, which I am manually updating right now. However, I do have Data Shuttle feature that I can use to update the dropdown lists. To test this feature, I have created a source and destination sheets, and after creating…
-
Pull the Most Recent Submission
Hello! I have not written formulas in quite some time, and need some help. I want to check the "Most Recent" box, if it is the most recent submission for that workstream.
-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…
-
A way to Formulate status of parent row
Hello people, I´ve been wondering if it is possible or there´s a way around it to formulate a cell of a parnet row depending on the children? For example: Go to Class In progress get in the car Done Drive to school In Progress Park and go to class Pending so the thing is, can i formulate the Go to Class status? for example…