-
How to copy the latest comment in a row to a cell?
Hi all, I'm building a new sheet where we want to use the comments function, but I'd like to have a "read only" of the latest comment left by a user and with the time a date in a cell. This would help summarize the latest detail on a report or a first look at the sheet, and then if they want to check the history they can…
-
If/And Function with a contained value
Hi Community, I'm trying to create a formula that if the supply and return temps for Boiler 1 are out of spec, then it produces a red symbol. "Equipment Out of Service" contains 1, but temperatures are in spec, then it produces yellow symbol. If "Equipment Out of Service" does NOT contain 1, and temperatures are in spec…
-
CONTAINS formula always returns no match
I have a Row Counter column created with this formula: =COUNTIFS([Task Name]$1:[Task Name]@row, OR(@cell = "", @cell <> "")) . It is designed to house row numbers so I can reference that number in another formula. I have the column Is Predecessor created with formula =IF(CONTAINS([Row Counter]@row,…
-
How to change metrics by row for Dashboard
Hi there, I have a sheet that has information for potential projects. Each project has a main row containing info that I have linked up to a dashboard. The idea is that I will pdf the dashboard with the project info, much like a proposal. I would like to make it so that I only have one dashboard and I can change the row…
-
Having trouble with Yearly calculation Formula
Hi, I have tried for 2 days to figure out a formula on the attached sheet that will tell me how many rows have a date between January 1 and December 31 of 2022 in the "Estimated Metro E Install Date" field. =SUMIF(YEAR([Estimated Metro E Install Date]@row) = 2022, YEAR([Estimated Metro E Install})
-
Use of WORKDAYS or NETWORKDAYS to return weekday date on a calculated date field
I have two kinds of calculated date fields in columns that work, but I need them to only return weekdays/workdays. Is it possible to use WORKDAYS or NETWORKDAYS on a calculated field to only return weekdays or workdays? Here are the date field examples: .....PlannedEnd2 equals PlannedStart2 plus 5 days......…
-
Is there a workaround that would equate to the IN Operator in MS Access?
I'm using Document Builder to populate an HR form that is used for multiple purposes. I have a single select drop down column with 17 pre-defined choices. Several of those choices require a new position number (PSN) to be entered and many more do not. In the instances that do not, I would like to create a formula to copy…
-
% Parent Boxes checked
Hello, I need some help in creating a formula to calculate the % of parent boxes checked -see attachment. In this case I expect the answer to be 25% as only one of the 4 parent boxes is checked. Any help would be appreciated
-
Count and Distinct Formula returns 1
Hi, I'd like to retrieve the total values excluding duplicates, this is the formula used: =COUNT(DISTINCT([Part Number]:[Part Number])) ; using the count formula only returns the total value of 3535, which is correct considering duplicated cells, I thought it was due to an error in the data format or something similar, so…
-
Automated copying using Workflow's "is Today" does not work
Hello everyone, I've been working on a project that requires automation based on conditions and criteria. So far, with the workflows I have created and tested, expectations were met. Until I used the "is Today" for a condition of a workflow. The expectation is to copy a row to another sheet if the following conditions are…
