-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
Merged: Cross Sheet Hyperlinks
This discussion has been merged.
-
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…
-
Error Message "Some cross-sheet formula can’t be updated"
Dear Smart Team, I am getting below error message again which cause not triggering workflow automatically. "Some cross-sheet formula can’t be updated, because this sheet has more cell referenced from other sheets than the maximum allowed (100000)" How can I get the permanent solution to avoid this error. Refer attached…
-
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…
-
Bi-directional celllinking
Currently, when cell links are created, the updates have to originate from the source cell, and then propagate through the subsequent links. Particularly in a Control Center setup, you can have 3 or more sheets that link (from the intake sheet, to a metadata sheet and then to the project plan, is one example). As an…
-
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…
-
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…
-
Cross-sheet & condition-based formula
Hi all! I need a formula that imports a reference number (auto-generated) from a column in sheet A (source) into a column in a separate Sheet B (destination), but only when a separate drop-down column in Sheet A changes to a specific value. Using a filtered report in lieu of Sheet B is not an option (at least not…
-
Mass Uploads and multi-sheet interaction
Hey all. This is likely a stupid question that has been answered before. None of the searches I have done have had quite the answer I was looking for. I am working my way through the core app learning path, but I haven't found what I am looking for. There are what feel like hints of it, but nothing that has clicked for me.…
