-
Checkbox And Text COUNTIF
Hello, I am looking for some help regarding a formula I am trying to get to work. I am trying to count of all boxes that are unchecked and have a text string that records the area STL. The check marked box represents a finished project and unchecked is unfinished and the text string represents the area of the project. I…
-
Vlookup person on other sheet, return reference if a date falls between 2 other dates - V2
Good morning, This is a follow up question on one I asked yesterday and which I closed before realizing I needed some more help: https://community.smartsheet.com/discussion/comment/289238#Comment_289238 @Bassam Khalil helped me brilliantly with the below formula but there is another variable I hadn't taken into account.…
-
Insert a line break and make specific text bold inside a concatenation formula
Hi everyone! I want to make certain specific text bold in a concatenated cell and/or insert line breaks so that the cell output is easier to read, since that is being fed to a dashboard through a report. Current output: Accomplishments: Text. Next Steps: Text. Desired output: Accomplishments: Text Next Steps: Text…
-
VLOOKUP - random responses
Having trouble with random responses from VLOOKUP. What is puzzling is that all options have been copied or transferred the same way but give a different result, any help appreciated!
-
Multiple Nested If Statements with Numbers
I'm trying to build a scoring system based on the number of times a new submission came in for different sites at my company. I have a form set up to feed into a sheet then have a background sheet with a countifs formula to get the number submitted each quarter. From there, I need to change this raw number into a score…
-
Need Formula: Per Facility per Model #, how much +/- from par level.
I need to add a column formula within the Stock Inventory Sheet, in the Qty. Above/Below Par column, that calculates per Facility per Model #, take the quantity from Order Type Stock Order Row – Facility Specific Part(s), how much above or below are we from the Par Level? So something along these lines: Per Facility, Per…
-
Formulas for a range of dates in relation to today.
I am trying to rollup data to summarize how many projects have a completion date in the next 30, 60, and 90 days. Currently, I have them set up like this. =COUNTIFS({2021 Strategic Plan Initiatives Master Range 2}, <=TODAY(30)) =COUNTIFS({2021 Strategic Plan Initiatives Master Range 2}, <TODAY(60)) =COUNTIFS({2021…
-
copy rows automation with date formula
I have two sheets - one with routine tasks, the other with a list of assigned tasks. I have an automation built into the first sheet to copy rows to the second sheet on a regular basis. The first sheet has a date column which uses the TODAY() function. I'm having a problem with items appearing on the second sheet with the…
-
[Row Name]MATCH
Hello, I want to refer to a Range that is the CHILDREN of a certain row, but the row number will move around depending on adding/deleting rows. I'm hoping to use MATCH to search for a unique string to return the row number. I know that a traditional cell reference such as [Column Name]Number will adjust if I add a row, but…
-
Vlookup person on other sheet, return reference if a date falls between 2 other dates
Hi all, I need help with the following: I need to find the contract reference of a person from Sheet 1 in Sheet 2, based on the name of the person and when the mission took place. As you can see below, James had a mission on the 16th of April, so I need the contract reference that corresponds to that date, which would be…