-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
How do I customize a request ID based on specific form selections?
iaI know how to create a request ID on the column grid but I wonder if I am able to customize based off of specific selections on form submissions. For example, Jane Doe selected content management (CM) in her form submission so the request ID would reflect that (Request ID: CM_0001), where John Smith selected quality…
-
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…
-
checkbox formula for last 30 days
Hi, I have a date column which lists down all the dates in the year and a checkbox formula. In the checkbox column, I would like to insert a formula that would perform the following function for me: If the date in the date column (row@cell) is in the last 30 days then checkbox.
-
Formula based on the date that a certain cell was modified?
I was wondering if it is possible to create a formula that changes one cell to a date when another cell was modified: I have two columns I want affected: 1) Status, 2) Closed Date. When the status is changed to "Closed" (it is a dropdown column), I want the closed date column to input the date that the status was changed…
-
Percentages lost when indenting linked cells aka best way for roll up smartsheet
Hello I am trying to connect about 50 project plan sheets on one sheet. The requested configuration is a traffic indicator for a customer then the ability to drill down to see each customer project and status then a drill down for high-level milestones. FYI I have just read about the limitations so I understand eventually…
-
WEEKNUMBER formula: fix issue when 31th december is in mid week
Good afternoon from Spain. I faced an issue with WEEKNUMBER formula. 30th december is monday, 31th december is tuesday. If we calculate their weeknumber, the answer is '1'. This behavior is incorrect. 30th and 31th december should be = 53 (week number). I wanna ask to fix this. When one of the last days of december are is…
-
Formatting in Formula Cells
I have two date cells that I have formatted as long dates (May 30, 2018) titled Contract_Begin and Contract_End. I want the formula cell to read contract begin date through contract end date (for ex: May 30, 2024 through August 10, 2024). However, the cell formats to 5/30/24 through 8/10/24. I posted the formula I am using…
-
Automation help or formula for connecting rows
AW Placement request form below takes in all of the school placement requests via a form. Once the column AW REQUEST STATUS is 'approved by leader' it is automatically moved to Students/Instructors - AWI The ANCHOR ID transfers over from AW placement request sheet to students\instructors - AWI - when approved by leader…