Sign in to join the conversation:
Yet again I have hit the limit on linking cells between sheets. When will this be addressed?
I keep having to create more and more and more sheets yet keep running into this wall.
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
I have a holiday sheet for Team Members to log their holidays: Assigned To, Start and Finish Date. A formula has been created to flag the status of when they are ‘On Holiday?’: eg, ‘Holiday Complete, ‘On Holiday’ and ‘Holiday Booked’. Based on this status, an ‘Availability’ symbol also appears Id like to use this…
I am trying to do a formula that will pick up the tester and also if it is between a set of range of dates. I did one formula picking up the name, and one doing the set of dates. When I combine the two, I am not able to get it to work. Could someone tell me what I am doing wrong. I am hoping this formula will show the…
