-
Trying to Combine a Workday Formula with a Checklist (IF) formula
Hello, see screenshot below. Trying to make a formula to calculate the Due Date 15 days prior to the Date column if the L column is checked. This is what I have so far. All attempts are either coming back to #Date Expected result or #invalidoperation: =IF(L@row = 1, "Yes", "No") = WORKDAY(Date@row, -15)
-
Can you use sum and min together
Hello, Im trying to get a min of 4 if PA points and SS points are both active then have 4 or the number that is either ss or pa add to the other columns, is that possible? Here's the formula I came up with but its not working. =IFERROR(IF(OR([Status Detail]@row = "Ready to return", [Status Detail]@row = "Transfer"), "N/A",…
-
How can I setup a multiplier formula with data in the same column?
Hi everyone, I'm looking for some help generating a formula and am not sure where to start, or what type of formula I need. I've used Smartsheet to build a budgeting template for my team. Within the budget, we have pre-set labor rates ("base pay") that are listed by position. In my labor rate column, we also have rates for…
-
JOIN(COLLECT) for multiple values formula is pulling all values in reference sheet
Hello, I have an LMS Subjects (some have multiple Subjects listed) column and an additional Subject IDs Combined column. I also have a separate sheet with all of the Subjects and ID's that go with each subject that I am referring the function to. I have tried several different options. =INDEX(COLLECT({Subjects - VLookup},…
-
sum if based on values
Hi Smartsheet Community, I would like to sum a range of cells, assigning a numerical value to the values (dropdown values) assigning a numerical value to the values in the cell. if the value is 'often' 3 points, the value 'sometimes' is 2 points, and the value 'rarely' is 1 point, I want to get the total in one cell…
-
pull value if statement help
Hi Smartsheet Community, I'm struggling with a formula. I am trying to pull the column 'Hiring Manager(s)' if the below conditions are met (below conditions are on another sheet) 'hierarchy' = 1 'Position Name' is an exact match and offer status is not 'offer sent' Thank you!
-
Help with COUNTIFS Formula for Multi-Select Dropdowns in Cross-Sheet Reference
Hello Smartsheet Community, I am currently working on a formula that needs to reside in a metadata sheet and am facing a challenge with multi-select dropdown columns. Specifically, I need to count rows from another sheet based on the following criteria: RAID Type is "Risk" Impact Type contains the substring "Business"…
-
COUNTIFS formula to pull number of overdue tasks associated with owner
I am trying to pull data for a Sheet Summary with this formula: =COUNTIFS([Owner:Owner], "jane doe", [Deadline:Deadline], "<" & TODAY()) I am getting an unparseable error, it seems to be around the () next to TODAY. What do I need to change to have my formula be correct?
-
INVALID COLUMN VALUE Error
Hello, I am receiving the invalid column value error. If the referenced cell contains either standard cuff or is blank it should return a blank value, however I am getting an error with the formula I am using, please see below:
-
Date combined in a cell
Some fabulous person helped me previously with putting 2 dates together in one cell on a sheet summary. I am now trying to do the same thing within my sheet. There are details in child rows I dont necessarily want to share with client, so Ive moved those items to a row Ive designated "project level" to move all client…