-
IF/OR Statement
Good morning everyone, first of all, thank you to this community, you have all been a huge help, as someone who had very limited excel/smartsheet skills, this community has helped a lot! My organization has several departments and in our office one individual is responsible per department. Although long, my formula looks…
-
Index/Match - Return the lowest row for multiple matches
I have an automation created that copies the row from the "Wetcast" sheet to a "Discard" sheet. From the Discard sheet, I want to return the "Ready to Ship Date" at the bottom most row into the "Previous Ready to Ship Date" cell in the Wetcast Sheet. The identifier/match value is the "ID" (GWC####). This is the formula…
-
Date 'is between'?
Hi, I'm wondering what's the best way to capture dates that fall between Start Date and End Date. For instance, I'm using a COUNTIFS calculation which returns all rows with a Start Date of '>= 1/1/2021, and an End Date of '<= 31/1/2021, but that won't capture rows that start on 10/12/2020, and end on 2/2/2022; even though…
-
Formula to count how many people will be in the office specific day(s)
I have 2 sheets and I'm trying to populate how many people will be in the office on specific days. One sheet has the specific date(s) and where the sum value should be and i need to gather from another sheet who is coming in on the specific days. I tried formulas but kept getting an error.
-
Multiple Projects- Dashboard to track on time delivery
I manage multiple projects, about 20, each with their own project plan sheet. I'd like a report or dashboard that shows me across all the project sheets how I am tracking based on a due date. As shown in the attached project example, I always have a last task which is Project Complete. I'd like to make sure that the…
-
When move/copying rows, how to prevent new columns being added in the destination sheet.
In Smartsheet's article, it's stated that "If the source sheet contains columns that the destination sheet does not, these columns will be created in the destination sheet when the row is moved or copied." Is there anyway to prevent this from happening? i.e only information in matching columns will be moved to the…
-
Return a value of 1 if two boxes are checked
Hello! I am looking for the formula to return a value of 1 if two boxes in the same row are checked. Please see the example below. If both boxes in DU and Scheduled are checked, the formula returns a value of 1. If only 1 box is checked, it returns a 0. Any help is much appreciated!
-
RYG Balls on Simple Formula
Hi...simply I want to show a red ball if my value is less than 1, green if it is greater than 5 and yellow if between? I'm missing something? =IF([Operations Metric]1 < 1, "Red", IF([Operations Metric]1 > 5, "Green", IF([Operations Metric]1, "Yellow")))
-
Formula to Cut and paste Last 5 Digits into another cell
Hi there, Is there a way to Cut and paste Last 5 Digits into another cell? Example A1 has: 12345678, can I cut 45678 and paste into B1, using the same formula, for the entire column ? (I know about the remove first or last digits, but is there a way to cut and paste?) Thank you for your help!
-
Combinations of seperate checkbox in rows activating a single count
Hello team! I am trying to categorize 4 different types of work and then also capture how much of each type of work we are approved for. I have four seperate columns of check boxes for different types of work and then a fifth for if the work is approved. the rows have the specific data for the specific work. How can I…