-
Date without time
Hi - I'm trying to add a column that has text and then pulls a date from another column. Example: Meeting date: [date from other column]. When I do this it says 8:00am and then the date. How do I pull just the date and take the time off? Where is that time coming from?
-
How do I populate the highest parent level data into another cell?
I'm using the '=PARENT([Primary Column]@row)' formula, but it's populating data from the parent row, even if the parent row is a child of another parent. I need to populate in a separate cell data from the highest level parent row. In the example below, is there a formula that would populate Primary Column row 1 data,…
-
How to avoid circular reference?
I am trying to sum purchase orders based on where the items are coming from. =SUMIFS([Bag - 55 Gal Trash]:[Bag - 55 Gal Trash], [Were these provided by the Warehouse or Job?]:[Were these provided by the Warehouse or Job?], "Warehouse") =SUMIFS([Bag - 55 Gal Trash]:[Bag - 55 Gal Trash], [Were these provided by the Warehouse…
-
I am working on a date Formula and I was able to get Feb, but it's not working for the other months?
I am putting together a KPI for my customer. I have to put how many PTD's we have for each month. The month of Feb. is working but I can not get the other months to work and could use some help.
-
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…