-
Extract Text with variation in "key words" from different cell
Hello, I am attempting to extract a variety of words sometimes in different lengths to another cell for consistency on reports, if possible. Not sure if I am overthinking this or making a 'newbie' mistake, definitely I am not a formulas guru but usually if I tinker long enough I figure it out. I am stumped. If it is not…
-
Weekly requests Received & Sent
Hello! I am trying trying to come up with a formula for a Sheet Summary field that can output the number of received requests and number of sent requests over the course of the current week for each member of my team. I have a [Received Date] Column and a [Date Sent] Column where the dates are inputted but I just need the…
-
COUNTIF for multiple locations
Hello SmartSheet Community, I need a formula that will count the total number of locations in a multi-select drop-down column "Placement Location" and if the "SPAH Responsible" column = "Fred". This is what I've been using but will not add multiple locations selected in one row. Do I need to add a sum formula in there?…
-
Creating a formula to calculate estimated hours in next 14 days
Has anyone created a SUMIFS equation that could calculate the estimated hours in the next say 14 days? Below is what I thought would work.... but it just keeps saying "0" I want this equation to calculate the estimated hours per task/child row (HC - Project header is not checked) within the next 14 days. =SUMIFS([Est…
-
IFERROR Formula
Hi All, Hope you're keeping well. I've recently started playing with IFERROR's and updating some existing sheets. I have a sheet that reports with each row being a week of the year. Many of the formulas for "Rows in the future" or in some case, "Rows in the Past" return DIV0 or similar errors which I'm trying to eliminate.…
-
Having Issue with "COUNTIF" returns "0"
Hi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range but I got the result as "0" for everything. I have tried to change the name to execute but that doesn't work. can you please…
-
How to get the dates for every "Monday" in a month
I am working on a Flex schedule tracking sheet for employees that would like to go into the office for set days during the month. The best way I can think to do this in a form is to allow the employee to select the days of the week they would like to work in the office from a Multi-Select dropdown. ie- Monday, Wednesday,…
-
Formula to calculate the Thursday after a specific date
Hi I have a cell containing the date at which some engineering tasks are completed (Complete date). I need to display in a separate cell the release date which is the new Thursday following the Complete date (or the Complete date if the Complete date is a Thursday) In a previous thread I found the following formula which…
-
Cursor Bug when Referencing other Sheets in a Formula
Hi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I need to either click outside of the braces or hit the right key to get outside of…
-
Change status automatically when selecting % done
Hello I have searched through the Help centre (center!) and I can't find the formula (if one exists....) that will automatically select the appropriate value in the % done when one of 6 choices from Status is chosen. So when I select Not Started, I would like 0% to appear in the % Done, Started=25%, In progress=50%,…