-
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…
-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020
I am looking for help creating a formula that works with the above question. I will replicate it for each month through one fiscal year timeline. Currently I have this formula which results in UNPARSEABLE. =COUNTIF({Data Range 3X}, true), COUNTIFS({Tuning Release Date Range}, >= A11, {Tuning Release Date Range}, <= A12) I…
-
Another automate RYG balls for parent based on child
Hi, I have a project plan with multiple levels of children. Currently, the RYG automation is as follows: =IF(Status@row = "Done", "Gray", IF([Due Date]@row > TODAY(+7), "Green", IF(AND([Due Date]@row >= TODAY(+3), [Due Date]@row < TODAY(+7)), "Yellow", IF([Due Date]@row < TODAY(+3), "Red")))) What I want to do is create a…
-
Trying to Work with the VLOOKUP Function but hitting a wall
I'm attempting to access a separate sheet with some contact details for various clients. On my CLIENT SHEET I have 8 columns: Licensee, Billing Company, Contact, Contact Email, Street, City, State, Zip On my PROJECT SHEET I have various other project details, but one column is also named "licensee". In the Licensee column,…
-
Circular Reference Error Not Appearing Initially, then appears later
I've created a few summary sheets which use VLOOKUPs from my master data sheet, as well as other sheets. I've noticed that when I try to do a VLOOKUP, the formula will initially work, and pull the data as expected. However after some time, I'll re-open the same summary sheet, and see that the VLOOKUP Formula has an error…