-
Re: Can you trigger an automation or conditional formatting based on grouped cells/same cell value?
@SNickNBCUniUSH I think I understand what you're trying to do. I would use a helper column (checkbox) with the following formula in it and then use that to do any formatting etc. you want to do. =IF(…1 · -
Re: Rollup Sheet vs Report Counts Don't Match
@Cesar Perez For the Environment piece, change your OR to an AND. I think that will give you what you are looking for. The way you have it it's not filtering on the Environment.1 · -
Re: Pulling a Value based on Beginning and End Date.
@NCH Try this formula. I think this is what you're trying to do. =if(COUNT(COLLECT(CSR:CSR, Beginning:Beginning, <= TODAY(), Ending:Ending, >=TODAY()))>0,INDEX(COLLECT(CSR:CSR, Beginning:Beg…1 · -
Re: Pulling a date if 2 cells match, and the date being pulled is within 7 days of a date column.
@Dakota What column are you trying to reference with @cell? I think you're missing the range of that column prior to the AND statement. Also, what are you trying to do with the @cell <= {2023 Hour…1 · -
Auto Number Unique to Each Sheet (i.e. not keep original when copied or moved from another sheet)
I would like the auto number field to always be calculated whether a new row is added directly or copied/moved from another sheet. With current functionality, if a row is copied/moved from another sh…6 ·