Sign in to join the conversation:
Since I can't mask/apply sufficient conditional formatting to highlight a improper SS, I've parced it out into various columns and then was applying CF to each particular column. However, when applying CF to the row it doesn't see the 'number' as it's actually a calculation… Is there a way for it to focus on the cell contents rather than the VARCHAR? (e.g., for SS Prefix, the conditional formatting would read 'IF SS Prefix is <100 OR >999 OR not a number the apply this format to the Social Security Number' For some reason, it's not seeing 548 I believe it's seeing the formula that is producing the 548 '=MID([Social Security Number]@row, 1, 3)' Is there a better way to have it focus on the 548 that's in that cell??
I just tried to create my first dashboard using the timeline chart widget. I have set it to open the source data when clicked however it does not work. I've done this multiple times without success. It seems this is not actually an option even though you can select it in the settings. Can someone verify this or is there…
Hello, I have two sheets. One is "Current tasks" and one is "Completed tasks". I have the rows (individual tasks) auto number when entered (2026-001, 2026-002, etc.). When the row is marked complete, it is moved to the "Completed task" sheet. The problem I am having is that when the row is moved the other tasks that remain…
Do you use the standard {Sheet Name - Column Name} ? Or do use a simple name that can be easily identified? Or Do you use abbreviations? Im curious and would like to know your approach, Im hoping I could learn a lot from your experience.
