-
COUNTIFS CONTAINS problems
Hello, I am trying to create a formula that will count the cells across spreadsheets using COUNTIFS and CONTAINS. My formula works, however I don't believe it is accurate since I am getting a count of 0 for every scenario I try and apply. I would like to count the "Requested Delivery Quarter", shown in screenshot two. By…
-
Multiple criteria
Hi community! i need your help, I need to get a number based if the formula find match with multiple criteria in different rows. How can I get the result in the left side (yellow field) from the information on the right hand??? Thanks in advance!!!
-
Formula to auto-transfer data into another sheet
The company I work for uses Smartsheets to build schedules. We have both weekly and daily schedules. However, I've noticed a lot of our time is spent daily going through and transferring information from the weekly to the daily grids. I didn't know if there was a way for me to auto-link certain grids to a grid on another…
-
Reports - How do I create a report to give me the flag column?
I created a sheet that has a Flag column. I built a formula in the flag column to indicate when a number is within a range. =IF([Total of Buckets Weighed]@row < 25, 1, IF([Total of Buckets Weighed]@row > 35, 1, 0)) - This formula works fine. The problem is when I am creating a report and the flag column doesn't appear with…
-
Is there a way to pre-populate past survey responses by user?
I have a feedback survey(form) that users fill out a few times a week and I was wondering if there is a way to have their responses pre-load from the last time they answered. For example, say they fill out the survey three times a week and nothing has changed over the course of the week and they want to submit the same…
-
Add point values and weights to answers
I have a Smartsheet form that is populating answers from the individuals who fill out the form. I'd like to do the following three things with the various answers: add point values to answer choices add “weights” to different questions run calculations on a series of questions. For example, if the person put an answer that…
-
Join collect with other sheet
I'm trying to use the best formula that will basically say.. If Distributor Name (sheet one) = Distributor Name (sheet 2), then input contacts (sheet 2) into contacts (sheet 1). There are multiple contacts on separate rows for each distributor on sheet 2 that I want to combine in a single cell for each distributor on…
-
INDEX/COLLECT Formula for gathering list of data
Hi, I am not sure if INDEX, MATCH or COLLECT will be the right things to use in this formula but I'm very much a beginner in using those functions. On Sheet 1 I have a massive list of Restaurants (Column 1: Restaurant Name). Also on that sheet is Column 2: Division (For example Tampa Bay Restaurant is in the Southern…
-
New to Smartsheet - Setting alerts once status has changed
Hi all, I hope you are all doing well. I have tried to incorporate Smartsheet into my daily workings and hope you may be able to help. Seemingly, Excel is far easier when setting rules, but with automation needed I decided to use Smartsheet. Currently, I have a project on hold sheet which records all projects that are…
-
Checkbox if 2 Criteria Met from Different Sheet
What am I missing: I have a date and time from a master sheet, if both match want the checkbox in a second sheet I can get the the formula to work if separate but when I tray and combine they do not work Date Check Formula: check box works =IFERROR(IF(INDEX({Test Range 2}, MATCH(Date@row, {Test Range 2}, 0)) <> "", 1, 0),…