-
Link Columns to another sheet dependent on answer to question
For all exams listed on our Assessment sheet , if no incidents during the exam occur, is there a way to streamline by cross-referencing the Assessment sheet to populate specific columns in the incident report sheet instead of completing a separate report? I'd like a user to go into the assessment sheet, scroll to the…
-
Grouping Columns
Hello, I am trying to track data by year for different buildings. I have three pieces of information that need to be tracked per year. Is it possible to group columns together to signify that they belong to a certain year? Thank you
-
Hyperlinks in Linked Cells and Cross Sheet Formulas
I'd love to be able to add a hyperlink to a cell that links in a value from another sheet. Currently we're unable to do this as linking cells blocks the ability to add a hyperlink. This would add more versatility, particularly with trackers, as you'd have the ability to pull in valuable information while also linking to a…
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
Countifs Past 90ds referencing another sheet
Hi, I am trying to make a dashboard that shows the top 10 pieces of equipment with the highest number of issues in the past 90d. I have my primary sheet that collects the data (Primary), and a reference sheet I am using to collect a count. I am just struggling to have it filter the last 90d. Showing #invalidoperation…
-
Help with TIME() Formula
Hello, I am testing out the TIME() function and working on a formula to determine the amount of hours and minutes elapsed between a Start and Finish columns. I thought I had it figured out, however, I noticed that for my row that has a Start time of 3 pm and a Finish time of 5 pm, it was showing a time difference of "1…
-
Naming Manager, Data Slicer, and Table reference functions for formulas, and LET, Unique, Sequence
Excel has leapfrogged Smartsheet in terms of ability to utilize data set, naming manager, dynamic data slicing, Dynamic Table formatting in excel sheets and new formula types LET used with Naming Once as reference, Unique provide back only unique values, Sequence able to order data values via formula, and several other…
-
Autofill child row cells with information from parent rows
Hi! I am trying to get my Smartsheet to autofill information in some cells based on the parent row. The sheet is mainly viewed in card view so when my teammates add subtasks they don't fill in basic info like the team working on the project since that is already in the parent task card. I tried a basic =parent but that…
-
Need report that only shows fields that are NOT blank
Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column will vary widely but some will be blank, and I do not want to show the rows that are…
-
Linking Sheets - Master sheet with multiple related sheets
Hi! I am looking to create a master sheet that contains personnel data elements used by multiple teams with different needs. The master sheet should allow data entry of new attendees while also pulling new entries from a related travel sheet. Example: Master Sheet Admin is aware of a new registrant and manually adds to the…