-
Can't Find Option to Reference Another Sheet with new AI-enabled design
I was a away from Smartsheets for a few weeks while switching jobs and I can't find some stuff now. A month ago, when doing formulas that had the capability for a cross-sheet reference, Smartsheet would offer you a link to "Reference Another Sheet". Smartsheets a month ago: Now, when I try to use a formula, a pane on the…
-
Automation to add links in a column in origin sheet from destination sheet.
Hi, I set up an automation to copy a row from someone's intake sheet when they assigned it to my team into my intake sheet. We did this so we didn't miss any of the metadata they are capturing. Can I set up an automation that copies a column that has "DAM Link(s)" from my intake sheet back into the original intake sheet…
-
Child row and Multi- contact cell selections
I am currently developing a portfolio management system in Smartsheet to centralize our work. To accommodate multiple project owners, we are utilizing a multi-select contact cell. When a user is assigned as an "owner," the initiative appears on their individual summary sheet. However, we have encountered a challenge: in…
-
Smart Sheet & Resource Management - Functionality
I'm wondering if a) Smartsheet is working on the issue and b) if anyone has a workaround. I'd like to see the status of a task, as it's marked is RM connected to a column in Smart Sheet
-
INDEX, MATCH formula referencing other sheet works incorrectly when matching formula column
Formula that I am using is the following: INDEX({Range 1}), MATCH({Search value}, {Range 2}, 0)). In this formula Range 1 and Range 2 referencing another sheet and Search value referencing the value in the current sheet. The value in the current sheet is also based on formula and when using INDEX, MATCH with search value…
-
Automatic Workflow Question
I am trying to copy the data from a Business Problem cell to a Project Description cell without impacting/changing previous entries. Is it possible to create a single automation workflow that copies/replicates data from "Business Problem" into "Project Description" in the same worksheet? I tried the column formula route…
-
Combining SUMIF( and AND( Formulas
I am attempting to sum a large amount of data into totals based on unit, month, general ledger title, so for example: get a total $ amount for Misc Income in the month of July for X Unit. I'm getting an #UNPARSEABLE error. Are there any clear errors here? I cannot figure it out. =SUMIF({CEAS Budget v Actuals Testing Range…
-
NEW PM Porfolio Template questions
In the Project List, I would like to link a project update cell located in each Project Plan to a cell in the Project List. The project list only gives me the option to link a column. How can i link data to come into the Project List? I can link data out.. When I attempt to link by column, the target column in the project…
-
Linking dropdown options to member lists
I'm checking out the new Linked Columns feature in Table View and loving the idea of it, and that has me wondering if there's currently a way to link the options in a dropdown to the current list of all people in a Group within our smartsheet team. Example: I have a group that contains all users who are on our inspection…