-
My formula with reference to another sheet is no longer working.
It was working fine and then just seemed to break. Below is my formula. I'm doing check for PTO which we maintain in a dif smartsheet. =IF(OR(COUNTIFS({RDI Calendar Range 1}, [Assigned To]@row, {RDI Calendar Range 2}, >=Start@row, {RDI Calendar Range 3}, <=Finish@row) > 0, COUNTIFS({RDI Calendar Range 1}, [Assigned…
-
Need help with "WEEKNUMBER" and "TODAY" formulas
Hi Community, I am having a hard time getting my "WEEKNUMBER" and "TODAY" formulas to work and I am hoping someone can point out what my mistake is. I have created a metrics sheet to count the number of action items due over then next 6 weeks. I'd like the sheet to show rolling weeks ahead. For example: Current Week,…
-
How to automatically populate a cell with same info from another cell on the same row
Hello, First time SmartSheet Community Member! I have a sheet with specific rooms locations in separate columns. What I am trying to do is automatically populate the Room column with anything that’s populated in any of the Building Room columns to the right on that same row. I thought a VLOOKUP was the best to achieve…
-
Need help creating a custom duration formula
Hi! I need help with a formula to automatically update the "duration" column each day as well as only count weekdays and not weekends. Is this possible? Here is some more information. There is a "date submitted" column. A "status" column with three options: Not started, In progress, and Complete. There is a "duration"…
-
RYG - Checkbox/Age Group
Hello, I am having an issue with figuring out how to create a formula for RYG and checkbox columns. I have previously set this formula to be based on 'open' and 'completed' requests. Since this has changed we now have 'open', 'pending', 'at risk', and 'completed' requests. The formula, in the beginning, was based on 'open'…
-
Formula Needed- Return date from week number
Hi All, I am in need of a formula that will return the date from a specific week number. We work off a unique week number calendar. Because of this, I haven't been successful using the week number formula. I hope to use 5.1.22 as week zero/launch date and have this date specified in my sheet summary. I also have a…
-
Formula - Add "Blank" as a value in IF formula
Hi Smarties, I know this is probably an easy one, but I have been cracking my head over the last 2 days so here I am! I have 4 columns representing Task 1 to Task 4. Each column has a single Drop-Down with Not Yet Started, In Progress and Completed. On the column Health, I have symbols of Red, Yellow and Green. Basically,…
-
Count Issues Resolved Today
I am trying to create a formula that will count the number of issues resolved with today's day. I've tried using =COUNTIFS({Resolved Date Range}, IFERROR(DAY(@cell), 0) = DAY(TODAY()), {Resolved Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) It counts okay, but it does not give me the correct value. Once I get that…
-
sumifs with multiple ranges
Hi there, I'm stuck in finding the right formula for this, hope someone in here can help. I have a master sheet(Demo Commission) with PO# and different agents getting different % of commsion. In the bottom sheet (Demo- John), it's John's commission in detail. It has different two columns, one for commission % and…
-
Formula for changing drop-down selection in one column when a date is entered in another column
I have a status column with drop-down options (Not Started, In Progress, Complete, N/A). I would like the drop down selection to change to Complete when I enter a date in the Complete Date column. Is this possible?