-
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…
-
Automated Reminders Based on Approaching Due Date
Hello Community, I am attempting to produce an "if/then" statement within a column of my project management smartsheet in order to create an email automation to remind the assigned user to address the aging task. Using the formula, I should be able to create conditional formatting or email automation workflows that address…
-
Pull information from report to sheet
Hello, I have a template that my team uses for data collection each time we get a new lot of diagnostic tests we need to quality check. In one folder, "data collection forms" there are many sheets, as each lot gets it's own sheet. New lots are tested every day, so the sheets in this folder are constantly being added to. We…