Paul Newcome
Paul Newcome
-
Re: I am getting an invalid data type when the IF function pulls the false statement which is blank inst
My next guess would be that there are instances where your INDEX/MATCHes aren't pulling in dates. This could also throw that error when using date based functions such as YEAR, MONTH, and DAY. Try wr…1 · -
Re: change cell value with SUBSTITUTE formula
In that case, you would use an INDEX/MATCH. =INDEX({Reference Sheet Name Column}, MATCH([Column2]@row, {Reference Sheet Match Column}, 0))1 · -
Re: Help revising IF statement for Business days (NETWORK DAYS) rather than Calendar Days
Try this: =IF(Parent@row <> 1, IF([Certification Complete]@row <> "Green", IF([Workflow Initiated]@row <> "", WORKDAY([Workflow Initiated]@row, 14)))) There is n…1 · -
Re: How to get sheet owner information
If the get_sheet doesn't work for at least retrieving the owner, getting the sheet shares should do the trick.1 · -
Re: Make conditional formatting refresh all source pages for report and dashboard accuracy
You can insert a hidden date type column then use a Record A Date automation set to run daily to record the date in the hidden column. This will force refresh your sheet and in turn solve your issue.1 ·
