Formulas
Discussion List
- Hello Smartsheet Masters, I am making a scheduler sheet for equipment slots. The sheet contains these columns: Conflict (Checkbox), Row (Dropdown list), Slot (Dropdown list, multi-select enabled), Sta…
- What should this formula look like if I also want it to ignore any tasks that do not have an end date? =IF(AND([End Date]8 < TODAY(), NOT(Status8 = "Complete")), 1, 0) Its template formula from a proj…
- I have a sheet with 2 multi-select columns. The value options for the 2 columns are the same, and are listed in a 2nd sheet. In the second sheet, I'd like to write a formula that finds the most recent…
- Hi, Is there a way for when a box is checked to have the formula below automatically apply to the Health column? Basically, we only want Critical Path items that are checked for the below to apply to.…
- Hello Community, I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the check box column and the Due Date is within the next 3 days. I've made several …
- Good morning, I am receiving a #CALCULATING error for the below formula: =COUNTIFS({Mobile Unit Data Form Range 15}, =1, {Mobile Unit Data Form Range 3}, "EMPLOYEE", {Mobile Unit Data Form Range 1}, A…
- Trying to get multiple conditions and sum up total billable. Where Manager = John Smith in one column and Invoice Date = January in another column Getting the #UNPARSEABLE error =SUMIFS(AND(Manager:Ma…
- All, You've always been good to me. I'm hoping to get across the finish line for a formula I've been working on. Here's what I have: * Start Date, End Date, Working Days within that range (could be on…
- Hi all, I'm attempting to compare data sets between 3 different sheets. Basically I want to compare our internal data to the clients data. The common denominator between all 3 sheets is a claim number…
- I am attempting to access info from another sheet. I have a list and need to attach the correct person to the item. I've tried 2 different formulas, but it's only bringing back the 1st person that it …
