Ronderbecke
Board Regular
- Joined
- Oct 4, 2017
- Messages
- 73
I currently have a filter formula that works great to pull my data; however, I was wondering if there is a way to make it give show something different than what is pulled? Currently it pulls the date of install and I simply want it to be a check box. Is it possible to make that happen in the filter command? Here is what I have:
=Filter('Travis Jones'!G9:G, (MOD(ROW('Travis Jones'!G9:G)-Row('Travis Jones'!G9)+1,12)=1))
This is what I tried (along with a whole bunch of other combinations):
=IF(Filter('Travis Jones'!G9:G, (MOD(ROW('Travis Jones'!G9:G)-Row('Travis Jones'!G9)+1,12)=1))>0,"☑","")
But it just leaves all the cells blank? Any help would be really appreciated.
=Filter('Travis Jones'!G9:G, (MOD(ROW('Travis Jones'!G9:G)-Row('Travis Jones'!G9)+1,12)=1))
This is what I tried (along with a whole bunch of other combinations):
=IF(Filter('Travis Jones'!G9:G, (MOD(ROW('Travis Jones'!G9:G)-Row('Travis Jones'!G9)+1,12)=1))>0,"☑","")
But it just leaves all the cells blank? Any help would be really appreciated.
