-
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),…
-
Autofill Date with Dropdown Selection
Hey everyone. I am trying to figure out how to make my sheet autofill today's date when we complete a project. We have a status column and when that column is marked "Completed" I want the Completion Date to autofill to today. I tried this: =IF(Status@row = "Completed", TODAY()) The problem is that it changes the completed…
-
How to get a tally of rows fitting relative date criteria (start date within last 30 days etc)?
Hi team, I have a Smartsheet used to track defects reported for the product I manage, and I need to report on 3 metrics. 2 of these are based on relative dates (sheet includes Start Date and Date Closed columns) and my team hasn't been able to get the formulas parsing properly. I'd appreciate any help or advice! Total…
-
IF AND Formula - Multiple Values
Ok so I answered my first question however I need the following created. The formula works however I need to add two more contract types that are part of the TRUE statement: =IF(AND([Billable Consultant/Developer Hours]@row > [Consultant/Developer SOW Hours]@row, [Contract Type]@row = "Prime"), 1, 0) Need to add…