-
Date Output is incorrect on date formula
=IFERROR(DATE(YEAR([Effective Date]@row) + ROUNDDOWN((MONTH([Effective Date]@row) + ([Contract Term (Months)]@row)) / 12, 0) + IF(IF(MOD(MONTH([Effective Date]@row) + ([Contract Term (Months)]@row), 12) = 0, 12, MOD(MONTH([Effective Date]@row - 1) + ([Contract Term (Months)]@row), 12)) = 12, -1), IF(MOD(MONTH([Effective…
-
How to find if someone is assigned to two tasks on the same day?
Good morning, I have a sheet with due date in one column and team member assigned in another column. I want to ensure no one is assigned two tasks on the same day. I have exhausted my googling abilities and have come up empty. Any ideas here?
-
COUNTIF & WEEK
Hi All, A client wants to be able to see how many calls were logged in thier current working week . However the working week begins on a Friday 00:00am and ends Thursday 11:59pm. I'm after a formula to count all entries with the word "Aberdeen" in the Column called "Club" in the mentioned working week . This counter would…
-
Separating Table by Week
Hello, I am working on a project where I am pulling in employee utilization totals from sheets being populated by data shuttle on a bi-weekly basis to a table that calculates totals. The cloumns are basically using SUMIFs to populate the totals but I'm running into an issue where I can't separate these totals by week. I…
-
Multiplication and addition in one calculation error
Hi , I want to add a percentage to one cost then add additional costs without the percentage. Have tried various setups with Unparseable every time. What am I getting wrong?! =([valueA]@row *1.18, [valueB]@row, [valueC]@row) =([valueA]@row *1.18), [valueB]@row, [valueC]@row =(([valueA *1.18), [valueB]@row, [valueC]@row)…
-
Help counting items in a column in another sheet if between defined date ranges
Collecting the count of an item column in another sheet if the date range is between two dates. I am using this formula and it works well, but a bit labor when I have 48 that have different source and date ranges. Plus thinking of 2025, it will be a pain to redo them when the next year rolls around vs just changing the…
-
Sequential numbering based on information in another column
I'm trying to create a formula (preferably one that can be converted into a column formula) that will generate a sequential Change Order Number based on the position and number of times the Contract # is used in my sheet. I'm attaching a screenshot of what I need the finished product to look like. I'm sure I will need an…
-
Formula for Unique Values
I need a formula that will check a check box column when a project name is not unique. The check box column is "Duplicate Portfolio Name" and the name column is "Portfolio Name".
-
AND/OR Function for COUNTIF Referencing another sheet
Hello, Smartsheets Gurus! I am building a formula to reference another sheet {ISIR Pulls 2023-2024, Column EX Major (Range)} with two different EX Majors within the range I'm trying to total up. The two things I am looking to identify are EX Major "BSC" and "BSD". If I just do: =COUNTIF({ISIR Pulls 2023-2024 Range 1},…
-
How do i set up a conditional format, when i want more than one person in the assigned to column
I have each assigned to person with conditional format with a color to let them know what they are assigned to work, but what if i need two or more associates to work that particular assignment, how do i set up conditional formatting for that, or would that be a formula?