Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Can i use this script in a trigger (active sheet)?
My script :
=if(GetPossibleCount(MYField)=1,GetActiveSheetId()='SH06')
Tank you
it depends on what you want to do
GetActiveSheetId returns the ID of the active sheet, something like
and I think
GetActiveSheetId()='SH06'
is always false
if you want to chech SH06
=subfield(GetActiveSheetId(), '\',2)='SH06'