-
Multiple SUM IFS with same criteria
I'm trying to add up staff hours when the staff assigned could fall into any of 3 categories. How can I sum them all together? This is how I've started but getting "#unparseable" =SUMIFS([Staff #1]@row = "Bethany XXX", [Staff 1 Calculated Hours]@row +SUMIFS([Staff #2]@row = "Bethany XXX", [Staff 2 Calculated Hours]@row…
-
Looking for solution to "Parent vs Ancestors" problem
Hello, I have been having tons of trouble coming up with a formula that will give me the desired result. The goal, it to populate a column with two pieces of information from other columns. In the attached image, the column "project name and header" is supposed to take the ancestor of SLS Job Number and the ancestor of…
-
Can we remove double quotes " from a csv files via a workflow?
I have a csv files I get from a OneDrive folder, but the csv file has double quotes around the text and a comma to separate them. Is there a way to remove the double quotes on work flow before the data gets passed to another sheet? I tried the function REPLACE([Project]@row, 1, 1, ""), but this did not work. What does…
-
Standardising imported date formats
Hi, I hope you are all well, and someone may be able to assist: On a sheet I am working on, a 3rd party app runs an automation that imports a date into a specified column in smartsheet. The date when imported arrives in the following format: "2023-01-04 12:26:14". There is no way to change the format which this date is…
-
Collect Most Current Per Project
We build out contracts and contract MODs on a spreadsheet, the single spreadsheet contains all contracts and MODs across all projects. I'm needing to create a column with a function that reports the most current difference between the original contract and sum of any MODs, per project, per company. Columns involved so…
-
My Gantt chart does not highlight all the parent rows
I don't know how to fix this. random parent rows are not highlighted in the gantt view. I want to use it on the dashboard, but it doesn't look good. thank you
-
Is there a formula to calculate years, months, and days between 2 different dates?
I found a formula that calculates the years and months between 2 different dates, but because it's not also calculating the days, it is rounding up the months which isn't going to work in the case that I need it. Here is a picture of what I'm looking for (how many years, months, and days) Purchase Date to Expiration Date.…
-
SUMS and IF Formulas
Hi I need a formula that sums up the value of children that are checked off in my sheet. I hope i am making sense. So i have a sheet 4 columns, qty x cost. this produces a sum then a column that has check boxes, i only want the formula to sum up those those cells that have been checked off. I hope I am explaining it…
-
Sum Collect with either or "Demand Stage"
I'm trying to collect and sum dollars from a single column if the "Demand Stage" = "(5) Approved CAR and or "Approved No CAR #". The formula show below works but gives me a $0.00 which I know isn't correct. Any help would be greatly appreciated! Thanks so much.
-
Cell links and cross sheet references breaking
Recently we've had more and more issues with cell links and cross sheet references not updating correctly. For cell links we're finding that the link breaks, unlinking and re-linking doesn't solve the issue as it just reverts to the incorrect value. A workaround is to un-link the cells, link to a different cell than the…
