-
Calculating Due dates based on different criteria
Hello, I have what I think is a complicated issue, but I know you guys can help me. I have a sheet that creates requests based on a form. On that form, is a question asking if there is a tollgate due date. If they answer in the affirmative, the Actual due date for the project defaults to that date. If there is not tollgate…
-
Summing Multi-Dropdown Values
I have a Smartsheet with a multi-dropdown where people pick multiple tests to be run. Each of those tests has a cost that I have on a different sheet. With one selection in the test column it's easy enough to do a VLOOKUP to grab the value. Is it possible to parse through multiple entries in a cell, grab their individual…
-
CountIf Date formula compare different date columns
I have 3 date columns: Start Date, Draft Due Date, Final Due Date The date columns are all initially auto-set to the same date; professionals are to subsequently update the Draft and Final due dates to a later date. I would like to count the ones that never get updated, i.e. Draft Due Date = Start Date. By the filters…
-
Calculation Quarters
Using this formula I get FY2023 Q4 (example) but if the End Date field is empty I get unparseable. How can I fix this? ="FY" + YEAR([End Date]@row) + " Q" + IF(MONTH([End Date]@row) = 1, "4", IF(MONTH([End Date]@row) = 2, "4", IF(MONTH([End Date]@row) = 3, "4", IF(MONTH([End Date]@row) = 4, "1", IF(MONTH([End Date]@row) =…
-
Having problems with finding correct formula for situation
Hello, I am needing to make a list of all the values in one column if the name is found in another column. This is a completely different scenario but this situation might make more sense than the data I am analyzing. For example, imagine in column 1 you have a list of all the students enrolled in a school. In Column 2,…
-
Workday used with subtracted dates
I am trying to calculate the time in working days that we spend in the survey phase. I've subtracted the start date from the actual complete date, which worked, but enveloping that in workday gives me the #INCORRECT ARGUMENT SET error. =WORKDAY([SSR - ACTUAL REC'D FROM SURVEY CONSULTANT]@row - [SSR - ACTUAL START]@row) I…
-
Harvey Ball formula with Expiry dates
Hello, I am going crazy, I have been through the community posts and tried to figure out this myself with no success. I want a Red ball to appear if the date in the CV Expiry Date column is less than a week away, or in the past. I want a Yellow ball to appear if the date is in the next 30 days, and Green if it's more than…
-
Tracking salary overall versus by month per person
I have a budget sheet that tracks the overall salary spent on each staff. I have a column formula that can search by name to give me the total amount spent on that staff to date ( =SUMIF([Areas of Project Spending]:[Areas of Project Spending], PERSONNEL@row, Spent:Spent)). What I need now is a new column that will total…
-
Is there a way to count cells that contain dates in Smartsheet, like Excel's COUNTA function?
-
Multiple IF statements/Managing large formula.
Hello Smartsheets Community, I was curious if anyone had some input. I've developed a sheet that runs different formulas for different "vendors" in a column to get a final price based on the vendors data. It's become a very large IF statement as there's many vendors now (if vendor is Vendor 1, *do this* etc). I'd like to…