-
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
Hello, I want to create a dashboard 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…
-
How to show most frequent status per unique groupings?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Index Match Multiple Criteria across sheets
I am trying to create a formula that matches criteria between two sheets, then populates a cell based on the criteria's results. The goal is to use an index/match to populate the "fee" cell in the second picture based upon the client and service level. Could someone explain how to create this formula? Thank you.
-
Solutions for Cell Link Issues in Control Center
Is anyone else experiencing issues with cell links either being stale (showing old data) or not working at all (red link indicators)? My organization uses a lot of cell linking in our blueprint and since August we have had issues with this occurring randomly throughout provisioned projects. We haven't gone a month without…
-
Index Match not working
Hello, Smart community! I have something that seems VERY simple that just doesn't want to work. I'm using Index/Match. The sheet I'm referencing has a Primary Column (QMS) with a numbering system to identify if it is a Risk (R) or Opportunity (O). I have put in 17 rows of "R"s (i.e. R01, R02, etc). The sheet I'm trying to…