-
Formula to return a checkbox on Sheet B, if a % column in Sheet A = 100 + move rows
Hello there, I have 2 sheets: Sheet A - Base File, where i have % Column where i input the current numbers. Sheet B - Transfer to File, where i need to add a checkbox to a row, if the % Column in Sheet A is 100 %. I have managed to make the reference where: =IF({Base File Range 5} = 1, 1, 0). BASE FILE TRANSFER TO FILE My…
-
Trouble with long date formula
Hi, I am working on something that will tell staff when the open window for a visit is, based on the visit category. Rule 1: Visits in the category of 1, 2, 3-5, 6-10, and 11+ years should be annually and the window is their DOB +/- 1 month. This portion of the formula works. Rule 2: 3rd trimester visit should start 197…
-
Manpower Projection Formula
I have multiple schedules for different projects with the same base information: Task Name (Primary) Start Work Date End Work Date Duration (Dependencies are enabled) Manpower Needed Many tasks have durations that overlap with other tasks. I want a separate manpower projection sheet that tells me each day what the total…
-
Dynamic year formula for the previous year
Hello! I would like to show the average score for the previous year without indicating specific year (instead of showing 2023 I use formula (YEAR(TODAY()) – 1. =AVG(COLLECT({Vendor Evaluation Sheet - Archive - Score}, {Vendor Evaluation Sheet - Task ID}, [Task ID]@row, {Vendor Evaluation Sheet - Archive - Created},…
-
How to split the content of one cell into separate columns
I have a cell with data in this format: Approved,AAD:tammy.couch@transcoretech.com , 9/3/2019 11:06:50 AM I already have a formula for the Status Column, which is Approved. That formula is =IFERROR(LEFT([MFG Approval (archived)]@row, FIND(",", [MFG Approval (archived)]@row) - 1), ""). It works great. However, I need to…
-
Change dot color based on date field
I am trying to come up with a formula that will change a RYG symbol to green if the date in another column is within the first 14 days of a month. The symbol column is already set up with the right column type. Thank you for the help!
-
VLOOKUP formula pulling data from another sheet
I'm using the VLOOKUP Formula to match the "Application" in table 1 to "Application Name" in table 2, then return the "Primary Product Family" from Table 2, Column 2 to "Program" in Table 1 where the formula is. =VLOOKUP(Application@row, {Applications}, 2, false) What I'm I doing wrong?
-
A way to place the Row ID (for APIs) into a cell value with formula?
For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to which records there might need a resulting update, to be done via automation, that would…
-
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…
-
How can I bring cell values from one sheet into another sheet "multiple values cell"?
Below is the source sheet destination sheet