-
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?
-
IF statement to Output Column Contact List Name
Hello! I feel like this is a fairly easy formula, but having issues populating the ACTUAL contact name vs. the TEXT value using an IF statement. Goal: In this example, when I change the status to phase 1, I would like the Current Assignee cell to populate the contact name. However it is populating the value and not the…
-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
Pull reference data from another sheet while filtering out based on a multi-select dropdown
Hello, I'm new to Smartsheet and I'm having a bit of trouble with referencing data from one sheet to another. I think this question has been asked multiple times, but I'm confused on the format of the formula's as this is a complex problem. I want to have a master 'Parts List' which is a complete list of parts with some…