-
Copy "Comments" with Link form cell in other sheet
Hi Community, Is it possible to copy content of the "Comments" column automatically from another sheet using "Link from cell in other sheet" ?
-
Combining data from duplicate entries
I have a form designed to send to end users of printing devices in an office to collect data on how they use their devices. Nothing is previously known about the devices or users. I want to then take that data and combine any entries that have the same serial number into 1 row of data. The Serial number is part of the data…
-
Count by event identifier
Hey ho, Looking to set up a counter of survey findings for different surveys (i.e. Oct 2018, July 2019, Dec 2020 may all have a count) recorded on one sheet so a dashboard widget will display that number. Ideally the widget can have a selection function that will allow different survey dates to be selected, or the entire…
-
Creating Dynamic Ranges of Cells from Various Sheets
I currently have a master sheet that has all my jobs in a single sheet in order to consolidate all the data I'm saving from these projects. Each project has an estimate that is a stand alone sheet named by the Job name. This job name is stored in the master job sheet. There are some specific cells I want to bring in from…
-
How to auto fill a column
Hello, I have "Sheet 1" which we work from and "Sheet 2" which we mass upload into. What I want to do is when Im in Sheet 1 and I enter a production order number, I'd like it to go look in Sheet 2 shortages and put them in the comment section in Sheet 1. how can I do that?
-
How can I copy information to a new sheet to create a log?
I'm trying to see if there's a way to have data copied from a few specific columns to a new sheet. I'm hoping to create a log for IT issues as they occur on requests. The difficulty is setting some sort of trigger that will move the information over into a new row whenever a new issue is added. The other possibility, would…
-
Formula for Star Rating that Ignores Blank Cells and O Values
I would like to Average the Star Ratings provided by seven people in the Rate Column. The formula I have in the Rate Column is NOT ignoring blank cells or cells with a 0 value. The image below shows the hidden columns that are connected to the formula. =AVG([DH#]@row, [JH#]@row, [RH#]@row, [JM#]@row, [RF#]@row, [KM#]@row,…
-
SumIFS with YTD and Month
Hello, I am trying to summarize the total of cures by branch, by year and month below is the formula I am trying to use. SUMIFS({Cure Amount}, {Date}, IFERROR(YEAR(@cell), 0) = 2021, IFERROR(MONTH(@cell), 0) = 1, {Branch}, "Triad (800)") Your help is greatly appreciate. Thank you
-
#Invalid Data Type for identical formula on one sheet that works on another sheet
Hello, I have two identical sheets to collect application data, each for a different project type. We'll call them Sheet 1 and Sheet 2. They both reference the same budget request sheet. I have a "Budget Submitted" column on each sheet, which I want set up as a checkbox. I want the box to be checked if a project name on a…
-
Check for text value in multi-value checkbox cell
Hello all, I have a smartsheet where one cell (Item type) is a multiple check-box type, with the following values: 00 Project, 01 Submittal Task, 02 Vendor Drawing, 03 Product Data, 04 Samples, 05 Production release. The smartsheet is a tracker for our submittals for our company. The engineer will enter a line item (i.e.…