- Latest Comment in Cell
Is it possible to reference the latest comment on a row, in a cell? And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opposed to opening up the comments or manually updating the cell to reflect the latest update.…
- Joining two columns together for rows that match criteria
Hello, I have a sheet with many columns from which I want to pull [Data]2 and [Data]20, in this format: "Data2 (Data20), Data2 (Data20),..." from another sheet. So far we have =IF(ISBLANK([Source1]@row), "", JOIN(COLLECT({Data2}, {Data5}, CONTAINS([Source1]@row, @cell), {Major/Minor}, "Major"), ", ")) And get Data2, Data2,…
- How do I take information from two sheets and auto populate into a third sheet?
I am trying to set up this smart sheet where it has a entity that someone can select from a drop down menu. Once they clicked any entity I had it V lookup from another sheet and it would auto generate the address for that entity from a different sheet into the cell next to it. I figured out how to do this part. I am…
- Formula for separating names
Hello all i have a smart sheet that was imported from excel and need help. Currently I only have the full name in one cell (i.e) John doe. I want to have it where it will split the first and last name into the next two cells in the same row. And then I need it to take either the full name or the two separated names and…
- Link to a Smartsheet section
I have separate Smartsheet with ties to tasks in another detailed Smartsheet. Can I create a link that goes to that particular task so that people can see all subtasks and comments? In the old days used to create anchors in HTML to accomplish this. Thanks.
- Formula to look at specific column/cell depending on the current month
你好,我想创建一个仪表板widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned projects with FTE breakdown as child rows underneath. Then I have row that calculates the total for the month. For the widget,…
- Can index+match be used to add values together?
I'm in the process of creating a series of sheets to track weights submitted by a variety of people. The people are going to be categorized by 'team', and I already have an index+match formula that takes their submissions and automatically organizes them to like a main row per person, each value going into the column for…
- So i want to know how can i sum up purchase requests based on dates
I know how to do it with COUNTIF({2023 dates }, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023)) How do I change this to add the SUM of purchase requests that only falls in quarter 1 of this year, and i can then do it for Q2, Q3, Q4
- Automatically update a form name when the Sheet name is updated
There currently isn't a way for a form on a sheet that comes on a template to automatically update once their Sheet name is updated, in Smartsheet. Could you make it such? An alternative would be to link a cell to a field in the form that would be pre-populated when a user goes to fill it out.
- Cell Linking to Blank Sheets
Is there a workaround to set up cell linking to a blank sheet? I want to set up templates so that, for instance, when a client name is entered in a field, it populates other sheets (similar to an = cell reference in Excel). But, when I try to set this up, I receive a message stating you cannot reference a blank sheet. Any…
