Bert Hoffbeck
Bert Hoffbeck
Reactions
Discussions
- I'm exporting a sheet and am trying to show the specific row number for each record. Do you know if there is a formula (i.e. =row) that will populate a cell in that record row?
- I'm using the formula =IF(ISBLANK([Citizen Doc#]@row), "", IF(TODAY() > [Citizen Exp Date]@row, "Expired", "")) that will show the word "Expired" if the conditions are met. The correct records show th…
- First, what does the term "distinct cross-sheet reference" mean? I've just run into a message that I've exceeded the 100 distinct cross-sheet references and am looking for a possible workaround. Backg…
- I've been using a simple index + match function to pull information from another sheet and for some reason on a new sheet the functionality seems to not work correctly. Specifically, it only correctly…
- We have about 17 different training activities that we track for each employee. Upon completion of the training we enter the certification date for that type of training. Most of these certification e…
- I'm not sure how to isolate the largest/latest date from a sheet that has multiple records with various pay dates for a single individual. The sheet has about years worth of entries for the company. F…
- I've tried out the conditional formatting and am unable to show different colored backgrounds for different future date conditions. As an example: I want to show the date cell to show green if it is a…
- I'd like to use the Today() instead of a hard coded date (i.e. 03/23/22) so it changes each day when using conditional formatting. Does anyone know if there is a way to do this?
- I have a formula that is properly calculating Years (Age) for a person's age if the Date of Birth (DOB) is populated, but is calculating & showing 0.00 for when the DOB field is empty/not-populated. I…
- Overview: Trying to calculate the years of service for an employee sheet that contains two columns: DOH = Date of Hire DOT = Date of Termination (Note: most values in this field are blank) Unable to f…
