-
Formula for always populating one cell if it's parent cell is populated with text
Hi all, Still trying to play with formulas. Below is a screen shot of my situation. If there is text in the mRNA-#, CX-#, next to the RNA # MFG Dates, I want that same text to be in cell below highlighted. I want to template this MFG Info, I don't want to use the "=" it will be tedious to do every time. Can someone find a…
-
Calculating Metrics for Duration of Time
We have the following formula on a metric sheet to show number of support requests between weekly meetings however those meetings are now every other week and I cannot figure out how to change the formula to reflect that; has anyone done this before? The current formula is... =COUNTIFS({Request Tracker Range 3}, OR(@cell =…
-
Formula to update status on a parent row based on child row with OR statement
Hi - I need a formula to update the status on the parent row based on status values in the child rows below. I am wresting with this formula and hoping someone on here can point me in the right direction. I found this post which is exactly what I'm looking for but there was never an answer to her last comment about needing…
-
NETWORKDAY function NOT giving me "0" when the two dates that I am comparing are the same.
I am using the formula below and I am not getting the results that I would expect. =IF([Date Completed]@row = "", "", NETWORKDAY([Original Due Date]@row, [Date Completed]@row)) example 1 [Original Due Date] 03/16/21 and [Date Completed} 03/16/21 I would expect to get back "0" because there is no difference in the dates but…
-
Need help with a VLOOKUP formula
Hi all, Just to be upfront, formulas are my Achilles heel, so I'm not sure if I'm doing this right. My company has a Lucidchart training coming up, and we've created a sheet/form that will list out everybody who has filled out the form and has expressed interest in the training. I've also imported another sheet that lists…
-
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…
